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

20612 Longridge
Groveland, CA 95321
Laif McClellan with Christie's Intl. R.E. Sereno, original listing - (831) 325-8698

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2116 Square Feet
Agency: Christie's Intl. R.E. Sereno
Agency Phone: (831) 325-8698

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Welcome to your dream retreat at Pine Mountain Lake! This charming lakefront home, built in 1996 and inspired by the picturesque cottages of Carmel-by-the-Sea, offers a perfect blend of rustic elegance and modern comfort. With 2,116 square feet of living space, this 3-bedroom, 2.5-bathroom gem sits on a sprawling 17,000 square foot lot, providing ample space for relaxation and recreation. As you step inside, you’ll be captivated by the breathtaking views framed by large windows that bathe the home in natural light. The wrap-around deck is perfect for enjoying your morning coffee or evening sunsets, offering panoramic views of the serene lake. Your private dock with a deep water draft is a boater’s paradise, making it easy to explore the water or simply relax by the shore. Located in the exclusive Pine Mountain Lake community, this property offers an array of amenities, including an 18-hole golf course, scenic hiking and biking trails, and a private recreational lake with three sandy beaches. Whether you’re into boating, fishing, swimming, or picnicking, there’s something for everyone. The community also features newly updated playgrounds, campgrounds, an equestrian center, and fine dining at "The Grill." Plus, you’re just 30 minutes from the majestic Yosemite National Park, making it an ideal location for nature lovers and outdoor enthusiasts. This home isn’t just a place to live; it’s a lifestyle. Experience the best of both worlds—peaceful lakeside living with access to a wealth of recreational activities. Don’t miss your chance to own a piece of paradise!
MlsNumber: --
ListingId: 20241222


Listing Provided By: Christie's Intl. R.E. Sereno, original listing
Phone: (831) 325-8698
Office Phone: (831) 325-8698
Agent Name: Laif McClellan
Disclaimer: Copyright © 2024 Tuolumne County 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App