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

5105 Lakeshore Drive
Copperopolis, CA 95228
Aaron Stafford with Coldwell Banker Lake Tulloch, original listing - (209) 785-2273

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,849,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 3182 Square Feet
Agency: Coldwell Banker Lake Tulloch
Agency Phone: (209) 785-2273

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 1987
Notes: This 3,182-square-foot lakefront home is truly exceptional. With R2 zoning, the property features a separate two-bedroom, one-bathroom guest house complete with a kitchen, living room with fireplace, and a private deck offering breathtaking lake views. The main house is designed for comfortable living across two levels. The entry level boasts a full bathroom and 2 bedrooms, each equipped with raised seating/sleeping areas. The main floor features an open kitchen with a breakfast bar and a spacious pantry room large enough for all of your food storage and a full size refrigerator, a dining area large enough for a 10 person dining table, a living room with a gas fireplace and large windows for enjoying the lake views and accessing the expansive deck overlooking the water. Additionally, this level includes a guest bedroom, a full bathroom, a laundry area, and the primary bedroom with a private bathroom. Every room offers stunning lake views through large windows. The expansive deck, accessible from the main level, provides ample space for entertaining, relaxation, and dining. An outdoor refrigerator closet offers convenient storage for a full-size fridge with a lockable door. Below the deck, a patio area features a sandy beach ideal for relaxing, sunbathing, fishing, or building sandcastles. The double dock provides space for your boats and water toys. With tons of storage and ample space for both indoor and outdoor entertainment, this home offers something for everyone.
MlsNumber: --
ListingId: 202401820


Listing Provided By: Coldwell Banker Lake Tulloch, original listing
Phone: (209) 840-1432
Office Phone: (209) 785-2273
Agent Name: Aaron Stafford
Disclaimer: Copyright © 2024 Calaveras 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