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;

321 Flatwoods Road
Creston, NC 28615
J. Mark Bower with Allen Tate Ashe High Country Realty, original listing - (800) 729-0735

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2179 Square Feet
Agency: Allen Tate Ashe High Country Realty
Agency Phone: (800) 729-0735

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 50 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Enjoy the privacy and natural beauty of this 50-acre estate featuring a like-new Craftsman-style mountain home. Beautiful views of several Blue Ridge Mountain peaks and peaceful pastoral views offer a tranquil setting. The terrain is gentle over a lot of the acreage providing additional homesites with great views. The gently sloping driveway meanders through the property. Plenty of wildlife on this tract including wild turkey and deer. The house has a rustic nature with beautiful wood floors, walls, and ceilings. All interior doors are wide pocket doors allowing handicap access. The stairway has a motorized chair for handicap access to the second level. On the main level is an open living, dining, and kitchen area, a primary bedroom with an ensuite primary bath, a large utility room for clothes, and storage with a laundry area. Off the living room, you have a great covered deck overlooking the property. There is also a side-covered patio and a large covered carport area. Upstairs you have a loft/office, two bedrooms, a bath, plus a bonus room for extra sleeping when needed. Next to the house is a recently constructed barn with storage bays, a detached garage, and an unfinished bonus room on the second level. There are some ATV trails on the property for outdoor exploration and recreation. The property is 10 minutes (3.3 miles) to Pond Mountain Game Lands, a 40-minute drive to West Jefferson, a 20-minute drive to Mountain City TN, and a 50-minute drive to Boone NC.
MlsNumber: --
ListingId: 251983


Listing Provided By: Allen Tate Ashe High Country Realty, original listing
Phone: (800) 729-0735
Office Phone: (800) 729-0735
Agent Name: J. Mark Bower
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