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;

Little John Rd
Copperopolis, CA 95228
Michael Mayer with RE/MAX Gold - Copperopolis, original listing - (209) 753-0410

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $10,800,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: RE/MAX Gold - Copperopolis
Agency Phone: (209) 753-0410

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2,579 sqft
Property Type: Land-Other
Year Built: --
Notes: This exceptional property is a portion of the Historic Rancho Del Rio Estanislao Ranch, made up of two parcels APN 053-020-016 & 015 that total approximately 2579 acres. Currently part of a working ranch with no residence this would be the perfect place to build that dream home, a getaway retreat or adventure lodge reminiscent of the television series Yellowstone. There are fantastic views of Lake Tulloch, Goodwin Reservoir, Stanislas River canyon, Little John creek, surrounding hills, Tabletop Mountain, and the distant Sierra Mountains. This property has approximately 3000 ft of Lake Tulloch frontage, runs adjacent along the Goodwin reservoir and has the Little John creek running through it. Lake Tulloch and Goodwin reservoir are two of the very few lakes in California that allow private waterfront homes and docks. Take advantage of the frontage on the two different lakes to fish, swim, boat, wake board, ski or enjoy your personal watercraft. The ranch is rich in history being a portion of the Rancho del Ro Estanislao, a Mexican land grant that initially covered 48,887 acres in what is now Stanislaus and Calaveras counties. The grant was given in 1843 by Governor Manuel Micheltorena to Francisco Rico and Jose Castro and patented in 1863 following the Mexican-American war. Discover all the wonderful native flora and fauna. This property would make an exceptional hunting lodge or outdoor recreational retreat, a family fun oasis for making memories around a campfire. There are many lookouts to enjoy the sunsets that will take your breath away. If you are an equestrian enthusiast there are endless riding opportunities or cattle gathering-round up and branding days. Minutes from the nearby Golf Club at Copper Valley and the Square at Copper Valley. The Square has shopping, the new Gateway Hotel, three restaurants, medical facilities, many concerts, and events. Copperopolis is the gateway to the foothills. Enjoy seasonal sports and activities. Bear Valley and Dodge Ridge ski resorts are close. Yosemite, Big Trees redwood park, visiting historic mining towns and touring the Calaveras wine county are easy day trips. Just two hours from the Bay Area and one hour from the valley. Come and view this one-of-a-kind property in the heart of the Motherlode.
MlsNumber: --
ListingId: 202400236


Listing Provided By: RE/MAX Gold - Copperopolis, original listing
Phone: (209) 985-9620
Office Phone: (209) 753-0410
Agent Name: Michael Mayer
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