SELECT *, CASE WHEN `locality` LIKE "crossville%" 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 ("crossville") 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 "crossville%" 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 ("crossville") 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.
$898,000266 County Road 444Crossville AL 35962View Listing
$795,0003895 County Road 1Collinsville AL 35961View Listing
$615,000255 Garret RdCollinsville AL 35961View Listing
$588,000140 Acres County Road 483Collinsville AL 35961View Listing
$469,00042 Gilbreath StCrossville AL 35962View Listing
$414,0001972 County Road 29Crossville AL 35962View Listing
$349,9001192 County Road 82Crossville AL 35962View Listing
$330,0001765 US Highway 11Collinsville AL 35961View Listing
$299,90026 Ac Alabama Highway 68Collinsville AL 35961View Listing
$250,000717 County Road 855Collinsville AL 35961View Listing
$249,900Highway 68Collinsville AL 35961View Listing
$229,00017148 County Road 51Collinsville AL 35961View 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
