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;

342 Settlers Road
Chester, CA 96020

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,092,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3640
Agency: Coldwell Banker Kehr/OBrien Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2002
Notes: Gorgeous, one level home in popular Martin Ranch. Backing to the meadow, this residence is situated in a serene, parklike setting with small pond and a meandering creek. Wonderful floor plan with four bedrooms (two of them master suites), three full baths & two half baths, den/tv room, library and office. The delightful great room includes an abundance of windows for lots of natural light, attractive rock hearth w/wood stove and access to the spacious back synthetic deck. Adjoining the great room is an upgraded kitchen with quartz counters, quartz backsplash & eating bar. The dining area with bay window and built-in hutch is adjacent to the kitchen making entertaining easy. Main master suite offers access to the 6 person outdoor spa, sizable walk-in closet, double sink vanity & large shower. This residence offers many other amenities such as: hardwood and tile floors, crown molding, 1344 square foot four car garage with 20 x 13 workshop, covered front porch, side covered wood storage, (2) full RV hookups, two storage areas in attics over the house and garage, central propane heat, fenced in backyard w/side gate & drive through access to the rear of the lot, double car carport, spectacular landscaping front and back on auto sprinklers and hard to find horse property. Relax and enjoy delightful views of the back lawn and meadow from the home or back deck, or gather around the fire pit. This is a special home and conveniently located just minutes from the heart of Chester.
MlsNumber: 20240391


Listing Provided By: Coldwell Banker Kehr/OBrien Real Estate, original listing
Name: Coldwell Banker Kehr/OBrien Real Estate
Phone: (530) 258-2103
Office Name: COLDWELL BANKER KEHR/O'BRIEN (L)
Office Phone: (530) 259-4801
Agent Name: CATHY KUERSTEN
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