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

5208 Wilder Rd
Grimsley, TN 38565
Jonathan Minerick with Homecoin.com, original listing - (888) 400-2513

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,950,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 830 Square Feet
Agency: Homecoin.com
Agency Phone: (888) 400-2513

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 164 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2001
Notes: A one-of-a-kind property located on 165 beautiful, secluded acres in the heart of Tennessee horse country. The ''Trail Riding Capital of TN'', Fentress County offers hundreds of miles of horse trails. We are less than 10 minutes from East Fork Stables & 45 minutes from the Big South Fork National River and Recreation Area. Centrally located between Nashville, Knoxville and Chattanooga. Far away from the urban rush, this rural community is friendly and welcoming. Other nearby attractions include: Historic Rugby Settlement; Pickett Civilian Conservation Corps Memorial State Park; Sgt. Alvin C. York State Historic Park; East Port Marina & Resort on Dale Hollow Lake; Cumberland County Playhouse Theater; and the Highland Manor Winery to name a few. Activities available include hiking, horseback<br /> This balanced property has 7 ponds, is fenced and cross-fenced and consists of 36 acres in timber and the remainder in beautiful pasture. The 22 stall horse barn includes a newly remodeled and furnished corner apartment (see photos), tack/grooming room, and several storage areas. It also has two independent septic systems. One recently installed and state approved to accommodate 20 RV sites. The property is ripe and ready for developing into a beautiful private estate, a gated community, an exciting business venture, or all of the above! This balanced property has 7 ponds, is fenced and cross-fenced and consists of 36 acres in timber and the remainder in beautiful pasture. The 22 stall horse barn includes a newly remodeled and furnished corner apartment (see photos), tack/grooming room, and several storage areas. It also has two independent septic systems. One recently installed and state approved to accommodate 20 RV sites. The property is ripe and ready for developing into a beautiful private estate, a gated community, an exciting business venture, or all of the above!
MlsNumber: --
ListingId: 1250332


Listing Provided By: Homecoin.com, original listing
Phone: (888) 400-2513
Office Phone: (888) 400-2513
Agent Name: Jonathan Minerick
Disclaimer: Copyright © 2024 Knoxville Area Association of Realtors &#174;. 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