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 = 1979 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 = 1979 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 = 1979 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;

Lot 17 Sunset Ridge Drive
Boone, NC 28607

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $90,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: NextHome Mountain Realty
Agency Phone: (828) 264-8745

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Lot 17 has shared well rights and community septic IN PLACE. Amazing find.<br /> <br /> She is a very gentle slope almost flat,and located on Sunset Ridge, atop the charming, gated subdivision known as Boulder Cay.<br /> <br /> Boulder Cay is a 34 lot Community located super close to everything in Boone and just a ten minute drive to Blowing Rock.<br /> <br /> Boulder Cay is 3 minutes from the Boone Mall, 5 minutes to Appalachian (APP) State, 10 minutes or less to Watauga Medical Center & approx 10 min. to Blowing Rock via Edmisten Rd.<br /> <br /> Boulder Cay community consists of 34 lots, measuring from half an acre on the ridge, to larger 2-acre interior estate lots.<br /> <br /> GREAT NEWS:<br /> <br /> SEPTIC: Lots 10 thru 17 have a SEPTIC DRIP SYSTEM installed along Deck Hill Rd. at the back side of each of the 8 Ridge Lots. Once construction commences, Builder just needs to connect home to the community system.<br /> <br /> SHARED WELL: Your builder also just needs to connect to shared well on lot 13 from your home. The connections & tap ons to both the shared wells & the drip septic system are the responsibility of the buyer (as is usual). Just pick your view.<br /> <br /> Having a community drip system installed also allows for use of more of the land per lot due to the elimination of any need for a large drain field. These are "Builder Ready" lots on the ridge with water & septic available. Come on up & sit a spell.
MlsNumber: --
ListingId: 4025452


Listing Provided By: NextHome Mountain Realty, original listing
Phone: (828) 264-8745
Office Phone: (828) 264-8745
Agent Name: Judy and Allan Wagner
Disclaimer: Copyright © 2024 NextHome, Inc. 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