SELECT *, CASE WHEN `locality` LIKE "lineville%" 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 ("lineville") 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 "lineville%" 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 ("lineville") 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.
$1,288,000State Lake Acres Rd Lot 322Delta AL 36258View Listing
$799,900720 Good Hope RdDelta AL 36258View Listing
$645,000255 Royster Rd SAshland AL 36251View Listing
$643,000398 New Harmony DrLineville AL 36266View Listing
$625,0003554 County Road 30Cragford AL 36255View Listing
$600,00086 Harbour Point LnDelta AL 36258View Listing
$595,0002509 Lees Bridge RdDelta AL 36258View Listing
$575,0001749 McCollum Church RdLineville AL 36266View Listing
$529,999189 Acres /-Short Leaf /-Acres Ln Lot 189Ashland AL 36251View Listing
$449,000662 Blair Ac Rd Lot 231Ashland AL 36251View Listing
$439,90083 Barfield School RdLineville AL 36266View Listing
$429,5003447 County Road 82Lineville AL 36266View 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
