SELECT *, CASE WHEN `locality` LIKE "sheffield%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "AL" AND (locality IN ("sheffield") 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 24
Blah
SELECT *, CASE WHEN `locality` LIKE "sheffield%" AND `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "AL" AND (locality IN ("sheffield") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 24
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,900,0000 Pinegrove DrMuscle Shoals AL 35661View Listing
$2,599,90080 Donnegan CvMuscle Shoals AL 35661View Listing
$2,250,0000 Elton Darby RdFlorence AL 35630View Listing
$2,250,00015.45 Acres Elton Darby RdFlorence AL 35630View Listing
$1,999,9501141 County Road 367Florence AL 35634View Listing
$1,900,0000 County Road 122Florence AL 35634View Listing
$1,850,000823 Veterans DrMuscle Shoals AL 35661View Listing
$1,800,000Highland CvFlorence AL 35630View Listing
$1,600,0004310 Wagnon Mountain RdTuscumbia AL 35674View Listing
$1,550,000559 Hunter Point CvMuscle Shoals AL 35661View Listing
$1,500,000706 Ridgecliff DrFlorence AL 35634View Listing
$1,145,0000 Hawk Pride Mountain RdTuscumbia AL 35674View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AL" 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 24
Blah
Commercial
Land
Ranch
Single Family
