SELECT *, CASE WHEN `name` LIKE "palm city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "palm city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "palm city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "palm city" 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 ("palm city") 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.
$1,468,0461010 SW Sage Ct Unit 328Palm City FL 34990View Listing
$1,465,0005907 SW Cherokee StPalm City FL 34990View Listing
$1,449,00013328 NW Baywood PlPalm City FL 34990View Listing
$1,445,0005258 SW Blue Daze WayPalm City FL 34990View Listing
$1,425,000187 SW Lake Rush CtPalm City FL 34990View Listing
$1,416,294679 SW Winston Ave Unit 356Palm City FL 34990View Listing
$1,399,0001752 SW Foxpoint TrlPalm City FL 34990View Listing
$1,399,0005570 SW Coral Tree LnPalm City FL 34990View Listing
$1,395,0004801 SW Long Bay DrPalm City FL 34990View Listing
$1,390,000701 SW Pine Tree LnPalm City FL 34990View Listing
$1,390,0001758 SW Cabin PlPalm City FL 34990View Listing
$1,375,000917 SW Sea Green StPalm City FL 34990View Listing
$1,363,065655 SW Winston Ave Unit 355Palm City FL 34990View Listing
$1,354,9905689 SW Green Island TrlPalm City FL 34990View Listing
$1,350,0001282 SW Pelican CresPalm City FL 34990View Listing
$1,349,774895 SW Winston Ave Unit 363Palm City FL 34990View Listing
$1,320,0005225 SW Ludlum StPalm City FL 34990View Listing
$1,300,0003167 SW Bessey Creek TrlPalm City FL 34990View Listing
$1,299,9995469 SW Star Apple StPalm City FL 34990View Listing
$1,295,0001951 SW Winners DrPalm City FL 34990View Listing
$1,295,0006819 SW Citrus BlvdPalm City FL 34990View Listing
$1,290,0001586 SW Jasmine TrcePalm City FL 34990View Listing
$1,275,0004181 SW Parkgate BlvdPalm City FL 34990View Listing
$1,250,00010201 SW Tarzan TerPalm City FL 34990View 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-10-2024 6:52:23 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