SELECT *, CASE WHEN `name` LIKE "hobe sound%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hobe sound" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hobe sound" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hobe sound" 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 ("hobe sound") 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
$5,750,0009741 SE Gomez AveHobe Sound FL 33455View Listing
$4,799,9997341 SE Golfhouse DrHobe Sound FL 33455View Listing
$4,500,0009399 SE Delafield StHobe Sound FL 33455View Listing
$4,490,0007240 SE Medalist PlHobe Sound FL 33455View Listing
$3,749,0007320 SE Medalist PlHobe Sound FL 33455View Listing
$3,199,00010440 SE Scrub Jay LnHobe Sound FL 33455View Listing
$3,000,0007186 SE Golfhouse DrHobe Sound FL 33455View Listing
$2,349,9007737 SE Loblolly Bay DrHobe Sound FL 33455View Listing
$2,200,00011291 SE Blair LnHobe Sound FL 33455View Listing
$1,850,0007931 SE Dock StHobe Sound FL 33455View Listing
$1,825,0008848 SE Marina Bay DrHobe Sound FL 33455View Listing
$1,700,00010806 SE Ensign CtHobe Sound FL 33455View Listing
$1,600,0007525 SE Jamaican CtHobe Sound FL 33455View Listing
$1,600,0009329 SE Mystic Cove TerHobe Sound FL 33455View 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-14-2024 5:20:16 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
Ranch
Single Family
