Title Page Background
DEBUG FN args: Array ( [0] => 1922 [1] => [2] => [3] => agent ) BEFORE: Site: 1922 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1922 Igate: njhud LocID: 1922 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1922 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1922 [1] => [2] => [3] => lender ) BEFORE: Site: 1922 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1922 Igate: njhud LocID: 1922 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1922 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1922 [1] => [2] => [3] => other ) BEFORE: Site: 1922 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1922 Igate: njhud LocID: 1922 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1922 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

292 Pine Ridge Road
Robbinsville, NC 28771
Paige Jones with Cherokee Realty, original listing - (828) 479-6441

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,450,000
Beds: 13
Baths: Full: 11, ½: 2
Status: Active
SqFt: --
Agency: Cherokee Realty
Agency Phone: (828) 479-6441

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Discover the ultimate lakefront retreat with this exceptional 9-bedroom lodge, perfectly situated on the shores of Lake Santeetlah. This unique property features a commercial kitchen, restaurant, and bar, making it an ideal investment opportunity or family getaway. With 178 feet of pristine lake frontage and over 378 feet of road frontage along US Hwy 129, accessibility and visibility are guaranteed. Property includes a quaint 2-bedroom, 1-bath owner cabin on-site, along with a 10-slip multi-use dock permit with plans drawn to expand to 16 more slips, perfect for boating enthusiasts. The breathtaking views from this property are unparalleled, offering a serene escape in nature. The lodge boasts a charming mountain cabin style, highlighted by a grand great room complete with a pool table and a cozy lounge area. At the heart of the lodge is a stunning two-story stone fireplace, creating a warm and inviting atmosphere for gatherings. The lakefront area is designed for entertainment, featuring ample table seating, an outdoor bar, and beautiful lighting for evening ambiance. The easy ramp and dock system provides comfortable access to the water, while the south/southwesterly views are simply spectacular. Additionally, the property includes an offsite 1.28-acre parcel featuring another 2-bedroom, 1-bath cabin and tennis courts, offering even more recreational opportunities. Don't miss this rare chance to own a piece of paradise on Lake Santeetlah, where adventure and relaxation await!
MlsNumber: --
ListingId: 152863


Listing Provided By: Cherokee Realty, original listing
Phone: (828) 735-3818
Office Phone: (828) 479-6441
Agent Name: Paige Jones
Disclaimer: Copyright © 2025 Mountain Lakes 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