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.
Multi-familyProperty Type
1960Year Built
100.32 acresLot Size
$1,766Est. Price/Sq.Ft.
3 car garageParking
Listed by Lynn Garber•DRE #01313826• PMZ Commercial Real Estate
Listed by Kally Fulke•DRE #01433242• PMZ Commercial Real Estate
Bought with Greg Austin•DRE #01951398• PMZ Commercial Real Estate
This is a new listing, so no sales records exist yet. As the MLS and public records start to fill up, we'll list the details here.
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Multi-Family (2-4 Unit)
County
Stanislaus County
APN
017-066-004-000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 20, 2025.
A-2-40
General Agriculture District
It is the intent of these district regulations to support and enhance agriculture as the predominant land use in the unincorporated areas of the county. These district regulations are also intended to protect open space lands pursuant to Government Code Section 65910. The procedures contained in this chapter are specifically established to ensure that all land uses are compatible with agriculture and open space, including natural resources management, outdoor recreation and enjoyment of scenic beauty.
Permitted uses
Include but are not limited to:
Agriculture
Day care facility
Housing-Single unit
Jul 27, 2012 • Final
Residential reroof
Tear off the existing roof, install new sheathing, and reroof with composition shingles.
Roofing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking & Garage Information
Garage Spaces: 3
Parking Features: 1/2 Car Space, Attached, Detached, Garage Facing Front
Other Bathroom Features: Tile, Tub, Tub w/Shower Over, Window, Radiant Heat
Bedroom Information
# of Bedrooms (Total): 3
Master Bedroom Features: Closet
Heating & Cooling
Cooling: Ceiling Fan(s), Whole House Fan, Heat Pump
Heating: Fireplace(s), Heat Pump
Interior Features
Appliances: Built-In Electric Oven, Built-In Electric Range, Free Standing Refrigerator, Dishwasher, Disposal, Plumbed For Ice Maker, Electric Cook Top, Electric Water Heater
Fireplaces Total: 1
Fireplace Features: Brick, Insert
Flooring: Carpet, Laminate, Vinyl
Laundry Features: Cabinets, Sink, Space For Frzr/Refr, In Garage
Patio And Porch Features: Front Porch, Covered Patio
Window Features: Caulked/Sealed, Dual Pane Full
# of Stories: 1
Room Information
Room Type: Master Bathroom, Master Bedroom, Dining Room, Family Room, Kitchen, Living Room
Living Room Features: Other
Kitchen Features: Pantry Cabinet, Ceramic Counter
Dining Room Features: Other
Main Level: Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Basement Sq.Ft.: 0
Exterior
Exterior Features
Fencing: Metal, Partial, Masonry
Allows Horses: No
Roof: Shingle, Fiberglass
Pool Information
Has Private Pool: No
Has Spa: No
Property Information
Property Type: Residential
Property Sub Type: 2 Houses on Lot
Subtype Description: Semi-Custom
Year Built: 1,960
Land Information
Land Use: Agricultural, Farm, Orchard
Lot Information
Lot Features: Auto Sprinkler F&R, Greenbelt, Landscape Back, Landscape Front
Lot Size Square Feet: 4,369,939
Lot Size Acres: 100.32
Other Structures: Barn(s), Second Garage, Greenhouse, Outbuilding
Utilities
Green Energy Information
Power Production Year Install: 0
Power Production Size: 0.00
Utility Information
Utilities: Internet Available
Electric: 3 Phase
Sewer: Septic System, Septic Connected
Irrigation Source: Irrigation District
Water Source: Well
Location
HOA Information
Association YN: No
School Information
School District County: Stanislaus
Elementary School District: Ceres Unified
Middle Or Junior School District: Ceres Unified
High School District: Ceres Unified
Location Information
Postal Code Plus 4: 8229
Postal Code: 95358
County Or Parish: Stanislaus
CrossStreet: Grayson
Directions: West on Grayson Road, North on Shiloh Road to the property. The property has two addresses 3749 Shiloh Rd and 3789 Shiloh Rd. The entrance is off Shiloh Rd at the white fence.
State Or Province: CA
Street Number Numeric: 3749
Unparsed Address: 3749 Shiloh Rd, Modesto, CA 95358-8229
Street Address Filtered: 3749 Shiloh Rd
Community Information
Senior Community YN: No
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Multi-Family (2-4 Unit)
Year Built: —
Year Renovated: —
County: Stanislaus County
APN: 017-066-004-000
Home facts updated by county records on Oct 20, 2025
Other
Selling Agent
Buyer Agent Full Name: Greg W Austin
Around this home
Schools
Places
Transit
Westport Elementary School
Public K-6 • Assigned • 6.5mi
3/10
Blaker-Kinser Junior High School
Public 7-8 • Assigned • 9.7mi
6/10
Central Valley High School
Public 9-12 • Assigned • 10.1mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
6/10 Flood Factor
Estimated 22-32% chance of a flood reaching the building in the next 30 years
6/10 Fire Factor
9% chance of being in a wildfire in next 30 years
6/10 Heat Factor
7 days above 102° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
24 unhealthy days expected this year, 25 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95358
Average low and high temperatures (°F)
60
40
64
44
73
48
74
49
83
54
90
58
91
59
94
63
90
61
80
55
64
47
55
43
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 12.9 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.
12.9 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$3.13M – $3.79M
Sell confidently with a local market expert in Modesto. 3 minutes to get started.