inradius($zip,$ziprange,"".$db_prefix."zipcodes"); /* echo "There are ",count($zipArray)." Zip codes within $ziprange Miles of $zip"; echo '
';
print_r($zipArray);
echo '
'; */ if(is_array($zipArray) && count($zipArray) > 0){ $zipstring = "AND c.zipcode IN ("; foreach($zipArray as $value){ $zipstring .= "'$value',"; } $zipstring = substr($zipstring,0,strlen($zipstring)-1).")"; } }else{ $zipstring = "AND (c.zipcode LIKE '%$zip%' OR '$zip'='')"; } } /************/ //print "
Cookies : "; //print_r($_COOKIE); //print "
"; /************/ /******* GET ORDER OF DISPLAYING FEATURES ************/ $f_sql = "SELECT * FROM ".$db_prefix."feature_options order by feature_order"; $feat_order = @mysql_query($f_sql) or die('Query failed: ' . mysql_error()); $filterKeyword = "AND (c.features LIKE '%$keyword%' OR '$keyword'='' OR c.laddress LIKE '%$keyword%' OR c.lcity LIKE '%$keyword%' OR c.lcounty LIKE '%$keyword%' OR c.schools LIKE '%$keyword%' OR c.zipcode LIKE '%$keyword%' OR c.category LIKE '%$keyword%' OR c.mls LIKE '%$keyword%' OR c.comments LIKE '%$keyword%') "; //echo "Model: $type"; $sqlCnt = "SELECT COUNT(c.id) FROM ".$db_prefix."listings AS c INNER JOIN ".$db_prefix."sellers AS d ON d.id=c.member_id WHERE d.status='Active' AND (c.mls LIKE '%$mls%' OR '$mls'='') AND (c.category LIKE '%$category%' OR '$category'='') AND (c.bath >= '$bath' OR '$bath'='') AND (c.beds >= '$beds' OR '$beds'='') AND (c.price >= '$min_price' OR '$min_price'='') AND (c.price <= '$max_price' OR '$max_price'='') ".$filterKeyword." ". //AND (d.zip LIKE '%$zip%' OR '$zip'='') $zipstring." AND (c.member_id='$dealer_id' OR '$dealer_id'='')"; include('include/paging.php'); //print_r($_COOKIE); /************ PREDEFINED SORTING (by id ASC) ************/ if(!isset($_GET["SortCol"],$_GET["SortType"])) { $SortCol = "c.zipcode"; $SortType = "ASC"; } else { $SortCol = $_GET["SortCol"]; $SortType = $_GET["SortType"]; } if($_GET["DisplayType"]=="G" or $_GET["DisplayType"]=="G") { $Display = "G"; $DisQuery = ""; } else { $Display = ""; $DisQuery = "G"; } $stats_month = date('F'); $stats_year = date('Y'); $sql = "SELECT d.company, c.member_id, c.id, c.beds, c.bath, c.price, c.comments, c.special, c.stored, c.stock, c.zipcode, c.laddress, c.category, c.mls, c.acres, c.sqft, c.lcity, c.lstate, c.lcounty, c.yrbuilt, c.schools, c.features, d.zip, d.address, d.state_id, d.city, d.website, d.contact_name, IF(TO_DAYS(NOW())-TO_DAYS(c.stored)<=7,'yes','no') AS is_new_listing, d.featured AS dealer_featured, IF(rsr.id IS NULL,'no',rsr.id) AS results_stat_id FROM ".$db_prefix."listings AS c INNER JOIN ".$db_prefix."sellers AS d ON d.id=c.member_id LEFT JOIN ".$db_prefix."results_stat_report AS rsr ON (rsr.stock=c.stock AND rsr.member_id=c.member_id AND rsr.year = '".$stats_year."' AND rsr.month = '".$stats_month."') WHERE d.status='Active' AND (c.mls LIKE '%$mls%' OR '$mls'='') AND (c.category LIKE '%$category%' OR '$category'='') AND (c.bath >= '$bath' OR '$bath'='') AND (c.beds >= '$beds' OR '$beds'='') AND (c.price >= '$min_price' OR '$min_price'='') AND (c.price <= '$max_price' OR '$max_price'='') ".$filterKeyword." ". //AND (d.zip LIKE '%$zip%' OR '$zip'='') $zipstring." AND (c.member_id='$dealer_id' OR '$dealer_id'='')"; $sql.=" ORDER BY c.special ASC "; if(isset($SortCol,$SortType) && $SortCol!="") $sql.=", $SortCol $SortType"; $sql.= " LIMIT $pagingStart,$pageSize"; $rs = @mysql_query($sql) or trigger_error('Error on executing '.$sql, E_USER_ERROR); if(mysql_num_rows($rs)>0) { $searched_cars = mysql_num_rows($rs); $sqlStatReportInsert=""; $sqlStatReportUpdate=""; /***********SHOWS UP IN SEARCH RESULTS STATISTICS*******************/ if(!session_is_registered("ses_results_stats_time")) { session_register("ses_results_stats_time"); $_SESSION["ses_results_stats_time"] = time(); } if(!session_is_registered("ses_results_stats_stocks")) { session_register("ses_results_stats_stocks"); $_SESSION["ses_results_stats_stocks"] = "-1"; } $array_results_stats_stocks = explode(",",$_SESSION["ses_results_stats_stocks"]); //die($_SESSION["ses_results_stats_stocks"]); while($rowResultStat = @mysql_fetch_array($rs)) { if(!in_array($rowResultStat['stock'],$array_results_stats_stocks) || (time()-$_SESSION["ses_results_stats_time"]>$track_visitor_limit_time*60)) { if($rowResultStat['results_stat_id']=='no') { $sqlStatReportInsert .= "('".$rowResultStat['member_id']."', '".$rowResultStat['stock']."', '".$stats_year."', '".$stats_month."', 1 ),"; } else { $sqlStatReportUpdate .= $rowResultStat['results_stat_id'].","; } } if(!in_array($rowResultStat['stock'],$array_results_stats_stocks)) $_SESSION["ses_results_stats_stocks"] .= ",".$rowResultStat['stock']; } @mysql_data_seek($rs,0); if($sqlStatReportInsert!="") { $sqlStatReportInsert = substr($sqlStatReportInsert,0,strlen($sqlStatReportInsert)-1); $sqlStatReportInsert = "INSERT INTO ".$db_prefix."results_stat_report (member_id,stock,year,month,cnt) VALUES ".$sqlStatReportInsert; @mysql_query($sqlStatReportInsert) or trigger_error('Error on executing '.$sqlStatReportInsert, E_USER_ERROR); } if($sqlStatReportUpdate!="") { $sqlStatReportUpdate = substr($sqlStatReportUpdate,0,strlen($sqlStatReportUpdate)-1); $sqlStatReportUpdate = "UPDATE ".$db_prefix."results_stat_report SET cnt = cnt + 1 WHERE id IN (".$sqlStatReportUpdate.")"; @mysql_query($sqlStatReportUpdate) or trigger_error('Error on executing '.$sqlStatReportUpdate, E_USER_ERROR); } $_SESSION["ses_results_stats_time"] = time(); /***********END SHOWS UP IN SEARCH RESULTS STATISTICS*******************/ } else $searched_cars = 0; if($dealer_id!="") { $sqlDealer = "SELECT d.company AS dealer_company FROM ".$db_prefix."sellers AS d WHERE d.id=".$dealer_id; $rsDealer = @mysql_query($sqlDealer) or trigger_error('Error on executing '.$sqlDealer, E_USER_ERROR); if(mysql_num_rows($rsDealer)>0) list($dealer_company) = mysql_fetch_array($rsDealer); } if(!isset($common_page_add)) $common_page_add = ""; ##################################################################################################################### include('common/head'.$common_page_add.'.php'); ?>
 
 
 
 
 

