100 +/- Acre Ranch known as Stardust Farms with history as a Jersey Dairy prior to the planting of almonds. The orchards were planted in phases as Block 1; 40+/- acres planted in 1996 to Butte and Padre on Lovell root stock, Block 2; 20+/- acres planted 1999 to Carmel and Monterey on Nemaguard rootstock and Block 3; 22+/- acres planted to Nonpareil, Carmel and Monterey all on Nemaguard rootstock. The last 5 years average production is approximately 1,757 pounds per acre. The property is in the Turlock Irrigation District and is flood irrigated from TID lateral 2. There are two homes on the property. The main house is 1,865SqFt 3 bedroom 2 baths built in 1982. It has a single car attached garage and an additional 2 car detached garage. The second home is approximately 1,600SqFt, 3 bedrooms 2 bath built in approximately 1960. Detached office space behind the main house. In the area of the second house is a milk barn, large open sided pole barn, a cinderblock building/shop/laundry room and several older sheds. Both houses are separated by approximately mile. Each home has its own domestic well and septic system. A must see opportunity.
MLS #
ME225135201
MLS Source
MetroList Services, Inc.
Days on Site
16
Bedrooms
Primary Bath, Primary Suite/Retreat
Kitchen
Countertop - Ceramic, Hookups - Ice Maker, Other, Pantry Cabinet
Appliances
Cooktop - Electric, Dishwasher, Garbage Disposal, Other, Oven - Built-In, Oven - Electric, Oven Range - Built-In, Oven Range - Electric, Refrigerator
Dining Room
Other
Family Room
Other
Fireplace
Brick, Insert
Flooring
Carpet, Laminate, Vinyl
Laundry
Cabinets, In Garage, Space for Frzr/Refr, Tub / Sink
Cooling
Ceiling Fan, Whole House Fan
Heating
Fireplace, Fireplace Insert, Heat Pump, Radiant
Roof
Fiberglass, Shingle
Foundation
Pillar/Post/Pier, Raised, Slab
Pool
Pool - No
Style
Ranch
Garage/Parking
Attached Garage, Detached, Facing Front, Garage: 3 Car(s)
Elementary District
Ceres Unified
High School District
Ceres Unified
Sewer
Septic Tank
Water
Well
Zoning
A240
Listing Agent
Lynn Garber
PMZ Commercial Real Estate
License #: 01313826
Phone: (209) 491-3408
Co-Listing Agent
Kally Fulke
PMZ Commercial Real Estate
License #: 01433242
Phone: (209) 491-3405
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
3749 Shiloh Rd is a Residential in Modesto, CA 95358. This 1,865 square foot property sits on a 100.32 Acres Lot and features 3 bedrooms & 2 full bathrooms. It is currently priced at $4,100,000 and was built in –. This address can also be written as 3749 Shiloh Rd, Modesto, CA 95358.
©2025 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of October 20, 2025. For the most current information, please contact Lynn Garber, (209) 491-3408