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

471 Sherwood Forest Road
Highlands, NC 28741
Sarah Strawn with KELLER WILLIAMS GREAT SMOKIES, original listing - (828) 743-5122

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,950,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: --
Agency: KELLER WILLIAMS GREAT SMOKIES
Agency Phone: (828) 743-5122

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Experience the epitome of luxury with this premium new construction Sherwood Forest home boasting an array of sophisticated features, including a standing seam metal roof, French lap siding with cedar shake accents, and a detached double garage. Revel in the outdoor oasis featuring Brazilian Ironwood (IPE) decking, a fully furnished kitchen, and a cozy fire table, creating an ideal setting for both casual gatherings and elegant soirees. This exquisite residence has a comfortable and functional floor plan with two bedrooms including the master, on the main level and an additional two bedrooms downstairs along with entertainment areas, providing flexibility and privacy. Once inside, you will discover a home where every detail has been thoughtfully considered—inclusive of a generous amount of upgraded shiplap walls, intricately laid master tilework, barnwood wall accents, heated floors in master bath, designer baseboard, interior door, and kitchen cabinet heights, and expansive panoramic folding great room doors— seamlessly blending the home's indoor and outdoor living space. The high-end kitchen is a culinary masterpiece with fine custom cabinetry, and full suite of Thermador appliances that cater to even the most discerning chefs. Downstairs, you will be amazed at the sheer beauty of the recreation room and one-of-a-kind theatre room featuring a sleek wood and cork interior, masterfully-designed tray ceiling, a wet bar, and fireplace—complemented by included cutting-edge electronics that elevate your entertainment experience to new heights. Welcome to a residence where every element combines to create a harmonious blend of comfort, distinctive styling, and sophistication.
MlsNumber: --
ListingId: 103703


Listing Provided By: KELLER WILLIAMS GREAT SMOKIES, original listing
Phone: (828) 743-5122
Office Phone: (828) 743-5122
Agent Name: Sarah Strawn
Disclaimer: Copyright © 2024 Highlands Cashiers Board 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