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

2568 Hwy 68
Niota, TN 37826

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 3440
Agency: Village Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22 acre(s)
Property Type: Residential
Year Built: 2017
Notes: This is truly a must see to appreciate home and property. The beautiful maintenance free exterior of this classy only 7 year old custom built home and shop had no expense spared to ensure that no corners were cut and the construction not only meets but exceeds building codes. This home is a worry free quality built home on 22 beautiful acres of rolling fields and woods full of all types of wild life including the occasional bear. If you are looking for privacy, to farm, hunt, shoot, hike or just enjoy nature, this property has it all. It is fantastically located for all the best that East Tennessee has to offer. This property is located 8 minutes from Watts Bar Lake, 8 minutes from I-75 Sweetwater, TN exit, 1 hour South of Knoxville, 1 hour North of Chattanooga, 30 minuets from Cherokee National Forest, 1 hour 20 minuets to the Great Smokey Mountains National Park. This 3 bedroom, 3 bath home with study that could be used as a 4th bedroom offers vaulted ceilings in the upstairs master with walk in closet, walk-in shower and jetted tub. The upstairs living space boasts vaulted ceilings with a beautiful high end gas fireplace and mantel. Formal dining area, eat-in kitchen and bar to enjoy family and friends around beautiful kitchen amenities including high-end black stainless appliances. Convenience of single level living but also providing a fully finished down stairs with a separate entrance that includes a 2nd huge living area, a large mother-in-law suite with walk-in closet, living space, and kitchenette, large storage room and a safe room/storm shelter. All down stairs has 9 foot ceilings. All cabinetry and vanities are custom and are fitted with custom granite tops. Beautiful rich hardwood flooring with custom matching spiral staircase. Back yard and deck look out over the beautiful landscape. Three zone central heat and air system and well insulated structure provides comfort at very low monthly expense. Property also has a barn for tractor and equipment storage, and a 30'X40' insulated heated and air conditioned shop for business, hobbies or storage. The shop includes a full bathroom with dedicated water heater and is wired for 220 for a welder, also wired for washer and dryer and range that could be used as additional living space or for rental income. Attached to the shop is covered parking for a boat or RV.
MlsNumber: 1261207


Listing Provided By: Village Realty, original listing
Name: Village Realty
Phone: (865) 458-3500
Office Name: Village Realty
Office Phone: (865) 458-3500
Agent Name: Linda Lefler
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.


Local Real Estate Expert

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 = 2485 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;
Dennis Opp, Broker Owner and Betty Hiefnar-Messer Managing Broker
ASCIIEXIT Provision Realty
Dennis: (423) 240-0231
Betty: (423) 595-8970

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App