Date
Details
Price
Change
Source
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.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/13
$4,100,000 Sale Pending
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/13
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
- Price: $4,100,000
- Status: Pending
- Type: Multi-Family
- Source: METROLIST_Cali
- MLS ID: 225135201
- Updated: 1/12/2026
- Added to Site: 88 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
- Elem School District: Ceres Unified
- Midd School District: Ceres Unified
- High School District: Ceres Unified
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
- Street/Road Desc.: Asphalt
- 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
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 3749 Shiloh Rd —
PMZ Commercial Real Estate
PMZ Commercial Real Estate
NMLS#: 1598647Get Pre-Approved Today
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 Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 3749 Shiloh Rd
Tax History
Tax History for 3749 Shiloh Rd
Year
Property Taxes
Change
Tax Assessment
Change
2025
$13,708
8%
$1,128,739
3%
2023
$12,646
3%
$1,094,109
4%
2022
$12,291
9%
$1,049,985
10%
2021
$11,286
3%
$950,345
1%
2020
$10,960
1%
$941,238
2%
2019
$10,893
2%
$920,511
2%
2018
$10,680
2%
$902,462
2%
2017
$10,521
5%
$884,763
2%
2016
$9,987
1%
$867,416
2%
2015
$9,862
2%
$854,388
2%
2014
$9,662
1%
$833,870
—
2013
$9,604
—
$833,870
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 3749 Shiloh Rd
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 14 hours ago
- 3Beds
- 2Total Baths
- 1,511Sq. Ft.
Listed by KW Sac Metro
- Single Family
- Active
- Updated 3 days ago
- 3Beds
- 1Total Bath
- 1,274Sq. Ft.
Listed by HomeSmart PV & Associates
- Commercial Land
- Active
- Updated 3 days ago
- 0.3067Acres
Listed by Rand Commercial Properties
- Manufactured Home
- Active
- Updated 4 days ago
- 3Beds
- 2Total Baths
- 1,187Sq. Ft.
Listed by Allison James Estates & Homes
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Manufactured Home
- Active
- Updated 3 days ago
- 2Beds
- 2Total Baths
- 1,536Sq. Ft.
Listed by EXIT Realty Consultants
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 2Total Baths
- 1,841Sq. Ft.
Listed by HomeSmart PV & Associates
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 3Total Baths
- 2,039Sq. Ft.
Listed by PMZ Real Estate
- Single Family
- Active
- Updated 12 hours ago
- 4Beds
- 3Total Baths
- 1,894Sq. Ft.
Listed by D R Horton America's Builder
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Agricultural Land
- Closed
- 110.42Acres
Listed by PMZ Commercial Real Estate
Sold by My Global Realty, Inc.
Sold by My Global Realty, Inc.
3749 Shiloh Road, Modesto, CA 95358 (MLS# 225135201) is a Multi-Family property with units containing 3 bedrooms and 2 full bathrooms. 3749 Shiloh Road is currently listed for $4,100,000 and was received on October 20, 2025. 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.