SELECT *, CASE WHEN `name` LIKE "port charlotte%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "port charlotte" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "port charlotte" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "port charlotte" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "FL" AND (locality IN ("port charlotte") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 4
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 4
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$997,50015140 Acorn CirPort Charlotte FL 33981View Listing
$995,00010549 Washington RdPort Charlotte FL 33981View Listing
$994,9992257 Jacobs StPort Charlotte FL 33953View Listing
$989,50015356 Alsask CirPort Charlotte FL 33981View Listing
$989,0002162 McCleod StPort Charlotte FL 33953View Listing
$950,00015264 Hennipen CirPort Charlotte FL 33981View Listing
$950,000291 Fields Ter SEPort Charlotte FL 33952View Listing
$949,90010424 Rainsville StPort Charlotte FL 33981View Listing
$949,90015220 Taurus CirPort Charlotte FL 33981View Listing
$949,90015156 Taurus CirPort Charlotte FL 33981View Listing
$949,9003519 Montgomery DrPort Charlotte FL 33981View Listing
$949,00016999 Ohara DrPort Charlotte FL 33948View Listing
$949,00015562 Seafoam CirPort Charlotte FL 33981View Listing
$948,7008745 Calumet BlvdPort Charlotte FL 33981View Listing
$948,00015626 Meacham CirPort Charlotte FL 33981View Listing
$948,00015912 Melport CirPort Charlotte FL 33981View Listing
$948,00015390 Ancel CirPort Charlotte FL 33981View Listing
$942,0008893 St Paul DrPort Charlotte FL 33981View Listing
$934,90015434 Seafoam CirPort Charlotte FL 33981View Listing
$929,00013654 Allamanda CirPort Charlotte FL 33981View Listing
$924,90014075 Keystone BlvdPort Charlotte FL 33981View Listing
$910,000136 Creek Dr SEPort Charlotte FL 33952View Listing
$899,90014267 Montmarte AvePort Charlotte FL 33981View Listing
$899,90015291 Appleton BlvdPort Charlotte FL 33981View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-19-2024 2:08:00 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 4
Blah