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 = 191 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 191 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 191 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

8217 Meeks Bay Avenue
Meeks Bay, CA 96142
Fawne Hayes with Chase International - South Lake Tahoe, original listing - (530) 544-2121

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $28,000,000
Beds: 8
Baths: Full: 13, ½: 3
Status: Active
SqFt: 15000 Square Feet
Agency: Chase International - South Lake Tahoe
Agency Phone: (530) 544-2121

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Rockhaven Tahoe where privacy, exclusivity, and unparalleled luxury come together to create an exquisite lakefront estate. Situated on the south point of Meeks Bay, this stunning property spans 1.22 acres and boasts a 140 foot deep water pier, two buoys, sandy beach and an impressive 300 feet of shoreline along the crystal-clear waters of Lake Tahoe. With a gated entrance and surrounded by lush landscape, Rockhaven Tahoe ensures that every moment spent here is a tranquil private retreat.The estate comprises an impressive 15,000 square feet of living space with a total of 8 bedrooms, 10 full bathrooms and 3 half bathrooms in a grand main home and two attached guest houses, thoughtfully designed to have beautiful lake views from every room and access to the main home. Upon entering, you are greeted by a breathtaking sight - a Dale Chihuly Chandelier, custom-crafted by the renowned artist himself, adding a touch of artistic grandeur to the dining room. The 500-year-old hardwood floors hold their own history, having been sourced from a Monastery in France.Indulge in the finest details Rockhaven Tahoe has to offer. An elevator connects all three levels of the home, two home offices, gym, theater, and sauna provide the perfect combination of work and relaxation. Outdoors find 4 hot tubs, including 1 swim flume, 5 fire pits, 3 barbecues beckon you to unwind and take in the natural beauty surrounding you.Rockhaven Tahoe's location offers a harmonious blend of year-round activities. During the winter, ski enthusiasts will be delighted with Homewood and Palisades Ski Resorts minutes away. Revel in the magical winter wonderland while the state-of-the-art hydronic heating system and heated driveway keep you cozy and hassle-free. Summer, enjoy a plethora of water activities such as boating, kayaking, jet skiing, swimming, and even jumping on a water trampoline right from your own private shore.This private estate presents a unique opportunity to own a prestigious lakefront property that has been cherished by some of the world's wealthiest individuals for its unparalleled privacy and luxury. Embrace the serene beauty of Lake Tahoe and make Rockhaven Tahoe your private sanctuary today.
MlsNumber: --
ListingId: 140318


Listing Provided By: Chase International - South Lake Tahoe, original listing
Phone: 416-2272
Office Phone: (530) 544-2121
Agent Name: Fawne Hayes
Disclaimer: Copyright © 2024 South Tahoe 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.


Local Real Estate Expert

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 = 191 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;
Real Estate Expert Photo for Cynthia Mittleider
Cynthia Mittleider
ASCIIRE/MAX Gold
Call Today!: (916) 337-4989

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App