SELECT *, CASE WHEN `name` LIKE "big pine key%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "big pine key" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "big pine key" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "big pine key" 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 ("big pine key") 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.
$4,999,50029349 Forrestal AveBig Pine Key FL 33043View Listing
$3,199,0001631 Sunrise DrBig Pine Key FL 33043View Listing
$2,495,0001353 Long Beach DrBig Pine Key FL 33043View Listing
$1,995,00029566 Ranger AveBig Pine Key FL 33043View Listing
$1,899,00029667 Forrestal AveBig Pine Key FL 33043View Listing
$1,599,00031146 Atlantis DrBig Pine Key FL 33043View Listing
$1,500,00029410 Ranger AveBig Pine Key FL 33043View Listing
$1,499,99730891 Granada AveBig Pine Key FL 33043View Listing
$1,499,00030366 Falcon LnBig Pine Key FL 33043View Listing
$1,299,00030851 Baileys LnBig Pine Key FL 33043View Listing
$1,299,00029557 Flying Cloud AveBig Pine Key FL 33043View Listing
$1,289,0002083 Bahia Shores RdBig Pine Key FL 33043View Listing
$1,275,00029687 Saratoga AveBig Pine Key FL 33043View Listing
$1,230,000132 E Cahill CtBig Pine Key FL 33043View Listing
$1,195,00029030 Marigold DrBig Pine Key FL 33043View Listing
$1,100,00030451 Hibiscus LnBig Pine Key FL 33043View Listing
$1,100,00030556 Anthony StBig Pine Key FL 33043View Listing
$1,095,00029153 Cedar DrBig Pine Key FL 33043View Listing
$1,089,0003746 Park AveBig Pine Key FL 33043View Listing
$955,0003841 Donna RdBig Pine Key FL 33043View Listing
$950,0003943 Venna RdBig Pine Key FL 33043View Listing
$945,0001615 Fern AveBig Pine Key FL 33043View Listing
$925,00031465 Avenue FBig Pine Key FL 33043View Listing
$825,000542 Sands RdBig Pine Key FL 33043View 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-13-2024 10:37:53 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
