Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2468 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2468 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2468 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

8551 Highway 49
Erin, TN 37061
Amanda Griffis with Grateful Acres Realty, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $184,896
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1728 Square Feet
Agency: Grateful Acres Realty
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 1981
Notes: ***BEING SOLD AS-IS!*** Charming and thoughtfully updated, this home in Erin, TN offers the perfect mix of comfort, style, and outdoor living. From the moment you step onto the 21x6 covered front porch, you'll feel right at home. Inside, enjoy hardwood flooring, a spacious kitchen with an island featuring installed electric, a two-sided sink with a farmhouse-style faucet, and brand-new stainless steel appliances, backsplash, and LED lighting for a fresh, modern feel. The kitchen table even conveys with the home! The living room is made for relaxing or entertaining with double ceiling fans, while each bedroom includes ceiling fans, walk-in closets, and ample space. The main bedroom features a 2 person jacuzzi soaking tub for ultimate relaxation, and the hall bathroom has been upgraded with a new toilet, new 12x24 porcelain cafe style tile and a marble vanity and a shower/tub combo. You'll love the peace of mind that comes with NEW floor joists, NEW subflooring, NEW ceiling fans with lights, NEW siding on the back of the house, and NEW baseboards in some areas and NEW railing and 6x6 posts on the front porch. The washer and dryer stay with the home, making this truly move-in ready. Step outside and take in the incredible 16x46 party patio-ideal for gatherings, grilling, or relaxing in the shade of the large mature trees. The flat backyard is perfect for kids, pets, or just enjoying some outdoor space. A brand-new 12x13 shed offers additional storage for tools, toys, or hobbies. Whether you're looking to entertain or just enjoy the peaceful charm of small-town living, this home checks all the boxes. Schedule your tour today and make it yours!
MlsNumber: --
ListingId: 11474839


Listing Provided By: Grateful Acres Realty, original listing
Phone: (931) 367-1584
Agent Name: Amanda Griffis
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App