Sonoma Coast Living Office Listings
Sorry, no listings match your search.";
} else {
if ($q == "404") { // custom error message for 404
print "
![\"Page](\"/images/icons/warning.png\" "\\"Page")
We're sorry. The webpage you are looking for can't be found. Instead, below you will find Our Office Listings.
";
}
print "
";
$i = 0;
while($i < $num) {
$id = mysql_result($result,$i,"ID");
$address = htmlentities(mysql_result($result,$i,"ADDRESS"));
$address_trim = strtolower(str_replace(' ', '_', $address));
$location = htmlentities(mysql_result($result,$i,"LOCATION"));
$price = number_format(mysql_result($result,$i,"PRICE"),0);
$price_reduced = mysql_result($result,$i,"PRICE_REDUCED");
$in_escrow = mysql_result($result,$i,"IN_ESCROW");
$type_sort = mysql_result($result,$i,"TYPE_SORT");
$description_long = htmlentities(mysql_result($result,$i,"DESCRIPTION_LONG"));
$date_listed = mysql_result($result,$i,"DATE_LISTED");
$today = date('Y-m-d');
$dom = dateDiff($date_listed, $today);
if ($dom > 60) {
$new_listing = 0;
} else {
$new_listing = 1;
}
if ($new_listing && $price_reduced && $in_escrow) {
$tag_line = "
New Listing! | Price Reduced! | In Escrow!";
} else if ($new_listing && $price_reduced) {
$tag_line = "
New Listing! | Price Reduced!";
} else if ($new_listing && $in_escrow) {
$tag_line = "
New Listing! | In Escrow!";
} else if ($price_reduced && $in_escrow) {
$tag_line = "
Price Reduced! | In Escrow!";
} else if ($new_listing) {
$tag_line = "
New Listing!";
} else if ($price_reduced) {
$tag_line = "
Price Reduced!";
} else if ($in_escrow) {
$tag_line = "
In Escrow!";
} else {
$tag_line = "";
}
if ($j != $type_sort) {
if ($type_sort == 1) {
$type = "Residential";
} else if ($type_sort == 2) {
$type = "Investment";
} else if ($type_sort == 3) {
$type = "Lot/Land";
} else {
$type = "Lease";
}
print "| $type |
";
$j = $type_sort;
$noHr = 1;
} else if ($i && $i != $num) {
print "
|
";
}
print "![\"$address,](\"/images/listings/$address_trim/thumbs/$address_trim"; "\\"$address,") | $address, $location$tag_line
$description_long
Proudly offered at \$$price";
if ($type_sort == 4) { print "/Month"; } // 4 is a lease
print ". |
";
$i++;
}
print "
";
}
?>
email updates for properties, land, etc.