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;

598 Alawa Place
Angels Camp, CA 95222

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3438
Agency: RE/MAX Gold

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1998
Notes: Welcome to 598 Alawa Place, an exquisite retreat nestled within the prestigious Greenhorn Creek Resort & Golf Course. This luxurious home, spanning 3,438 square feet, offers unparalleled comfort and elegance with 4 bedrooms, 3 bathrooms, and a host of upscale amenities. Upon entering, you're greeted by breathtaking views of the 5th hole, 6th green, and serene pond, providing a picturesque backdrop for daily living. Meticulously remodeled by Dillashaw Construction in 2018, this home is a testament to refined taste and superior craftsmanship. The heart of the home, the kitchen, is a chef's delight with quartz countertops, custom cabinetry, and a suite of Thermidor appliances. The hammered aged copper sink adds a touch of sophistication, while the instant hot & cold water tanks ensure convenience. Each bathroom is a sanctuary of relaxation, featuring custom cabinetry, quartz countertops, and elegant tile work. The primary suite, conveniently located on the main level, presents private deck access, offering a secluded retreat to unwind and enjoy the views. Entertain in style in the spacious living room, adorned with a custom stone fireplace by John Schuler of CreativeCrete, creating a warm and inviting ambiance. A separate dining area provides the perfect setting for intimate gatherings. Beyond the lavish interiors, this home offers practical features such as an oversized 3-car garage and ample parking space, ensuring convenience for you and your guests. Additional amenities include custom stained natural oak flooring, a whole house hard-wired Generac generator, and a tankless water heater for energy efficiency. Step outside to the meticulously landscaped grounds and discover your own private oasis, complete with a custom gas-plumbed stone firepit on the front flagstone patio, perfect for outdoor entertaining. Adjacent lot with the APN 058-052-007 (.3 acre) included in sale. Indulge in the epitome of luxury living at 598 Alawa Place, where every detail has been meticulously curated to provide a lifestyle of unparalleled comfort and sophistication. Schedule your private tour today and experience resort-style living at its finest.
MlsNumber: 202400404


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: Neriah Davis
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