Title Page Background
DEBUG FN args: Array ( [0] => 212 [1] => [2] => [3] => agent ) BEFORE: Site: 212 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 212 Igate: njhud LocID: 212 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 212 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 212 [1] => [2] => [3] => lender ) BEFORE: Site: 212 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 212 Igate: njhud LocID: 212 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 212 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 212 [1] => [2] => [3] => other ) BEFORE: Site: 212 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 212 Igate: njhud LocID: 212 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 212 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

295 Co Rd 149
Lookout, CA 96054
Donna Utterback with California Outdoor Properties, Inc - Fall River, original listing - (619) 933-5504

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $690,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1700 Square Feet
Agency: California Outdoor Properties, Inc - Fall River
Agency Phone: (619) 933-5504

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 128 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Desirable river bottom soil is a great feature for this 128+ acre cattle and hay ranch with Pit River running through! 80 acres that have been irrigated in the past. Wood bridge over river to access east side. The ranch is fenced for cattle. Fencing in need of repair in some areas. There are 4 homes on the property. Several outbuildings, large pole barn, older animal/hay barn and shop. There are 3 domestic wells. The property needs some overall cleanup. This is an estate sale; the owner has limited to no knowledge of the working operation or condition of irrigation system. Which creates an ''AS IS, WHERE IS, AS IT STANDS'' sale. This ranch is full of potential with the benefit of being on the river!<br /> <br /> <br /> <br /> Property Highlights:<br /> 2 - five tower pivots, flood and wheel lines.<br /> Two pumps in the river, 20 Hp and 25 HP.<br /> Also, an ag well with 5 HP pump.<br /> Condition of the pumps to be determined by buyer.<br /> All on SPV power for lower cost. Wood bridge over river to access east side.<br /> The main home is 2 story, 1700+ sf offering 3 bedrooms and 2 baths.<br /> Second home is located close to the river, with 2 bedrooms and 1 bath. In addition<br /> Double wide mobile home with 3 bedrooms and 2 baths<br /> Singlewide mobile home with 2 bedrooms and 1 bath plus side addition for living area<br /> All homes are in need of some TLC.<br /> Several outbuildings, large pole barn, 2 - older animal/hay barns, shop and storage buildings.
MlsNumber: --
ListingId: 24-4942


Listing Provided By: California Outdoor Properties, Inc - Fall River, original listing
Office Phone: (619) 933-5504
Agent Name: Donna Utterback
Disclaimer: Copyright © 2024 LandLeader. 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