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;

14580 Sunny Ridge Drive
Red Bluff, CA 96080

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $485,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2600
Agency: Stromer Realty Company of California

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1977
Notes: Location, location, location! Welcome to your sanctuary by the river where tranquility meets natural beauty! Nestled along the majestic Sacramento River, this stunning 2600 square foot home offers unparalleled views of the Sacramento River and the Eastern foothills. Upon arriving at the property, you will find a large 1-acre parcel with a park-like ambiance and long driveway, giving you peace and privacy from the road. Step inside and be greeted by an inviting open-concept living area with soaring open beam vaulted ceilings adorned with cedar planking and a fully equipped kitchen with endless storage, beautiful cabinetry and high-end appliances. The separate family and living room offer the perfect opportunity for entertainment and comfort. Host a get together in the formal living room or cozy up next to the pellet stove in the family room and watch a movie with a loved one. Every room boasts expansive windows framing picturesque river vistas, inviting the nature indoors. Need more space? The multi-functional bonus room features a wet bar offering endless possibilities, whether you envision it as a home office, a rec room, or an additional bedroom- the choice is yours! Step out onto the spacious deck to savor morning coffee or evening cocktails while soaking in the beauty of the river. When you are ready to relax & unwind, head down to the lower level where you will find the 2 spacious guest bedrooms and the expansive primary bedroom. It features a nicely sized walk-in closet, private deck area with grass and an en suite bath with dual sinks and a tiled walk-in shower. Other wonderful amenities include ceiling fans throughout, indoor laundry, a quaint dining area, a 10x19 storage room and an additional detached storage building that could serve many uses! Embrace the slower lifestyle of Tehama County by owning this little slice of heaven in the beautiful Surrey Village area of Red Bluff, CA.
MlsNumber: 20240164


Listing Provided By: Stromer Realty Company of California, original listing
Name: Stromer Realty Company of California
Phone: (530) 366-1885
Office Name: STROMER REALTY COMPANY
Office Phone: (530) 527-3100
Agent Name: Alexandra Berzin
Disclaimer: Copyright © 2024 Tehama County 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