Featured Listings in the Charlotte County and Sarasota County areas
Please contact us directly at info@suncoasteam.com or call us at 941-475-3600 (toll-free: 800-741-4521) for more information on any of these properties.
";
// Get the listings
$mlsquery = mysql_query(" SELECT * FROM mls
WHERE PROPERTY_TYPE_CODE != 'R'
ORDER BY SALE_PRICE ASC
LIMIT 25
") or die("Bad query: " . mysql_error());
/***************
$mlsquery = mysql_query(" SELECT * FROM mls WHERE MLS_AGENT_NAME LIKE '%LEONARD, ANDY%' OR MLS_AGENT_NAME LIKE '%MULLIGAN, JAMES%' ORDER BY SALE_PRICE ASC ") or die("Bad query: " . mysql_error());
*******************/
/***************
$mlsquery = mysql_query(" SELECT * FROM mls
WHERE PROPERTY_TYPE_CODE != 'R'
ORDER BY SALE_PRICE ASC
LIMIT 50") or die("Bad query: " . mysql_error());
*******************/
include ('incs/displaylistings2.php');
?>