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

5735 Lunt Rd.
Oroville, CA 95965

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,050,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2288
Agency: Keller Williams Realty Chico Area

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3,267,000 sqft
Property Type: Residential
Year Built: 1997
Notes: Welcome to your private oasis nestled within 75 acres of picturesque landscape! This stunning horse property boasts a custom-built home, barn, workshop, and breathtaking views that stretch across rolling green hills as far as the eye can see. Situated Yankee Hill between Butte Valley and Oroville.<br /> <br /> As you approach, you're greeted by the charm of a 1,200 sqft wrap-around porch, perfect for savoring morning coffee or evening sunsets while soaking in the tranquility of your surroundings. The property sits up at the back of the property and is fully fenced, providing security and peace of mind for both you and your beloved equine companions.<br /> <br /> Step inside the custom home and discover a spacious haven designed with comfort in mind. With 3 bedrooms and 2 and a half baths, there's ample space for both relaxation and entertainment. Energy-efficient mini-split systems ensure year-round comfort while minimizing environmental impact.<br /> <br /> The heart of the home is an open kitchen featuring gas stove top, large island, and ample storage space. Whether you're hosting a gathering or preparing a quiet meal, this kitchen is sure to inspire your inner chef.<br /> <br /> Outside, the amenities continue with a spacious barn, workshop, and extra-deep garage, providing ample space for storage, hobbies, and projects. A generator ensures peace of mind during power outages, allowing you to enjoy uninterrupted comfort and convenience.<br /> <br /> Escape the hustle and bustle of city life and embrace the serenity of country living in this unparalleled retreat. Whether you're an equestrian enthusiast, nature lover, or simply seeking a place to call home, this property offers the perfect blend of luxury, privacy, and natural beauty. Come experience the magic of this one-of-a-kind estate and make your dreams a reality! Schedule your private showing today.
MlsNumber: SN24079370


Listing Provided By: Keller Williams Realty Chico Area, original listing
Name: Keller Williams Realty Chico Area
Phone: (530) 809-3700
Office Name: Keller Williams Realty Chico Area
Office Phone: (530) 809-3700
Agent Name: Kylee Garrettson
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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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