if (!isset($_REQUEST['view'])): ?>
Property Features
Featured Properties
-
// view featured listings
$featuredquery = "SELECT DISTINCT property_id, title, city, state_id, postal, leader FROM property WHERE status = 'active' AND featured = 1 ORDER BY city";
$featuredresult = mysql_query($featuredquery);
if ($featuredresult && mysql_num_rows($featuredresult)) {
while ($featuredrow = mysql_fetch_assoc($featuredresult)) {
?>
-
=$featuredrow['title'];?>
=loggedIn()?$featuredrow['city'].', '.implode($states->xpath("state[@id='$featuredrow[state_id]']/@abbrv")).'
':''?> =$featuredrow['leader'];?>
}
}
?>
Other Properties
-
// view featured listings
$featuredquery = "SELECT DISTINCT property_id, title, city, state_id, postal, leader FROM property WHERE status = 'active' AND featured = 0 ORDER BY city";
$featuredresult = mysql_query($featuredquery);
if ($featuredresult && mysql_num_rows($featuredresult)) {
while ($featuredrow = mysql_fetch_assoc($featuredresult)) {
?>
-
=$featuredrow['title'];?>
=loggedIn()?$featuredrow['city'].', '.implode($states->xpath("state[@id='$featuredrow[state_id]']/@abbrv")).'
':''?> =$featuredrow['leader'];?>
}
}
?>
Property Detail
// view property $propertyquery = 'SELECT * FROM property WHERE property_id = "'.$_REQUEST[view].'"'; $propertyresult = mysql_query($propertyquery); if ($propertyresult && mysql_num_rows($propertyresult) && loggedIn()) { $propertyrow = mysql_fetch_assoc($propertyresult); ?> =$propertyrow['title']?>=implode($counties->xpath("county[@id='$propertyrow[county_id]']/@label"))?> County - =$propertyrow['city']?>, =implode($states->xpath("state[@id='$propertyrow[state_id]']/@abbrv"))?> =$propertyrow['postal']!=0?$propertyrow['postal']:''?>
Asking: $=number_format($propertyrow['asking'])?>
=$propertyrow['size_lot']!=0?'Lot Size: '.number_format($propertyrow['size_lot']).' sf
':''?>
=$propertyrow['size_building']!=0?'Building Size: '.number_format($propertyrow['size_building']).' sf
':''?>
Property Features
-
$featurequery = "SELECT * FROM feature ORDER BY label";
$featureresult = mysql_query($featurequery);
if ($featureresult && mysql_num_rows($featureresult)) {
while ($featurerow = mysql_fetch_assoc($featureresult)) {
$mapCheck = 'SELECT * FROM property_features WHERE property_id LIKE "' . $propertyrow['property_id'] . '" AND feature_id = ' . $featurerow['feature_id'];
$mapResult = mysql_query($mapCheck);
if ($mapResult && mysql_num_rows($mapResult)) {
?>
- =$featurerow['label']?> } } } ?>