function dateDiff($start, $end) { $start_ts = strtotime($start); $end_ts = strtotime($end); $diff = $end_ts - $start_ts; return floor($diff / 86400); } $dbhost = 'scl-bbb.db.sonic.net'; $dbuser = 'scl_bbb-admin'; $dbpass = 'c51e9d53'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql'); $id = $_GET["q"]; $dbname = 'scl_bbb'; mysql_select_db($dbname) or die("Unable to select database"); $query = "SELECT * FROM PROPERTIES WHERE ID='$id' and (ACTIVE='1' or IN_PROGRESS='1')"; $result = mysql_query($query); $num = mysql_numrows($result); mysql_close(); // best practice if ($num == 0) { print "
Sorry, no listings match your search.
"; } else { $id = mysql_result($result,$i,"ID"); $address = htmlentities(mysql_result($result,$i,"ADDRESS")); $address_pdf = str_replace(' ', '_', $address); // used to reference name of PDF file $address_trim = strtolower($address_pdf); // used to reference images, etc. $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"); $youtube_id = mysql_result($result,$i,"PHOTOTOUR_ID"); $google_map = mysql_result($result,$i,"GOOGLE_MAP"); $alt_google_address = mysql_result($result,$i,"ALT_GOOGLE_ADDRESS"); $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 = ""; } # ------------------------------------------------------------------------------------------------------------------------------------ $title = "Sonoma Coast Living Office Listing Detail | $address, $location"; $keywords = "Frank Howard Allen Realtors, California Real Estate, mls, Bodega Bay Real Estate, golf, golf course sale, Real Estate Sales, Sonoma Coast Real Estate, Realtor, Real Estate Agent"; $description = "Real Estate Agency Specializing in Luxury Homes on the Sonoma Coast in Bodega Bay, CA"; require "../../application.php"; require ROOT."interface/document.header.php"; require ROOT."interface/page.header.php"; ?>Proudly offered at $ . Click on any photo below to view the photo gallery.
Back to All Listings |
Printable PDF Flyer |
Map