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;

Tbd Lot 121 Firethorn Trail
Blowing Rock, NC 28605

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $162,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Ridgeline Properties
Agency Phone: (828) 406-4823

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Hey there, potential mountain dwellers! If you've been on the hunt for your own little slice of paradise among the peaks, Firethorn is calling your name. This gated community isn't just your average neighborhood—it's like a mini mountain oasis, complete with stunning views, a chill clubhouse, a serene pond, and it's super convienent to the adorable town of Blowing Rock.<br /> <br /> And guess what? We've got some killer lots up for grabs—think numbers 106 to 108, 120 to 124, and 215 and 217. Whether you're dreaming of a permanent mountain pad or a sweet weekend getaway, these lots are just waiting for someone like you.<br /> <br /> <br /> <br /> And get this—not only are these lots ready to build on, but they practically scream potential. Picture this: you could combine a few to create your very own mountain retreat, kind of like playing SimCity in real life but way cooler!<br /> <br /> If you're all about peace, space, and good vibes, Firethorn ticks all the boxes. Plus, living near Blowing Rock means you've got year-round fun at your fingertips.<br /> <br /> Worried about the commute? Don't sweat it! Charlotte International Airport is just a scenic two-hour drive away, or you can catch a hassle-free shuttle from Blowing Rock.<br /> <br /> And here's the best part—there are plenty of awesome builders in the area ready to make your dream home a reality. With lots of properties already in the works, you could be chilling on your mountain deck in no time.<br /> <br /> So why wait? Picture yourself kicking back after a long week, drink in hand, soaking in those Blue Ridge Mountain views. Or better yet, why not make the bold move and tell your boss you're headed to Firethorn in beautiful Blowing Rock? Trust me, future you will thank you big time.
MlsNumber: --
ListingId: 248354


Listing Provided By: Ridgeline Properties, original listing
Phone: (828) 406-4823
Office Phone: (828) 406-4823
Agent Name: Kent Zotter
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