SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AL" AND (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
$315,0000 Highway 431PHENIX CITY AL 36869View Listing
$295,000Hwy 80 N 80 HighwayPHENIX CITY AL 36870View Listing
$275,0003921 S 431 HighwayPHENIX CITY AL 36869View Listing
$250,0003834 US 80 HighwayLADONIA AL 36870View Listing
$249,9003732 HIGHWAY 431 SOUTHPHENIX CITY AL 36869View Listing
$230,000148 HIGHWAY 169PHENIX CITY AL 36869View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated .