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
$999,9007004 Highway 75 Lot 1Pinson AL 35126View Listing
$995,0006051 Bibby Brickyard Rd Lot 6365Graysville AL 35062View Listing
$850,0006709 Hollis Loop Lot 6709Graysville AL 35062View Listing
$800,0006195 Lou George Loop Lot 1Bessemer AL 35022View Listing
$790,0003027 Cherry AveBrookside AL 35214View Listing
$595,0002560 Morgan RdBessemer AL 35022View Listing
$529,000712 Odum RdGardendale AL 35071View Listing
$500,0008108 Dickey Springs Rd Lot 10Bessemer AL 35022View Listing
$499,9005248 Old Springville Rd Lot 1Clay AL 35094View Listing
$400,0001558 McGaughy Rd Lot 2Gardendale AL 35071View Listing
$400,0008901 Highway 75 Lot 900032004001002Pinson AL 35126View Listing
$350,0004747 Fairway Ln Lot 2001Pinson AL 35126View Listing
$335,0005020 Laurel Lakes TerBessemer AL 35022View Listing
$305,0001040 Green Springs HwyHomewood AL 35209View Listing
$300,0003000 Self Creek Rd Lot 1Warrior AL 35180View Listing
$300,000388 Poplar Trl Lot 51Warrior AL 35180View Listing
$250,0001423 7th Pl Lot 1Pleasant Grove AL 35127View Listing
$250,0005981 Miles Spring Rd Lot 1Pinson AL 35126View Listing
$249,9007371 Old Bradford Rd Lot 7371Pinson AL 35126View 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 May-13-2024 3:04:59 pm.