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

817 Prospector Drive
Clio, CA 96106

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,469,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3628
Agency: WHITEHAWK PROPERTY SVS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: This timeless mountain designed home lives up to the challenge of space and time with perfection in every room. This home offers 4 bedrooms with 4.5 bathrooms, which includes a separate apartment above the garage with a full second kitchen and bathroom. The attention to detail doesn’t go unnoticed from the handpicked rock from the Yuba River for the gorgeous stone fireplace, to the custom-made stair rails. Additional special attention was given to the wide plank Douglas Fir Flooring throughout, Loewen brand Douglas Fir clad windows and patio doors and over 13,000 cedar shake shingles applied in perfect harmony with the solid cedar siding. Enjoy friends and family in the open great room including a gourmet kitchen with Knotty Alder custom cabinetry, Thermador stainless steel professional appliances, antiqued granite counters, country copper main and prep sink, built in wine bar, pantry fit for a king, and full home sound system. Home includes an entire floor dedicated to the master suite, including an attached multi-purpose loft currently enjoyed as a quiet reading space with propane fireplace for those wonderful winter wonderland days. Two additional on-suite bedrooms with private access overlooking the 4th Green of Whitehawk Ranch Golf Course compliment this home. This offering is turnkey, providing you with the ease of moving in and starting anew. The property comes fully furnished with dishes, pots and pans – a perfect solution for today’s hectic lifestyle. Love your life in the incomparable Whitehawk Ranch development, a very special mountain community with so many amenities, including championship 18-hole golf course, tennis courts with area for our Pickle Ball devotee’s, swimming pool, hiking, bocce ball, rec/weight room, community center, RV/boat storage area and onsite seasonal restaurant/lodge facilities. Enjoy the scenic views, the peace and serenity, and immerse yourself in the beautiful surroundings.
MlsNumber: 20240174


Listing Provided By: WHITEHAWK PROPERTY SVS, original listing
Name: WHITEHAWK PROPERTY SVS
Phone: (530) 836-2021
Office Name: WHITEHAWK PROPERTY SVS
Office Phone: (530) 836-2021
Agent Name: LINDA CARR
Disclaimer: Copyright © 2024 Plumas 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