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 = 186 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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 = 186 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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 = 186 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;

9256 Turner Lane
Durham, CA 95938

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,358,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4450
Agency: REMAX of Chico

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 167,706 sqft
Property Type: Residential
Year Built: 1996
Notes: Nestled within the charming town of Durham and surrounded by orchards, this unique custom estate, crafted by Architect Len Goldman, makes its market debut. Making it a one-of-a kind opportunity! As soon as you arrive through the tree-lined driveaway and circular entrance, you will immediately fall in love with its stone accents, private setting, immaculate landscaping, and a welcoming double door grand entry way. Once inside, you are greeted with soaring ceilings, large windows letting in the perfect amount of natural light and a formal separate living room that is ideal for hosting holiday gatherings. Take gourmet to the next level in this fully equipped kitchen. It offers beautiful maple wood cabinetry, granite countertops, updated stainless steel appliances, a gas cook top, double oven, wine fridge, a walk-in pantry and a large center island with a vegetable sink and a breakfast bar where guests can easily chat with the chef. For quieter moments, the expansive family room adjacent to the kitchen offers a charming wood stove framed by unique stone and built-in cabinetry. Looking for even more room? This home not only gives you an office space but a huge game room giving you another great area for entertaining. Relax and unwind in the primary bedroom. It features wood ceilings, private access to the backyard, a walk-in closet and spa-like en suite bath that gives you dual sinks, a soaking tub and fully tiled walk-in shower. Other amazing amenities include recessed lighting, ceiling fans throughout, separate indoor laundry room with storage, 3 guest bedrooms that have easy access to their own bathrooms, OWNED SOLAR with 36 panels, a detached 1 bed 1 bath guest house with its very own kitchenette and the list goes on! Step outside, onto 3.85 acres that you have all to yourself, where your enjoyment has no bounds. It offers a covered outdoor patio and kitchen perfect for barbequing, a sparkling in-ground pool with a waterfall and waterslide, raised garden beds with citrus trees and herbs, an oversized 2 car garage with 10 ft high ceilings and an extra detached 4 bay shop for even more room to story your equipment and toys. Located next to the quaint downtown area of Durham and just a short drive to Chico, this private estate has everything you could ever want in a home. Do not let this opportunity pass you by!
MlsNumber: SN23178560


Listing Provided By: REMAX of Chico, original listing
Name: REMAX of Chico
Phone: (530) 514-2901
Office Name: Re/Max of Chico
Office Phone: (530) 514-2901
Agent Name: Heather DeLuca
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 186 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Samuel Ayala
ASCIIKeller Williams
Call Today!: (530) 768-9388

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App