SELECT *, CASE WHEN `locality` LIKE "hillsboro%" 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 ("hillsboro") 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 "hillsboro%" 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 ("hillsboro") 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,250,0008374 County Road 222Trinity AL 35673View Listing
$1,250,000662 Old Highway 24Trinity AL 35673View Listing
$450,0007454 County Road 434Trinity AL 35673View Listing
$388,000671 County Road 360Trinity AL 35673View Listing
$359,77115 Acres Tower StTrinity AL 35673View Listing
$335,000269 County Road 496Trinity AL 35673View Listing
$319,90060 County Road 390Trinity AL 35673View Listing
$295,6001454 Old Highway 24 STrinity AL 35673View Listing
$289,90037 Acres County Road 374Hillsboro AL 35643View Listing
$269,9001050 County Road 317Trinity AL 35673View Listing
$249,90015675 Alabama Highway 20Hillsboro AL 35643View Listing
$241,50023 Old Highway 24Trinity AL 35673View 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