Home | Stanislaus County | Modesto | 95358 | 3749 Shiloh Rd
3749 Shiloh Rd, Modesto, CA 95358
MLS: ME225135201 | Status: Sold | Price: $3,800,000
Beds/Baths: 3 / 2
Property Type: Residential
Quick Facts
| Beds |
Baths |
Sq Ft |
Acres Lot |
Yr Built |
| 3 |
2 |
1,865 |
100.32 |
– |
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.
| Field |
Value |
| MLS # |
ME225135201 |
| MLS Source |
MetroList Services, Inc. |
Features
Interior Features
| Feature |
Details |
| 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 |
Exterior Features
| Feature |
Details |
| Roof |
Fiberglass, Shingle |
| Foundation |
Pillar/Post/Pier, Raised, Slab |
| Pool |
Pool - No |
| Style |
Ranch |
| Feature |
Details |
| 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 |
Co-Listing Agent |
| Lynn Garber |
Kally Fulke |
| PMZ Commercial Real Estate |
PMZ Commercial Real Estate |
| License #: 01313826 |
License #: 01433242 |
| Phone: (209) 491-3408 |
Phone: (209) 491-3405 |
Property Units
| # Buildings |
# Leased Units |
# Total Units |
| 0 |
– |
– |
School Ratings
School data provided by GreatSchools.org
Nearby Schools
Disclosures
©2026 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 February 27, 2026. For the most current information, please contact Lynn Garber, (209) 491-3408.