Our Featured Real Estate Listings

Currently, we do not have any listings in inventory that match your search. Please search again.

"; ?>


/" width="" height="" alt=", " /> <?php echo $row[, " />
">,  Bed(s),  Bath(s),  Square Feet
0) { mysql_data_seek($feat_order, 0); //reset the recordset before moving on } $maxLength = 200; $temp = $new_feat.$temp; echo substr($temp, 0, $maxLength); if(strlen($temp) > $maxLength) { echo "..."; } ?>
****";} ?>
?key=" />
"; }else{ echo "";} ?>


1) include("include/paging_nav_public3.php"); ?>

 


  Home - MLS Search - Buyers - Sellers - Listings - Area Info - Contact Us - Site Map - Terms


 Additional
Property
Search
Options


Image 1
CLICK HERE TO FIND YOUR NEW FRONTDOOR!


Image 2
CLICK HERE TO VIEW
ALL PELICAN PROPERTY
LISTINGS

Image 2
LET US FIND
YOUR NEW
FRONTDOOR
FOR YOU!

 

 







  



This site produced by:
 		 

 

Serving Florida's Emerald Coast including
Destin, Fort Walton Beach, Sandestin, Walton County, Santa Rosa Beach, and 30A..
We are your Real Estate Property solution.
All images and information, copyright Robert Earl Ward - 2007