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;

524 River Bluff Drive
Fleetwood, NC 28626
Chris Barr with Realty One Group Results, original listing - (336) 846-8111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $929,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2929 Square Feet
Agency: Realty One Group Results
Agency Phone: (336) 846-8111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Beautiful Spacious Cabin in a Private Gated Community in Southern Ashe County. Nestled atop a hill at the end of a serene community, this stunning log home offers complete privacy on a sprawling, wooded 3-acre lot. With only two homes currently in the neighborhood, you'll enjoy tranquility in a gated setting. This home, meticulously maintained with the exterior recently stained in 2023, is being sold fully furnished, including 5 TV's. Step inside to an open-concept living area, where the kitchen features abundant cabinetry and counter space, seamlessly flowing into the dining area and great room. The great room is highlighted by soaring cathedral ceilings and a striking stone fireplace, perfect for cozy evenings. The main floor boasts a primary bedroom with direct access to a covered porch, complete with an en suite bathroom, his-and-hers walk-in closets, and a main floor laundry room. A convenient half bath rounds out this level. Upstairs, a spacious loft with a built-in desk overlooks the great room, accompanied by two generously sized bedrooms and a full bathroom. Every room maximizes closet and storage space, ensuring practical living. The lower level is perfect for entertaining, featuring a den with a second stone fireplace, and a sleeper sofa, a full bar and kitchen equipped with a refrigerator, microwave, and dishwasher and a full bath. This level also includes a two-car garage with freshly sealed epoxy floors and wiring for a generator, ensuring comfort and preparedness year-round. Outdoor living is a highlight, with ample space for hosting guests, multiple parking spots, and a peaceful deeded feeding station. Enjoy year-round access just 15 minutes from both West Jefferson and Boone, making this cabin the perfect mountain retreat with modern conveniences.
MlsNumber: --
ListingId: 252172


Listing Provided By: Realty One Group Results, original listing
Phone: (336) 977-2060
Office Phone: (336) 846-8111
Agent Name: Chris Barr
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