SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "GA" 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 6
Blah
$327,5001187 Pocket RdLaFayette GA 30728View Listing
$300,000Hog Jowl RdChickamauga GA 30707View Listing
$299,0001411 Kelly StRossville GA 30741View Listing
$257,000Hog Jowl RdChickamauga GA 30707View Listing
$225,000Houston Valley RdRinggold GA 30736View Listing
$225,0003698 Highway 337LaFayette GA 30728View Listing
$189,000Hillsdale RdLaFayette GA 30728View Listing
$189,000Lookout Crest Ln Lot 1Lookout Mountain GA 30750View 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-03-2024 3:34:28 am.