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;

11644 Nc Hwy 88
Warrensville, NC 28693

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,175,000
Beds: 5
Baths: 4
Status: Active
SqFt: 5425
Agency: Realty ONE Group Results

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 66 acre(s)
Property Type: Residential
Year Built: 1971
Notes: On the Market for the first time, truly a piece of Ashe County's history, is a property in this family for generations. Nestled between the Rich Hill Creek and the New River, a stocked trout stream and one of the oldest Rivers in the world, with majestic mountains in the background are 66 meandering acres with a beautiful home, garage, and barns. Walk out the front door down to the New River to enjoy fishing, floating, kayaking, or sitting and enjoying the sunset. The Rich Hill Creek, to one side, offers a pleasant place to sit by the fire pit while entertaining friends and family. The creeks' soothing sounds will melt your stress away. The property has drivable trails, streams, springs, mature timber, and several buildable home sites with views of the mountains and the New River. Hike up to the two summits of the property. On the way to one summit, you will see the remains of the Riverview School water system; no longer in use, the rock school building was destroyed by fire in the 1970s. At the summit, enjoy a seasonal 360-degree mountain view. Generations have enjoyed picnics at this spot. The other summit offers several buildable sites with views of the New River winding around. The house is one level living with three bedrooms upstairs and three full baths.A newer sunroom was added to bring in lots of natural light and to enjoy the beautiful surroundings and plantings of the backyard.The house has undergone extensive updates.New roof in 2023. New HVAC compressor 2024. HVAC 2017 has a 5-year warranty transferrable. Newer windows. Security system.The basement level offers a kitchen,bath, new living, sleeping, flooring, walls, and paint. A new state-of-the-art moisture control system was installed in 2024 with a lifetime warranty. This house presents a ranch one-level charm with several newly added extras. The hardwood floor upstairs are wide plank with pegged boards, fireplaces, backup heat, and more, too many to list. This is a must see to appreciate property!
MlsNumber: 248674


Listing Provided By: Realty ONE Group Results, original listing
Name: Realty ONE Group Results
Phone: (336) 262-3111
Office Name: Realty One Group Results
Office Phone: (336) 846-8111
Agent Name: Sandara Dollar
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.


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 = 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;
Real Estate Expert Photo for Elisa Gartman
Elisa Gartman
ASCIIRealty One Group Results - Boone
Call Today!: (205) 394-1142

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App