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` = 1710541 OR `props-main`.`id` = 1697541 OR `props-main`.`id` = 1697542 OR `props-main`.`id` = 1697538 OR `props-main`.`id` = 1690740 OR `props-main`.`id` = 1710655 OR `props-main`.`id` = 1708407 OR `props-main`.`id` = 1710336 OR `props-main`.`id` = 1659532 OR `props-main`.`id` = 1676713 OR `props-main`.`id` = 1710522 OR `props-main`.`id` = 1676721 OR `props-main`.`id` = 1662552 OR `props-main`.`id` = 1706964 OR `props-main`.`id` = 1709444 OR `props-main`.`id` = 1697843 OR `props-main`.`id` = 1702927 OR `props-main`.`id` = 1704764 OR `props-main`.`id` = 1697743 OR `props-main`.`id` = 1710899 OR `props-main`.`id` = 1710536 OR `props-main`.`id` = 1711007 OR `props-main`.`id` = 1710577 OR `props-main`.`id` = 1710400 OR `props-main`.`id` = 1697611 OR `props-main`.`id` = 1706956 OR `props-main`.`id` = 1710942)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225046120' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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.
