SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "TN" 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 47
Blah
$440,000Firelink Trl Lot 1Kingston Springs TN 37082View Listing
$375,00056 Highway 49 WAshland City TN 37015View Listing
$375,0004 Highway 12 NAshland City TN 37015View Listing
$349,500MT Pleasant Rd Lot 3Kingston Springs TN 37082View Listing
$329,000Highway 12 N Lots 1 & 2Ashland City TN 37015View Listing
$325,0003 Highway 12 NAshland City TN 37015View Listing
$325,0002 Highway 12 NAshland City TN 37015View Listing
$325,0005 Highway 12 NAshland City TN 37015View Listing
$300,000Narrows of the Harpeth Rd Lot 4Kingston Springs TN 37082View Listing
$300,000Narrows of the Harpeth Rd Lot 3Kingston Springs TN 37082View Listing
$300,000Apache Trl Lot 4Pegram TN 37143View Listing
$300,000Kimbrough Rd Lot 3Ashland City TN 37015View Listing
$289,0000 Highway 49 WAshland City TN 37015View 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-15-2024 1:31:58 pm.