SELECT *, CASE WHEN `locality` LIKE "rainsville%" 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 ("rainsville") 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 "rainsville%" 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 ("rainsville") 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,900,000721 County Road 116Fort Payne AL 35988View Listing
$1,299,000487 County Road 463Fort Payne AL 35968View Listing
$1,100,0006630 Hilltop DrFort Payne AL 35967View Listing
$995,000404 Forest Ave NWFort Payne AL 35967View Listing
$939,00062 Highland DrRainsville AL 35986View Listing
$829,0001045Highway 35Fort Payne AL 35967View Listing
$759,9001502 County Road 515Rainsville AL 35986View Listing
$749,900232 County Road 900Fort Payne AL 35967View Listing
$699,5004312 Pumpkin Center Rd NEFort Payne AL 35967View Listing
$699,0006900 Portobello Rd NWFort Payne AL 35967View Listing
$649,900146 Harley Dr NEFort Payne AL 35967View Listing
$609,90034953 Alabama Highway 75Fyffe AL 35971View 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
