SELECT *, CASE WHEN `name` LIKE "crystal river%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "crystal river" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "crystal river" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "crystal river" 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 ("crystal river") 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.
$2,400,0006750 N San Juan TerCrystal River FL 34428View Listing
$1,700,000452 SE Paradise Point RdCrystal River FL 34429View Listing
$1,650,00039 SE 11th StCrystal River FL 34429View Listing
$1,650,000975 SE 1st CtCrystal River FL 34429View Listing
$1,500,00011885 W Bayshore DrCrystal River FL 34429View Listing
$1,490,0002243 N Kings Cove PtCrystal River FL 34429View Listing
$1,475,0001030 N Crescent DrCrystal River FL 34429View Listing
$1,400,0001865 SE Third Ct WCrystal River FL 34429View Listing
$1,300,0001941 NW 17th StCrystal River FL 34428View Listing
$1,299,000983 SE 1st CtCrystal River FL 34429View Listing
$1,295,0001480 NW 3rd StCrystal River FL 34428View Listing
$1,290,0001117 SE Paradise AveCrystal River FL 34429View Listing
$1,285,0001931 NW 15th StCrystal River FL 34428View Listing
$1,200,0001730 NW 20th AveCrystal River FL 34428View Listing
$995,0006873 W Rich StCrystal River FL 34428View Listing
$985,0008947 W Basilico StCrystal River FL 34428View Listing
$915,0009610 W Ozello TrlCrystal River FL 34429View Listing
$899,0002226 N Kings Cove PtCrystal River FL 34429View Listing
$899,0002173 N Slewfoot PathCrystal River FL 34429View Listing
$890,0001074 N Circle DrCrystal River FL 34429View Listing
$869,9002247 S Waterman DrCrystal River FL 34429View Listing
$864,9008051 N Neige PtCrystal River FL 34428View Listing
$859,00011897 W Waterwood DrCrystal River FL 34429View Listing
$850,0001861 NW 15th StCrystal River FL 34428View 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-06-2024 10:14:20 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
