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

4264 Old Asheville Highway
Flag Pond, TN 37657
Skyler Cantrell with Clinch Mountain Realty & Auction Co., original listing - (865) 993-5263

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,500
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Clinch Mountain Realty & Auction Co.
Agency Phone: (865) 993-5263

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Feast your eyes on 40 acres of completely unrestricted and unspoiled natural beauty in the heart of the Blue Ridge Mountains. This property truly does have it all. <br /> <br /> For starters this 40 acres is joined all along its back border by over 2,000 acres of Lamar Alexander Rocky Fork State Park. The park offers scenic wilderness with second to none hiking/horseback riding trails and trout fishing. Adjacent to the majority of the acreage along the front boundary of the property you will find South Indian Creek which is a hatchery supported water and is home to great trout fishing. <br /> <br /> Infrastructure on the property includes 4 cleared/level Camper or RV pads with preprepared hookups to city water, septic, electric, and fiber optic internet. Also included in the sale will be a fully furnished 30ft camper that is in excellent living condition.<br /> <br /> Moving into the heart of the property you will find picturesque views of the surrounding mountains that the area is so famous for which would be a perfect place to build your dream home far away from any neighbors or noises from the outside world. The property would also be a prime candidate for rental cabins for the people seeking the areas multitude in recreational opportunities like the Appalachian Trail, Nolichucky River, or the nearby Ski Resorts in Wolf Laurel or Beech Mountain. <br /> <br /> The property is located just minutes from the beautiful town of Erwin that just over 6,000 people call home and the infamous Appalachian Trail comes directly through. If it is a larger city you are needing the property is also located just 30 minutes from Johnson City or Asheville NC.<br /> <br /> It is accurate to say that there may not be another property in all of Tennessee that has so much to offer its next owner but has to be seen to be truly appreciated. Please do not hesitate in setting up your own private showing today.
MlsNumber: --
ListingId: 9974120


Listing Provided By: Clinch Mountain Realty & Auction Co., original listing
Phone: (828) 380-0327
Office Phone: (865) 993-5263
Agent Name: Skyler Cantrell
Disclaimer: Copyright © 2024 Tennessee Virginia Regional Multiple Listing Service. 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