select *, date_format(`pdate`, '%M %e, %Y') as `pdate`, IF(`expires` < NOW(),'Yes','No') as `expired` from `items` where isProperty='0' and 1=1 and active = 'Yes' AND `expires` > NOW() order by price desc limit 0, 30 Properties - Homefront Realty & Auction LLC
Quick Search
Zip
Min
Max
Bed(s)
Baths(s)
Advanced Search
Most Popular Listings
Loretto, TN
Bed(s) - Bath(s)
- $ 149,900
Loretto, TN
Bed(s) - Bath(s)
- $ 30,000
Lawrenceburg, TN
3 Bed(s) - 1 Bath(s)
- $ 239,900
Lawrenceburg, TN
Bed(s) - Bath(s)
- $ 12,900
Lawrenceburg, TN
3 Bed(s) - 2 Bath(s)
- $ 800,000
Quick Links
New Listings
, TN
0 Bed(s) - 0 Bath(s)
- $ 16,900
Lawrenceburg, TN
3 Bed(s) - 1.5 Bath(s)
- $ 89,000
Pulaski, TN
3 Bed(s) - 2 Bath(s)
- $ 79,500
Lynville, TN
5 Bed(s) - 4 Bath(s)
- $ 900,000
Lawrenceburg, TN
3 Bed(s) - 1 Bath(s)
- $ 74,900
Property(s)
Modify Search
   
Display Per Page Start With Result Sort By in Order

Showing 1 - 1 of 1 Total
Property Results Hello
800 Herb Drive / 304 Virginia Drive, , TN
Images: 2
Property Number: 408 		View Details
Showing 1 - 1 of 1 Total
Neighborhood Info
Get your neighborhood info
City
State
 
Local Schools
Get your local school info
City
State
 
Local News
Get your local news
City
Source
 
Weather
Find your local weather
Zip:   

Conditions for Lawrenceburg, TN at 6:52 am CST

Current Conditions:
Fair, 32 F

Forecast:
Tue - Mostly Sunny. High: 57 Low: 36
Wed - Mostly Sunny. High: 54 Low: 30

Full Forecast at Yahoo! Weather

(provided by The Weather Channel)
Top of Page | Agents 2009 © Home Front Realty LLC, All rights reserved