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 = 2512 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2512 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2512 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

751 Holly Avenue
Erwin, TN 37650
Rachel Moody-Livingston with Foundation Realty Group, original listing - (423) 282-1817

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 5
Baths: Full: 4
Status: Pending
SqFt: 6670 Square Feet
Agency: Foundation Realty Group
Agency Phone: (423) 218-9554

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1922
Notes: From the road you will be taken back by this beautiful stately home with 4+/- acres offering mature trees and welcoming circular driveway. The covered front porch offers a inviting area for guest or gatherings and leads into the foyer with nice hardwood and tall open space with staircase. The main level offers large LR with fireplace that leads to the DR, kitchen has tons of storage, closet laundry area, eat-in area, wood burning fireplace, room for desk, full bath, a side door with carport allowing for easy access for bring in groceries, and lots of natural light. From the kitchen you can enter the family room which has a cozy welcoming feel and has a wood burning stove as well. Also, on the main is a lovely sunroom overlook the grounds that could be used as a office or additional bedroom and has a full bath. Upstairs you will find 5 large bedrooms and 2 full baths. The primary is oversized and has its en-suite bathroom, all of the bedrooms have lots of natural light. You will find stairs leading up to an abundance of storage in the attic that also has windows and is bright and airy. The full basement also offers a ton of additional storage. That's not all...the beautiful grounds area offers an outdoor firepit, and inground pool , room for a large garden, chickens, or just elbow room for privacy. This home has truly been loved for over the years and now is your opportunity to continue loving this home and enjoying all 4 seasons Northeast TN has to offer. Buyer to verify all info. Pool may need a little TLC.
MlsNumber: --
ListingId: 9977756


Listing Provided By: Foundation Realty Group, original listing
Phone: (423) 737-0774
Office Phone: (423) 282-1817
Agent Name: Rachel Moody-Livingston
Disclaimer: Copyright © 2025 Tennessee Virginia Regional Multiple Listing Service. 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