Charming Country 3 Bedroom Home on a 15.9 acre lot! Approx 15 Acres of Almond Trees. Septic replaced in 2019. TID Flood Irrigation. Approx 5 acres of Butte/Padre planted in 2020. Productions Records Available upon request.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1912
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
1
Home Warranty
No
Directions to Property
Mitchell Rd, Service Rd, Lockwood Rd.
Cross Street
Service
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Kitchen
Construction Materials
Wood
Foundation
Raised
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Area
Other Structures
Barn(s)
Full Bathrooms
1
Bath Features
Double Sinks, Tub w/Shower Over
Flooring
Carpet, Linoleum, Tile, Vinyl
Appliances
Free Standing Electric Oven, Free Standing Electric Range
Kitchen Features
Laminate Counter
Dining Room Features
Space in Kitchen
Living Room Features
Other
Basement
Partial
Patio And Porch Features
Awning
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Electric
Electric
220 Volts
Irrigation
Irrigation Available
Water Source
Well
Sewer
Septic Connected
Parking Features
Detached
Garage Spaces
2.00
Lot Features
Corner, Shape Regular
APN
018 045 036 000
Land Use
Agricultural, Orchard
Horse Property
No
Zoning Description
AG
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Ceres Unified
Middle or Junior School District
Ceres Unified
Senior High School District
Ceres Unified
Census Tract
30.04
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1805000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1995000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1024 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1524 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` = 1691105 OR `props-main`.`id` = 1689930 OR `props-main`.`id` = 1689743 OR `props-main`.`id` = 1693432 OR `props-main`.`id` = 1655583 OR `props-main`.`id` = 1691731 OR `props-main`.`id` = 1664315 OR `props-main`.`id` = 1697402 OR `props-main`.`id` = 1692684 OR `props-main`.`id` = 1692685 OR `props-main`.`id` = 1600757 OR `props-main`.`id` = 1693090 OR `props-main`.`id` = 1662513 OR `props-main`.`id` = 1664458 OR `props-main`.`id` = 1695410 OR `props-main`.`id` = 1697354 OR `props-main`.`id` = 1698018 OR `props-main`.`id` = 1684877 OR `props-main`.`id` = 1695115 OR `props-main`.`id` = 1697803)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224071883' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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 Bianca Alvarado, HomeSmart PV & Associates IDX provided by Reliance Marketing
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.
