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;

1840 4th Street
Highlands, NC 28741

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,950,000
Beds: 5
Baths: 7
Status: Pending
SqFt: 5001
Agency: Meadows Mountain Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Residential
Year Built: 1990
Notes: Escape to Paradise in this gorgeous, completely remodeled home on the Cullasaja River! The home also boasts a two-bedroom guest house and views of your own personal waterfall, all nestled on 15 acres less than two miles from Main Street in Highlands. As you approach, you will be awe-struck by the landscape that surrounds it; the views of the private pond, river, and stunning waterfall greet you and will immediately capture your heart. The modern, luxurious design of the home will take your breath away. The home has an open floor plan that features a spacious living room with a floor-to-ceiling rock fireplace and large windows that offer views of the waterfall. The kitchen is a chef's dream, with high-end appliances, custom cabinetry, and a massive quartz island. The kitchen also includes a butler's pantry, a back kitchen, and a grilling porch. You will enjoy hosting dinner parties in front of the roaring river rock fireplace in the dining area; the dining area also offers easy access to the deck if you want to entertain al fresco. A bar with seating is the perfect connection between the kitchen, living room, and dining area. Relax in the master bedroom that has a direct view of the waterfall, then treat yourself to the spa-styled luxurious marble bath with views of the river. The oversized, outfitted closet will be the envy of all your friends. This floor also has two guest suites with upscale marble baths and walk-in closets. The terrace level, which can be accessed via elevator or stairs, boasts a family room that is perfect for a game of pool. Another en suite sleeping area is also on this level and has access outside to the beautifully manicured grounds. A lovely cottage is on the property and provides a private retreat for guests. It features a full kitchen, living room, and dining area, as well as 2BR/2BA, plus a family room. With its stunning location and design, this estate property on the Cullasaja River is the perfect legacy home!
MlsNumber: 103083


Listing Provided By: Meadows Mountain Realty, original listing
Name: Meadows Mountain Realty
Phone: (828) 526-1717
Office Name: Berkshire Hathaway HomeServices Meadows Mount
Office Phone: (828) 526-1717
Agent Name: Judith Michaud
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