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;

9574 Highway 11w
Mooresburg, TN 37811
Sarah Richards with Spring Mountain Realty, PLLC, original listing - (865) 935-0500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,900
Beds: 5
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2688 Square Feet
Agency: Spring Mountain Realty, PLLC
Agency Phone: (865) 935-0500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 31 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 2007
Notes: Welcome to this hidden gem! This charming 5-bedroom, 2.5-bathroom farmhouse sits on over 31 acres of serene, mixed grassy and wooded land, offering stunning views of the mountains and partial glimpses of Cherokee Lake. Just a short ¼-mile drive from the house is a public boat launch on Cherokee Lake, renowned for its bass fishing and boasting over 400 miles of shoreline. A true hunter's paradise, this property features 20+ acres of mixed woods, where large bucks, does, and wild turkeys roam freely. For those with a passion for farming or homesteading, two separate fenced areas are ideal for a hobby farm. Bring your horses and enjoy trail riding in your own backyard, or raise goats, sheep, or cows. There's even a large pond stocked with fish, perfect for canoeing or peaceful afternoons by the water. The property also includes a metal 3-bay garage/barn, complete with a 1-bedroom office or apartment space separate from the main house. The garage has an oversized loft for ample storage, with the potential to expand the apartment. Whether you choose to use it for rental income or as a private guest space, the possibilities are endless. In addition, you'll find a second barn with 3 bays, featuring a pass-through into the field, making it easy to add stables for horses. There's also an RV slab with electric hookups and plenty of extra parking for cars, trucks, campers, and trailers. With fiber optic internet service and natural gas available at the main road, this farm-style home offers the perfect blend of rustic charm and modern convenience. Whether you're looking for a peaceful retreat or a fully functional farm, this property has it all!<br /> Don't miss out on this breathtaking opportunity! Schedule your showing today!!
MlsNumber: --
ListingId: 1280159


Listing Provided By: Spring Mountain Realty, PLLC, original listing
Phone: (865) 935-0500
Office Phone: (865) 935-0500
Agent Name: Sarah Richards
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