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

19911 State Highway 36
Red Bluff, CA 96080

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2117
Agency: Keller Williams Realty Chico Area

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 233,917 sqft
Property Type: Residential
Year Built: 1979
Notes: Almost 5 acres nestled in at the end of this private road of nice ranchettes with its own gated entrance. Once a working horse ranchette, this is an opportunity to bring it back to its previous luster! Enjoy what it has to offer in your own favorite way. Fall in love with the panoramic views right from your back deck, complete with 2 pergolas and overlooking your in-ground pool before heading down to the Barn and 3 fenced pastures. Spacious home has a large bonus room with French doors to use as family room, office, extra bedroom (no closet), exercise room, large work out room, whatever your need. Beautiful tile entry leads to living room, dining area and into the large kitchen with newer stainless appliances and large eating bar/counter. Larger than usual bedrooms and generously sized bathrooms add to the comfort of this home. Central Heat & Air, a gas wall heater, pellet stove, newer ceiling fans throughout and evaporative cooler give you so many options to help with sustainability. Circle drive and cleared parking areas allow plenty of room for your vehicles, RV's and farm equipment. Being sold AS-IS. The seller has made some improvements. Some are not quite finished. This is your opportunity to have a wonderful set up with room to bring back the sparkle and make it your own. Sq ft, lot size & yr built taken from county records, buyer to verify this and all information to their own satisfaction. Call 530-519-5553 or your favorite Realtor to schedule a showing
MlsNumber: SN24084596


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: Becky Johns
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App