Approx. 48.42 acres in eleven year old producing almonds within the Turlock Irrigation District (TID). Home is fixer (3 bed/2bath). Addresses of other two parcels included are 3818 Youngstown Road and 2818 Youngstown Road. Do not disturb tenant on property.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
Fixer
Year Built
1945
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
No
Stories
2
Home Warranty
No
Directions to Property
From Hwy. 99, travel eastward on W. Main Street. Right on N Golden State Blvd. South to Youngstown Road.
Cross Street
N Golden State Blvd.
County
Stanislaus
Special Listing Conditions
None
Main Level
Living Room, Kitchen
Architectural Style
Ranch
Construction Materials
Frame
Foundation
Raised
Roof
Other
Heating
Other
Cooling
Other
Laundry Features
Other
Full Bathrooms
2
Bath Features
Other
Flooring
Other
Kitchen Features
Breakfast Area
Dining Room Features
Formal Area
Living Room Features
Great Room
Upper Level
Bedroom(s)
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
See Remarks
Irrigation
Agricultural Well, Public District, Irrigation District
Water Source
Water District, Well
Sewer
Septic System
Parking Features
See Remarks
Lot Features
Shape Irregular
APN
044 033 005 000
Land Use
Agricultural, Farm, Ranch, Orchard
View Description
Orchard
Horse Property
No
Zoning Description
Agriculture
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Turlock Unified
Middle or Junior School District
Turlock Unified
Senior High School District
Turlock Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1839960 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2033640 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) >= 1277 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1777 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` = 1680202 OR `props-main`.`id` = 1693094 OR `props-main`.`id` = 1697541 OR `props-main`.`id` = 1697542 OR `props-main`.`id` = 1697538 OR `props-main`.`id` = 1697543 OR `props-main`.`id` = 1690740 OR `props-main`.`id` = 1693313 OR `props-main`.`id` = 1681626 OR `props-main`.`id` = 1696104 OR `props-main`.`id` = 1692708 OR `props-main`.`id` = 1659532 OR `props-main`.`id` = 1676713 OR `props-main`.`id` = 1693060 OR `props-main`.`id` = 1676721 OR `props-main`.`id` = 1697483 OR `props-main`.`id` = 1697420 OR `props-main`.`id` = 1662552 OR `props-main`.`id` = 1697843 OR `props-main`.`id` = 1697945 OR `props-main`.`id` = 1697539 OR `props-main`.`id` = 1697743 OR `props-main`.`id` = 1697767 OR `props-main`.`id` = 1693119 OR `props-main`.`id` = 1693083 OR `props-main`.`id` = 1697965 OR `props-main`.`id` = 1693162 OR `props-main`.`id` = 1692833 OR `props-main`.`id` = 1697611)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225046120' 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 John Lazar, Century 21 Select Real Estate 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.
