Title Page Background
DEBUG FN args: Array ( [0] => 219 [1] => [2] => [3] => agent ) BEFORE: Site: 219 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 219 Igate: njhud LocID: 219 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 219 [1] => [2] => [3] => lender ) BEFORE: Site: 219 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 219 Igate: njhud LocID: 219 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 219 [1] => [2] => [3] => other ) BEFORE: Site: 219 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 219 Igate: njhud LocID: 219 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

306 Quail View Circle
Clio, CA 96106
HERSCHEL DEARDORFF with COLDWELL BANKER REALTY (Truckee), original listing - (530) 587-7474

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,825,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3774 Square Feet
Agency: COLDWELL BANKER REALTY (Truckee)
Agency Phone: (530) 587-7474

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: This spectacular home will take your breath away. Extensively remodeled in 2015 with a modern farmhouse style, this approximately 3,774-square-foot residence is adjacent to the Championship, Dick Bailey-designed golf course, offering filtered views of the 8th tee. The home features five bedrooms and 4.5 baths, including three ensuite bathrooms, one with a tub/shower, and a half-bath. The European white oak rustic flooring adds charm, while the living room boasts built-in bookcases with an 11-foot rolling ladder. Entertain in style with a walk-in bar equipped with a 2-zone wine fridge, beverage fridge, sink, and walk-in storage. The kitchen is a chef’s dream, featuring granite countertops with a butcher block island, a 3-foot Subzero refrigerator, double convection ovens with a “steam assist” feature, a warming drawer, a Sharp drawer microwave, a 6-burner gas cooktop, a trash compactor, a dishwasher, custom hardwood cabinets with full-extension drawer guides, and a walk-in pantry. The home is equipped with dual HVAC systems for upstairs and downstairs, a Beam hide-a-hose central vacuum system, supplemental water heaters, and many more amenities. The exterior of the property is just as impressive, with a firewise landscaped yard, an automatic watering system, and outdoor lighting. The rear flagstone patio features a built-in gas barbecue with an onyx countertop; an above-ground 400-gallon, 6-person spa; and and lots of space to sit back and enjoy the scenic views of the mountains beyond. This is high-class mountain living at its finest! Visit: www.lodgeatwhitehawk.com – www.golfwhitehawk.com – www.whitehawkranch.org
MlsNumber: --
ListingId: 20240675


Listing Provided By: COLDWELL BANKER REALTY (Truckee), original listing
Phone: (530) 587-5133
Office Phone: (530) 587-7474
Agent Name: HERSCHEL DEARDORFF
Disclaimer: Copyright © 2025 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