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;

18515 Rawhide
Jamestown, CA 95327
Adam Wilson with Century 21/Wildwood Properties, original listing - (209) 586-3258

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,475,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2370 Square Feet
Agency: Century 21/Wildwood Properties
Agency Phone: (209) 586-3258

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 160 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Embark on an extraordinary journey with this unique "One of a Kind" 160.57-acre property, boasting a High Density General Plan and residential estate in the heart of Sierra Nevada's Gold Country, nestled within the historic town of Jamestown, CA. This exceptional parcel is adorned with the tranquil flow of Woods Creek, a historical gold-producing waterway, enhancing its natural charm. Comprising four parcels, the first encompasses 9.96 acres and features a delightful 1,720 sqft, 3-bedroom, 2-bathroom single-level ranch-style home, accompanied by a 650 sqft, 1-bedroom, 1-bathroom ADU, both currently generating rental income. Additionally, this parcel includes a cell tower with a long-term lease, adding to its investment appeal. Adjacent to this, the property offers 49.22 acres and 6.25 acres of level to rolling land, offering a versatile canvas for your development aspirations. Additionally, there is an incredible 95.14-acre parcel with wide open meadows and picturesque views, likened to the Napa Valley Wine Vineyards, ideal for estate and vineyard development. With dual road frontage on Rawhide Rd and Jamestown Rd, along with power lines running along both roads and water and sewer connections nearby, this property ensures convenient access and streamlined development potential. Strategically located near Hwy 108, Jamestown, and the recently expanded Chicken Ranch Casino Resort, this property is primed for development, offering a compelling case for a housing development project. Don't let this rare opportunity slip away—secure your slice of paradise today!
MlsNumber: --
ListingId: 20240299


Listing Provided By: Century 21/Wildwood Properties, original listing
Phone: (209) 743-3910
Office Phone: (209) 586-3258
Agent Name: Adam Wilson
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