select items.*, date_format(items.pdate, '%M %e, %Y') as `pdate`, date_format(items.expires, '%M %e, %Y') as `expires`, categories.title as `ptype`, stylecats.title as `stype` from `items`, categories, stylecats where items.id = 104 and `expires` > NOW() and `active` = 'Yes' and items.cid = categories.id and items.styleID = stylecats.id , , - Property Details - Homefront Realty & Auction LLC
Quick Search
Zip
Min
Max
Bed(s)
Baths(s)
Advanced Search
Most Popular Listings
Collinwood, TN
Bed(s) - Bath(s)
- $ 180,000
Lawrenceburg, TN
3 Bed(s) - 2 Bath(s)
- $ 229,000
Lawrenceburg,
2 Bed(s) - 1 Bath(s)
- $ 25,000
Lawrenceburg, TN
2 Bed(s) - 1 Bath(s)
- $ 37,000
Lawrenceburg, TN
5 Bed(s) - 2 Bath(s)
- $ 142,500
Quick Links
New Listings
Lawrenceburg, TN
3 Bed(s) - 2 Bath(s)
- $ 94,500
Lawrenceburg, TN
3 Bed(s) - 1 Bath(s)
- $ 60,000
Lawrenceburg, TN
4 Bed(s) - 2 Bath(s)
- $ 53,500
Summertown, TN
3 Bed(s) - 2 Bath(s)
- $ 69,900
Lawrenceburg, TN
2 Bed(s) - 1 Bath(s)
- $ 53,500
Property Detail
, ,
Please upgrade your Flash Player

This page requires Adobe Flash Player 9 or greater.
Click here to go to download page.
Property Type
Property Style
Title
Price $0
Bed(s)
Bath(s)
SQFT 0
Lotsize
Year Built
Levels
Garage
Subdivision
School District
Published
Print Flyer

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 4:53 pm CDT

Current Conditions:
Fair, 94 F

Forecast:
Mon - Clear. High: 86 Low: 59
Tue - Mostly Sunny. High: 91 Low: 65

Full Forecast at Yahoo! Weather

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