SELECT *, CASE WHEN `name` LIKE "lauderdale by the sea%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lauderdale by the sea" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lauderdale by the sea" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lauderdale by the sea" 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 ("lauderdale by the sea") 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.
$8,400,0001650 E Terra Mar DrLauderdale By The Sea FL 33062View Listing
$4,490,0001511 W Terra Mar DrLauderdale By The Sea FL 33062View Listing
$4,150,0001950 Waters EdgeLauderdale By The Sea FL 33062View Listing
$3,699,0001603 W Terra Mar DrLauderdale By The Sea FL 33062View Listing
$2,850,0001912 Ocean Mist DrLauderdale By The Sea FL 33062View Listing
$2,369,0001920 Waters EdgeLauderdale By The Sea FL 33062View Listing
$1,850,0001431 S Ocean Blvd Apt 24Lauderdale By The Sea FL 33062View Listing
$1,675,0003231 S Terra Mar DrLauderdale By The Sea FL 33062View Listing
$1,520,0002049 Windward DrLauderdale By The Sea FL 33062View Listing
$1,395,0002073 Windward DrLauderdale By The Sea FL 33062View Listing
$1,324,0001949 Sailfish PlLauderdale By The Sea FL 33062View Listing
$990,0001973 Sailfish PlLauderdale By The Sea FL 33062View Listing
$945,0001431 S Ocean Blvd Apt 62Lauderdale By The Sea FL 33062View Listing
$927,0001431 S Ocean Blvd Apt 78Lauderdale By The Sea FL 33062View Listing
$925,0001973 Windward DrLauderdale By The Sea FL 33062View Listing
$920,0001431 S Ocean Blvd Apt 76Lauderdale By The Sea FL 33062View Listing
$850,0001717 S Ocean Blvd Apt 12Lauderdale By The Sea FL 33062View Listing
$849,0001431 S Ocean Blvd Apt 2Lauderdale By The Sea FL 33062View Listing
$799,0001431 S Ocean Blvd Apt 1Lauderdale By The Sea FL 33062View 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:17:19 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
Ranch
Single Family
