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 = 2441 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 = 2441 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 = 2441 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;

220 Kiowa Way
Del Rio, TN 37727

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 3
Baths: 5
Status: Active
SqFt: 3234
Agency: Country Living Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2006
Notes: Nestled atop a serene mtn slope, surrounded by 4.06 acres of woodlands, lies this Heritage Log Cabin, offering the epitome of rustic luxury and unparalleled comfort. Log Cabin offers 3 bedrooms and 4 1/2 bathrooms. A wrap-around deck encircles the cabin, offering breathtaking panoramic views of the majestic mountains and the meandering French Broad River below. The back porch beckons with a sauna and a bubbling hot tub, providing the perfect spot to unwind and soak in the natural beauty that surrounds you. Step inside, and you'll be greeted by the warmth of a massive, stacked stone wood-burning fireplace with blower to also heat the upper story. The living area features vaulted ceilings and expansive windows that flood the space with natural light, creating an inviting atmosphere for gathering with friends and family. Hardwood flooring throughout. With bathroom and laundry rooms with ceramic tile. The cabin boasts three bedrooms, with 2 having their own bathrooms. The one upstairs to the left has its own covered deck, providing privacy and comfort. A large loft area offers additional sleeping space or serves as a versatile entertainment area with sky lights. While the partially finished basement has solid concrete walls and provides an oversized den with lots of natural lighting as well. It also has its own full bathroom which could potentially offer more sleeping space for your guests. The gourmet kitchen is a chef's delight, equipped with Stainless Steel modern appliances, granite countertops, walk-in pantry and ample cabinet space. The Dining area boasts a large dining table enough to seat10. Off the dining space is a screen covered porch. 2 Car Garage with space enough for your outdoor toys as well. All Furnishings available. Just minutes to the town of Newport for all your shopping and dining needs as well as medical facilities. Hot Springs, NC is to the east, just a 20min ride. Pigeon Forge or Gatlinburg are roughly an hour and 15mins
MlsNumber: 1257247


Listing Provided By: Country Living Realty, original listing
Name: Country Living Realty
Phone: (423) 237-1046
Office Name: Country Living Realty
Office Phone: (423) 237-1046
Agent Name: Donna Fabrikant
Disclaimer: Copyright © 2024 East Tennessee Realtors®. 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