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;

3307 Hartzog Ford Road
West Jefferson, NC 28694
Theresa DeMarco Gatewood with Realty One Group Select, original listing - (980) 447-9001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 5848 Square Feet
Agency: Realty One Group Select
Agency Phone: (980) 447-9001

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Escape the hustle and bustle of city life to your dream riverfront retreat along the picturesque New River. Set amidst 6 acres in the heart of southern Ashe County. This property offers multiple usable yard spaces around the home and a riverfront park waiting for memories to be made. Imagine spending your summers fishing, kayaking, and relaxing along the banks of the New River. The design of the home features 3 levels of living, 2 full kitchens, 3 car garage, and numerous open and covered porches and patios. In addition to multiple flex spaces that could be used for additional sleeping areas, game room, media room, office, home gym, or library, the home offers the space needed for larger families or multi-generational living. True main level living is available with the primary suite and laundry area both on the first floor. The open concept design offers a great room with fireplace and 2 story vaulted ceilings, an oversized kitchen, three separate dining areas, and more than enough room to entertain the largest of gatherings. Upstairs offers a second bedroom suite, an oversized third bedroom, another full bathroom and 2 loft areas that could serve as sitting areas or offices. The walkout lower level offers a living room with fireplace, second kitchen, dining room, third bedroom suite, game area, and additional half bathroom. If desired, the lower level could be utilized as a separate living space, ideal for multi-generational living arrangements. Enjoy an unmatched location in the High Country. The Blue Ridge Parkway, Mountain to Sea Trail, and numerous State Parks are all within 15 minutes. Wineries, breweries, dining, shopping, and art galleries are also just minutes away. Drive times to popular destinations are: W. Jefferson – 10min, Boone – 25min, CLT – 2HR, Triad – 1.5HR, Raleigh 3HR. Make sure to check out the 2 VIRTUAL TOURS. NO DRIVE-BYS PLEASE.
MlsNumber: --
ListingId: 250120


Listing Provided By: Realty One Group Select, original listing
Phone: (828) 773-0840
Office Phone: (980) 447-9001
Agent Name: Theresa DeMarco Gatewood
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