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;

12866 Gardenia Avenue
Red Bluff, CA 96080

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11,089 sqft
Property Type: Residential
Year Built: 2017
Notes: You will fall head over heals for this wonderful home built in 2017, situated at the end of the street in a tranquil rural neighborhood of large lots in Red Bluff. NO HOA on this one. Up to date and spacious with all of the best features, this 1769 sq ft home will meet all of your needs with split floor plan 3 specious bedrooms plus an office, 2 bathrooms, laundry room, open gorgeous kitchen and generous backyard. Extra special is that there is plenty of space between homes on all sides of this amazing special parcel. There is room for fenced and unfenced Rv Parking or to Add your pool, garden or workshop. Welcome your guests in to this comfortable and current, open floorplan. You won't ever want to leave your gorgeous kitchen with island, pantry, stainless appliances, cabinets with pull out shelves, solid surface countertops and plenty of storage throughout. If you need a large dining room area, it has that as well. The desireable features are endless. You need to look no further than this gently lived, move-in ready home. Red Bluff is located between Sacramento and Oregon on the Sacramento River with nearby golfing, hiking, horseback riding, hunting, biking, and more. Live Oak Acres Road & Detention Pond Maintenance Assn approx $250 per yr. sq ft, lot size and all other information taken from county records, buyer to verify any and all information to their satisfaction
MlsNumber: SN24076062


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