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

844 Wilderness Drive
Mooresburg, TN 37811
Randi Smith with simpliHOM Knoxville, original listing - (865) 999-8601

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2236 Square Feet
Agency: simpliHOM Knoxville
Agency Phone: (855) 856-9466

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 53 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Located in Chelaque Estates, discover a private retreat nestled along the shores of Cherokee lake in the heart of the East Tennessee mountains. This 2-bedroom, 2.5-bath home offers 2,200 square feet of thoughtfully designed living space that merges farmhouse charm with modern comfort. Featuring a seamless metal roof, low-maintenance siding and composite decking, your new home truly provides for low maintenance living. As you step inside, you'll find bright, open spaces, enhanced by large windows that frame beautiful lake & mountain views. The kitchen is getting all new floors, custom cabinets and countertops just in time for Christmas, perfect for entertaining. From the main level of the home, step outside to enjoy the deck OR your beautiful 14' x 10' screened porch. Head upstairs for reading, coffee, game nights and more in the open loft area that offers those same beautiful lake and mountain views. Here you'll find your primary bedroom featuring an ensuite and walk-in closet. On the lower level find 900 +/- sq feet of finished space that's perfect for family time at home. Need a 3rd bedroom? There's plenty of room to carve out the perfect space for a guest room. From the lower level walk outside to an expansive deck suitable for all types of outdoor entertainment. Whether you prefer exploring through the woods or spending time on the water, you'll have both at your fingertips. With nearly 53 acres of undisturbed land there are endless options for outdoor activities, from fishing and kayaking to hiking and riding your ATV across the trails. When you walk down the steps from the lower level deck, you'll find private lakefront access; perfect for water lovers. Experience East TN's natural beauty with the comfort and luxury of your private sanctuary. Schedule your tour today and prepare to fall in love with this extraordinary property.<br /> <br /> Additional features include NEW in the past two years; water heater, water softener, two HVAC units, retaining wall, vinyl windows & doors, interior doors, fresh paint, composite decking, french drain, well pump, metal roof, siding, vanities, flooring and so much more!
MlsNumber: --
ListingId: 303972


Listing Provided By: simpliHOM Knoxville, original listing
Phone: (865) 333-2343
Office Phone: (865) 999-8601
Agent Name: Randi Smith
Disclaimer: Copyright © 2024 Great Smoky Mountains Association of 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