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

762 Old Tellico Highway N
Madisonville, TN 37354
LeAnne Presley with Award Realty II, original listing - (423) 476-3205

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 4
Baths: Full: 1
Status: Active
SqFt: 1414 Square Feet
Agency: Award Realty II
Agency Phone: (423) 476-3205

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 47 acre(s)
Property Type: Residential-Agriculture
Year Built: 1958
Notes: Nestled in the heart of picturesque landscapes, this expansive 47.06-acre farm presents a unique blend of tranquility, functionality, and potential, ready to accommodate a variety of aspirations and lifestyles. <br /> <br /> Unrestricted land, the property serves a dual narrative of serene living and abundant opportunity. The cleared pastures, fenced and cross-fenced, are perfect for equestrian lovers or those with a passion for agriculture, ensuring a seamless blend of work, play, and relaxation. The farm's two ponds add a picturesque element, while enhancing the functionality for irrigation or livestock. Wooded areas provide a natural wonder, offering peace and privacy, as well as opportunities for outdoor recreation right in your backyard. <br /> <br /> The presence of a large barn with 4 sheds, 8 stables, a crib, and a loft with stairs will support a variety of agricultural or equestrian activities. Two smaller buildings offer additional storage. <br /> <br /> The property's inclusion in the Greenbelt program not only affirms its agricultural value but also offers financial incentives through property tax savings. With a 90' well and septic tank in place, the foundation is set for sustainable living or further development.<br /> <br /> DEVELOPERS: This is a fantastic opportunity with nearly 2000' of road frontage! City water and natural gas provided by the City of Madisonville is located all along the road, and positions this land as an excellent candidate for future projects. Additional adjoining acreage (15.3) available for purchase takes this property all the way to and across New Highway 68, providing opportunity for a mixture of residential and commercial development. <br /> <br /> Conveniently located to Madisonville, and Interstate 75, approximately 1 hour from Knoxville and Chattanooga and 2.5 hours from Atlanta and Nashville. Nearby mountains, rivers and lakes provide endless activities and adventure year-round.<br /> <br /> Farm Sold AS IS. House given little value.
MlsNumber: --
ListingId: 20241286


Listing Provided By: Award Realty II, original listing
Phone: (423) 295-5043
Office Phone: (423) 476-3205
Agent Name: LeAnne Presley
Disclaimer: Copyright © 2024 River Counties 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.


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 = 2488 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;
Samuel Johnson
ASCIIColdwell Banker Nelson Realtors
Call Today!: (865) 314-0896

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App