3749 Shiloh Road, Modesto, CA 95358 - Photo 1

1/1

$3,800,000

Sold
Closed
Multi-Family
3 Total Beds
3 Car Garage

1/1

Property Description

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.

Full Property Details

Full Property Details for 3749 Shiloh Rd

General

Sold For: $3,800,000
Status: Closed
Type: Multi-Family
Source: METROLIST_Cali
MLS ID: 225135201
Added to Site: 162 day(s) ago

Interior

Rooms/Areas: Master Bathroom, Master Bedroom, Dining Room, Family Room, Kitchen, Living Room
Fireplace: Yes
Number of Fireplaces: 1
Fireplace(s): Brick, Fireplace Insert
Appliances: Built-In Electric Oven, Built-In Electric Range, Free Standing Refrigerator, Dishwasher, Disposal, Plumbed For Ice Maker, Electric Cook Top, Electric Water Heater
Flooring: Carpet, Laminate, Vinyl

Rooms

Bathrooms

Total Bathrooms: 2
Full Bathrooms: 2
Bathroom Features: Shower Stall(s), Tile, Radiant Heat, Window
Primary Bathroom: Shower Stall(s), Tile, Radiant Heat, Window

Bedrooms

Total Bedrooms: 3
Primary Bedroom: Closet

Other Rooms

Kitchen: Pantry Cabinet, Ceramic Counter
Dining Room: Other
Laundry: Cabinets, Sink, Space For Frzr/Refr, In Garage

Parking

Garage: Yes
Garage Spaces: 3
Parking: 1/2 Car Space, Attached, Detached, Garage Facing Front

Location

County: Stanislaus
Cross Streets: Grayson
Driving 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.
Direction Faces: South

School Information

School District: Stanislaus

Heating & Cooling

Cooling Type: Ceiling Fan(s), Whole House Fan, Heat Pump
Heating Type: Fireplace(s), Heat Pump
Heating Fuel: Fireplace(s), Heat Pump

Utilities

Sewer: Septic System, Septic Connected
Water: Well
Utility Description: Electric, Internet Available

Structural Information

Architectural Style: Ranch
Construction: Brick, Ceiling Insulation, Concrete, Stucco, Floor Insulation, Wall Insulation, Glass
Basement: Yes
Foundation: Concrete, PillarPostPier, Raised
Roof: Shingle, Fiberglass
Windows: Caulked/Sealed, Dual Pane Full
Stories/Levels: 1
Square Feet: 1,865
Sq. Ft. Source: Assessor Agent-Fill
Year Built: 1960

Additional Structures

Other Structures: Barn(s), Second Garage, Greenhouse, Outbuilding

Lot Features

Property View: Orchard, Panoramic, Park, Garden/Greenbelt, Mountains
Mountain views: Yes
Lot Size (Acres): 100.32
Lot Size (Sq. Ft.): 4,369,939
Irrigation System: Irrigation District
Topography: Hillside
Zoning: A240
Lot Description: Auto Sprinkler F&R, Greenbelt, Landscape Back, Landscape Front
Fencing (Description): Metal, Partial, Masonry

Disclosures and Reports

Special Conditions: Other
APN: 017-066-004-000

Listed by PMZ Commercial Real Estate
Sold by PMZ Commercial Real Estate

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code optional

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Comment *

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Submit, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

Listing agents

— 3749 Shiloh Rd —

PMZ Commercial Real Estate
PMZ Commercial Real Estate

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 3749 Shiloh Rd

School District:Ceres Unified School District

Name	Grades	Distance
Westport Elementary School 5218 South Carpenter Road, Modesto, CA 95358	K-6	6.5 mi
Blaker-Kinser Junior High School 1601 Kinser Road, Ceres, CA 95307	7-8	9.7 mi
Central Valley High School 4033 Central Avenue, Ceres, CA 95307	9-12	10.1 mi

Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 3749 Shiloh Rd

Date

Details

Price

Change

Source

2/26/2026

Sold

$3,800,000

-7.32%

MLS

10/20/2025

Listed

$4,100,000

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

0 Faith Home Rd, Ceres, CA 95307 - Photo 1

Just Listed

$1,055,000

0 Faith Home Rd Ceres, CA 95307

