Looking for greener pastures where your cows and your horses can graze and relax under the oak trees? Welcome home to over 17 acres of irrigated pasture, 2 ag wells & laguna irrigation piped with valves and head gates, fenced and cross fenced with a riding arena, 40 cow feed lot, and working chute. Home offers 3bd 2bath with to many updates to list. Enjoy working in a 60X50 shop with a 20' overhand for relaxing and gazing out over the lush green pastures.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Rural/Residence
Description / Subtype
Ranch/County
Year Built
1961
Location
Rural
Stories
1
Price Per Square Foot
$616
Price Per Acre
$58,014
Cumulative Days On Market
282
County
Kings
Directions
North on 41, west on Fremont. Home is on the North side of the road
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 949050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1048950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1373 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1873 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1678655 OR `props-main`.`id` = 1651878 OR `props-main`.`id` = 1691240 OR `props-main`.`id` = 1691382 OR `props-main`.`id` = 1649754 OR `props-main`.`id` = 1691377)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings231803' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-09' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Dee Dee Oliveira, Keller Williams Realty Antelope Valley
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
