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;

110 Lake Court
Highlands, NC 28741

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,400,000
Beds: 4
Baths: 5
Status: Active
SqFt: --
Agency: Trillium Land & Realty Company, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2002
Notes: Elegant Comfort—This stunningly decorated home on the lake in Cullasaja Club invites you to relax and enjoy the fruits of life's labors! Offered exquisitely furnished (minor exclusions), a master decorator has intentionally planned every detail of this true “turn-key” residence. The soothing earth tones flow seamlessly through the furnishings, the artwork, the artistic accessories, and the wall coverings. Situated behind the gates of the exclusive Cullasaja Club, your privacy is assured on this 1.8-acre double lot. The Club's centralized location on the Highlands-Cashiers corridor gives easy access to the wide variety of restaurants, shops, and activities that only this mountain plateau offers. Equally accommodating of either solitary or family living, this home exudes a warmth and “livability” rarely found. The floor plan is logical and effective with an easy flow centering on the massive stone fireplace flanked living room. One direction leads to the well-appointed outdoor screened “living room” porch with access to the Coyote grill and steps to the lower levels, while another direction merges into an elaborately furnished (but lightly used) gourmet kitchen and the adjacent dining room overlooking the lake. Still another door unveils the first of two master suites with elaborate bath and dressing areas. The second master suite and additional bedrooms are located on the upper floor. All bedrooms are ensuite. Surprising extras abound, such as one-of-a-kind antique furniture and accessories, an elegant Yamaha piano (with player), a lower spa deck with premium hot tub, electronically hidden TVs, and a state-of-the-art lighting control system. The previous owners rarely occupied this home, resulting in an almost new feel to the current listing. New owners will benefit from their masterful taste. (Note: Some community amenities depend on optional membership which may be waitlisted)
MlsNumber: 104284


Listing Provided By: Trillium Land & Realty Company, LLC, original listing
Name: Trillium Land & Realty Company, LLC
Phone: (828) 507-1227
Office Name: Trillium Land & Realty Company, LLC
Office Phone: (828) 507-1227
Agent Name: Brenda Beye
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