Agricultural Land
Active
Updated 6 days ago

19.17
Acres

Listed by PMZ Real Estate

3501 Soda Canyon Dr, Ceres, CA 95307 - Photo 1

Just Listed

$570,000

3501 Soda Canyon Dr Ceres, CA 95307

Single Family
Active
Updated 1 day ago

4
Beds
3
Total Baths
2,053
Sq. Ft.

Listed by Barrios Realty Consultants

Just Listed

$450,000

3007 Dale Ct Ceres, CA 95307

Single Family
Active
Updated 1 day ago

2,304
Sq. Ft.

Listed by Xpert Home Realty

2841 Fowler Rd, Ceres, CA 95307 - Photo 1

Just Listed

$155,000

2841 Fowler Rd #89 Ceres, CA 95307

Manufactured Home
Active
Updated 6 days ago

2
Beds
2
Total Baths
1,344
Sq. Ft.

Listed by PMZ Real Estate

3401 Matterhorn Way, Ceres, CA 95307 - Photo 1

Price Reduced

-$10,000 (-2.04%)

$479,000

3401 Matterhorn Way Ceres, CA 95307

Single Family
Active
Updated 20 hours ago

3
Beds
2
Total Baths
1,255
Sq. Ft.

Listed by Jimmi Weaver, Broker

5446 Harvest Crk Dr, Riverbank, CA 95367 - Photo 1

Price Reduced

-$4,000 (-0.74%)

$539,990

5446 Harvest Crk Dr Riverbank, CA 95367

Single Family
Active
Updated 4 days ago

3
Beds
2
Total Baths
1,469
Sq. Ft.

Listed by KB HOME Sales-Northern California Inc

6421 Maple Leaf Ln, Riverbank, CA 95367 - Photo 1

Price Reduced

-$10,000 (-1.83%)

$535,000

6421 Maple Leaf Ln Riverbank, CA 95367

Single Family
Active
Updated 3 days ago

5
Beds
3
Total Baths
1,857
Sq. Ft.

Listed by Century 21 Select Real Estate

Newbrook Circle, Riverbank, CA 95367 - Photo 1

Price Reduced

-$14,000 (-10.85%)

$115,000

Newbrook Circle #8 Riverbank, CA 95367

Single Family
Active
Updated 3 days ago

3
Beds
2
Total Baths
1,152
Sq. Ft.

Listed by HomeSmart PV and Associates

6919 Yosemite Blvd, Modesto, CA 95357 - Photo 1

Sold

$4,306,380

6919 Yosemite Blvd Modesto, CA 95357

Agricultural Land
Closed

110.42
Acres

Listed by PMZ Commercial Real Estate
Sold by My Global Realty, Inc.

3749 Shiloh Road, Modesto, CA 95358 (MLS# 225135201) is a Multi-Family property that was sold at $3,800,000 on February 26, 2026. Want to learn more about 3749 Shiloh Road? Do you have questions about finding other Multi-Family real estate for sale in Modesto? You can browse all Modesto real estate or contact a Coldwell Banker agent to request more information.

3749 Shiloh Rd Modesto, CA 95358

Full Property Details for 3749 Shiloh Rd

General

Interior

Rooms

Bathrooms

Bedrooms

Other Rooms

Parking

Location

School Information

Heating & Cooling

Utilities

Structural Information

Additional Structures

Lot Features

Disclosures and Reports

Listing agents

Get Pre-Approved Today

Be ready to buy your new home!

Be ready to buy your new home!

Schools serving 3749 Shiloh Rd

Price & Sales History for 3749 Shiloh Rd

Just Listed near 3749 Shiloh Rd

0 Faith Home Rd Ceres, CA 95307

3501 Soda Canyon Dr Ceres, CA 95307

3007 Dale Ct Ceres, CA 95307

2841 Fowler Rd #89 Ceres, CA 95307

Price Reduced near 3749 Shiloh Rd

3401 Matterhorn Way Ceres, CA 95307

5446 Harvest Crk Dr Riverbank, CA 95367

6421 Maple Leaf Ln Riverbank, CA 95367

Newbrook Circle #8 Riverbank, CA 95367

Recent Sales near 3749 Shiloh Rd

6919 Yosemite Blvd Modesto, CA 95357