Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/MC25144838/8808-State-Highway-140/Atwater/https://www.londonproperties.com/images/props/crmls/full/MC25144838.jpgLondon Properties Atwater Real Estate | 8808 State Highway 140
Listing Agent: Sarah Bell, California Land & Home by KW
Turnkey 35± acre property featuring a producing almond orchard, irrigated pasture, and a spacious custom-built home-perfect for farm living, 4-H/FFA projects, and continued ag production. The home offers approx. 3,400 sq. ft. of living space with 3 bedrooms, 2.5 bathrooms, a detached 2-car garage, and beautifully landscaped front and backyards complete with mature landscape and a tranquil waterfall and pond. Approx. 23.5± acres are planted in a 2016 almond orchard (50% Nonpareil, 50% Monterey) with double line drip irrigation and a strong 4-year production average of 2,222 lbs/acre. The remaining acreage is in irrigated pasture. The operation is irrigated via a deep well and is located in the Merced Subbasin GSA. The property includes extensive ag and livestock infrastructure: • 60x60 pole barn • Livestock barn • Cold box for steers • Tack room • Secure farm storage building This versatile property is well-suited for a variety of uses. Marketing package available upon request. Don't miss out on this opportunity. Schedule a private showing today!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1757500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1942500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3214 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3714 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` = 1672903 OR `props-main`.`id` = 1693410 OR `props-main`.`id` = 1699251 OR `props-main`.`id` = 1699288 OR `props-main`.`id` = 1515911 OR `props-main`.`id` = 1600036 OR `props-main`.`id` = 1699289 OR `props-main`.`id` = 1696468)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25144838' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-27' 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
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.
