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 = 1889 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1889 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1889 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

Tbd Little Windfall Road
Lansing, NC 28643
Kim Hurley with Allen Tate Ashe High Country Realty, original listing - (800) 729-0735

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Allen Tate Ashe High Country Realty
Agency Phone: (800) 729-0735

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 93 acre(s)
Property Type: Land-Other
Year Built: --
Notes: This exceptional 93.732-acre property offers a unique opportunity to own a large tract of land comprised of nine lots in Alley Knob and an adjoining 46.7-acre tract. A private gravel road gracefully winds through the picturesque Alley Knob, seamlessly connecting to the expansive 46.7-acre tract. The larger tract also offers extensive frontage on Big Windfall Road, a state-maintained gravel road. Underground power and fiber optic cable are already in place in Alley Knob, ensuring modern amenities are available. With selective tree removal, you can unveil stunning long-range layered views, adding to the property's allure. The land is predominantly wooded with native hardwoods, offering an abundance of marketable timber. Natural features include impressive large rock outcroppings and a rich diversity of wildlife, including deer and turkey, enhancing the property's recreational appeal. Elevated at nearly 4,000 feet, this tract promises breathtaking vistas and a refreshing mountain climate. The potential for this property is truly limitless, making it perfect for various uses, from development to outdoor activities. Situated just 15 minutes from Lansing and 30 minutes from West Jefferson, two lively mountain towns, this area offers a delightful blend of small-town charm and outdoor adventure. Explore unique locally owned boutiques, savor the flavors of diverse restaurants and breweries, or indulge in fishing in the state-stocked trout streams. For a serene experience, kayak along the crystal-clear waters of the New River, surrounded by stunning mountain scenery. Whether you seek relaxation or recreation, this location has it all. Don’t miss this rare opportunity to own a vast and versatile piece of mountain paradise.
MlsNumber: --
ListingId: 251083


Listing Provided By: Allen Tate Ashe High Country Realty, original listing
Phone: (800) 729-0735
Office Phone: (800) 729-0735
Agent Name: Kim Hurley
Disclaimer: Copyright © 2024 High Country 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