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

1323 Love Station Road
Erwin, TN 37650
Patrick Watkins with Watkins Home Team, original listing - (423) 302-0675

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2000 Square Feet
Agency: Watkins Home Team
Agency Phone: (423) 302-0675

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: Discover your dream home at 1323 Love Station Road in Erwin, TN! This custom-built, one-level brick home sits on a pristine, level one-acre lot and has features to rival a new construction.<br /> <br /> Step into the spacious great room with gleaming hardwood floors, 12-foot ceilings, and a cozy gas log fireplace. The kitchen features custom cabinets, Corian countertops, and stainless steel appliances. The primary suite boasts hardwood floors, a walk-in closet, and a large bathroom with a walk-in shower and jetted tub.<br /> <br /> This immaculate home includes two additional bedrooms and a full bathroom on the opposite end of the house for added privacy. Other rooms include a formal dining room, a bright breakfast nook, a laundry room, and a two-car attached garage with attic storage. The abundance of windows ensures plenty of natural lighting, and closet space has been expertly planned, providing plenty of storage throughout the home.<br /> <br /> Step outside the breakfast nook onto the spacious screened back porch, leading to a deck with breathtaking mountain views. The beautifully landscaped yard features privacy trees across the back, providing a serene and secluded outdoor space.<br /> <br /> Erwin, TN, is a charming town known for its small-town community and stunning natural surroundings. With the Appalachian Trail nearby, residents can enjoy hiking, fishing, and other outdoor activities amidst beautiful mountain scenery. Erwin is conveniently located just twenty minutes from Johnson City, offering a variety of dining, shopping, and entertainment options. Additionally, Asheville, North Carolina, is less than an hour's drive away, providing even more cultural and recreational opportunities.<br /> <br /> Don't miss this opportunity to own an immaculate, custom-built home in the picturesque town of Erwin. Schedule your private showing today!<br /> <br /> Buyer/Buyers' agent to confirm all info contained herein. Info deemed reliable but not guaranteed.
MlsNumber: --
ListingId: 9969486


Listing Provided By: Watkins Home Team, original listing
Phone: (423) 434-0606
Office Phone: (423) 302-0675
Agent Name: Patrick Watkins
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