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;

204 Luttrell Street
Erwin, TN 37650
Matthew McCrory with True North Real Estate, original listing - (423) 210-4155

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 4100 Square Feet
Agency: True North Real Estate
Agency Phone: (423) 210-4155

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1968
Notes: Check out this completely renovated tri-level home on a 0.84-acre lot with a large fenced-in backyard and a beautiful back deck offering stunning mountain views.<br /> This home boasts numerous updates: new PEX plumbing, drain lines, gas lines, light fixtures, a gas tankless water heater, fresh flooring and paint, updated bathrooms, and a brand-new shadow box fence. Plus, there's a custom master bedroom closet and much more!<br /> Step inside to discover a tri-level layout with a living room and a breakfast nook adjacent to the kitchen. The kitchen is equipped with new butcher block countertops, a kitchen island for extra space, a stainless steel range, and a refrigerator. A formal dining room or additional living area features a stone gas fireplace and access to the screened-in porch, complete with a doggy door leading to the fenced backyard.<br /> Head upstairs to discover two spacious bedrooms and two bathrooms. The master suite includes a huge walk-in closet, a washer and dryer, and sliding doors that open to the back deck, offering a view of the mountains. The ensuite bathroom features a beautifully updated walk-in shower and a newer updated vanity.<br /> The lower level, with its independent front and backyard access, is perfect for an in-law suite or a teenager's living space. It includes a den with a gas stove, a third large bedroom with natural light, a smaller office room, and a third bathroom with a refinished clawfoot tub and an additional washer and dryer included with the home.<br /> Going down into the basement you will find a finished area perfect for a gaming/craft room or even additional bedroom space. This second refrigerator is included as well. There is plenty of closet space for storage and a barn door that reveals a full shop in the unfinished space.<br /> Outside, enjoy covered parking for three cars, plus an additional driveway to the backyard with space for RV, camper, or boat parking. A newer 12x20 shed with lofts is also included. Don't miss this wonderful house.
MlsNumber: --
ListingId: 9972153


Listing Provided By: True North Real Estate, original listing
Phone: (423) 806-0702
Office Phone: (423) 210-4155
Agent Name: Matthew McCrory
Disclaimer: Copyright © 2024 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