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;

394 Blair Mine Road
Angels Camp, CA 95222

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3312
Agency: RE/MAX Gold

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: Welcome to a one-of-a-kind custom-built home nestled within the prestigious golf course community of Greenhorn Creek. This impeccable residence, never before on the market, offers unparalleled luxury and comfort. Featuring 4 bedrooms, one thoughtfully designed as an office space with built-in desk and cabinets, this home is a testament to meticulous craftsmanship and attention to detail. Step inside to discover hickory floors gracing the living room, complemented by a custom front door and limestone tile in the grand entryway. Wine enthusiasts will delight in the temperature-controlled wine cellar boasting an impressive capacity of approximately 2000 bottles. The gourmet kitchen showcases GE professional appliances, including a 6-burner gas cooktop stove, perfect for culinary endeavors. Retreat to the primary master suite on the main level, featuring outdoor access, marble floors, a luxurious walk-in shower, a large soaking tub, and his and hers closets, offering a sanctuary of comfort and relaxation. Entertainment awaits outdoors with a pergola adorned with fans and lights, a bocce ball court for friendly competition, and a Bose surround sound system with indoor/outdoor speakers setting the ambiance for gatherings. For the hobbyist or craftsman, a 20x20 bonus room/workshop complete with a half bath, epoxy floors, central A/C and 220 wiring offers endless possibilities. Meanwhile, a spacious attic above the three-car garage provides ample storage space. Experience the epitome of refined living in this exclusive custom home, where every detail has been thoughtfully curated for the discerning homeowner. Watch the vide here:https://vimeo.com/917612125?share=copy
MlsNumber: 202400276


Listing Provided By: RE/MAX Gold, original listing
Name: RE/MAX Gold
Phone: (209) 743-8433
Office Name: RE/MAX Gold - Murphys
Office Phone: (209) 728-6498
Agent Name: Stacey Silva
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