SELECT *, CASE WHEN `name` LIKE "stuart%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "stuart" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "stuart" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "stuart" 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 ("stuart") 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
$17,750,0006440 SE Harbor CirStuart FL 34996View Listing
$16,995,0001005 NE Doubloon DrStuart FL 34996View Listing
$11,950,0006934 SE Harbor CirStuart FL 34996View Listing
$8,995,0006400 SE Inlet WayStuart FL 34996View Listing
$7,900,0002001 SE St Lucie BlvdStuart FL 34996View Listing
$7,499,0006978 SE Harbor CirStuart FL 34996View Listing
$6,995,0001441 SE Riverside DrStuart FL 34996View Listing
$6,950,0006980 SE Harbor CirStuart FL 34996View Listing
$6,499,0002160 SE Golfview LnStuart FL 34996View Listing
$5,500,00045 W High Point RdStuart FL 34996View Listing
$4,875,0004500 NE Spinnaker Point PlStuart FL 34996View Listing
$4,850,0001625 SE Saint Lucie BlvdStuart FL 34996View Listing
$3,995,0006967 SE Harbor CirStuart FL 34996View Listing
$3,945,0002925 SE Dune DrStuart FL 34996View Listing
$3,500,0002835 SE St Lucie BlvdStuart FL 34997View Listing
$3,497,0005675 SE Orange StStuart FL 34997View Listing
$3,349,000985 SE Saint Lucie BlvdStuart FL 34996View Listing
$3,000,0006741 SE Harbor CirStuart FL 34996View Listing
$3,000,000110 SW Atlanta AveStuart FL 34994View Listing
$3,000,0001209 SE Ocean BlvdStuart FL 34996View Listing
$2,999,000519 SW South River Point DrStuart FL 34994View Listing
$2,995,0002888 SE Dune DrStuart FL 34996View Listing
$2,995,00010 S Sewalls Point RdStuart FL 34996View 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-02-2024 2:31:16 pm.
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