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

135 Riverview Drive
Oroville, CA 95966

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1950
Agency: Table Mountain Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 554,518 sqft
Property Type: Residential
Year Built: 1977
Notes: Location! HORSE PROPERTY! WHAT? A 12.73 acre property w/custom home and horse stable/barn in one of Oroville's most desirable locations!? This 1950 SQ.FT. home, built in 1977, still holds that era charm! Come in! Find level entry foyer leading into large living room w/beamed ceiling & a corner brick fireplace w/pellet stove insert. Dining room has a slider out to the back covered deck, w/views of property pastures,(imagine your horses!)the surrounding foothills & a peek-a boo view of the Miners Ranch Reservoir. Then find kitchen, w/pass thru to dining room, a breakfast nook, & a view window. Tons of cupboards & storage. Off kit. one of the bedrooms has been used as an office/mud room, has utility sink & commode, w/exits to back deck, hot tub, & garage! Convenient! Primary Bedroom & 2nd bedroom have new carpet, "den" has laminate. Primary bath has been upgraded, interior barn door entry, beautiful tile shower surround. Common bath is original, tub/shower, linen closet, & laundry room combo! Water is served by South Feather, Water & Power, with our area's best water rate! Other features include the 2-stall barn w/tack room/attached 2 car garage w/hay storage, round pen/ring for horse training, separate fenced paddock, a dog kennel, several citrus & fruit trees, seasonal creek, property is fenced and cross fenced, (bring your livestock!) , garden area, a workshop inside garage w/counters & plenty of storage cabinets, & newer HVAC! The acreage is amazing, as future development may be a possibility, an easement located off of Gleness! Buyer to investigate with Butte County Dept. of Development. Call 530-693-0690, Lauralyn A. Lambert, CALDRE Lic.#01415659 & make an appt to see this SPECIAL property TODAY!
MlsNumber: OR24059230


Listing Provided By: Table Mountain Realty, original listing
Name: Table Mountain Realty
Phone: (530) 370-6061
Office Name: Table Mountain Realty, Inc.
Office Phone: (530) 370-6061
Agent Name: Lauralyn A. Lambert
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','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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