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;

104 Sunset Drive
Unicoi, TN 37692

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $455,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2200
Agency: eXp Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2001
Notes: Welcome to the tranquility of 104 Sunset Drive. Located in the highly sought after Willow Pond Estates community in Unicoi. Close to all the region has to offer, yet tucked away in this beautiful community of manicured lawns and quiet streets. This cozy home is an oasis from the daily grind. Mountain views from the primary suite of lush green mountains to greet the morning and a jetted bath to rejuvenate you before you start the day. The home features hardwood flooring throughout the main floor with carpeted floors in the bedrooms. The bathrooms are completed with tile floors. A warm fireplace in the living room to invite family and friends near. The kitchen is thoughtfully designed with the dining room on one end for large gatherings and a breakfast nook on the opposite side surrounded in windows overlooking the pool for more intimate dining. Just off the living room and breakfast nook is a covered screened deck with views over the pool, hot tub, and mountains, perfect for a relaxing evening. Down stairs you are met with new luxury vinyl plank flooring in the bedroom, multipurpose room, and laundry/mudroom. The multipurpose room could easily be made into a 2nd primary bedroom as was used by the seller. The room features a fireplace, ceiling fan, direct access to a full bath and French doors for walk out access to the patio and large pergola. The fenced back yard allows for space for the kiddos or pets to play. Close to Johnson City, I-26, Asheville, NC, area lakes, rivers, and National Forest. All of this and no HOA! Buyer(s) and or Buyer(s) agent are responsible to verify all information. Some information taken from public records and third party sources.
MlsNumber: 9964869


Listing Provided By: eXp Realty LLC, original listing
Name: eXp Realty LLC
Phone: (888) 519-5113
Office Name: eXp Realty, LLC
Office Phone: (888) 519-5113
Agent Name: Charles Oliver
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