$4,100,000

3749 Shiloh Rd Modesto, CA 95358

Estimated payment $22,709/month

Total Views 6,113
3 Beds
2 Baths
1,865 Sq Ft
$2,198 Price per Sq Ft

Highlights

  • Barn
  • Second Garage
  • Custom Home
  • Greenhouse
  • Panoramic View
  • 100.32 Acre Lot

About This Home

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.

Listing Agent

Lynn Garber

PMZ Commercial Real Estate License #01313826 Listed on: 10/20/2025

PMZ Commercial Real Estate

Co-Listing Agent

Kally Fulke

PMZ Commercial Real Estate License #01433242

Property Details

Home Type

  • Multi-Family

Year Built

  • Built in 1960

Lot Details

  • 100.32 Acre Lot
  • Adjoins Government Land
  • South Facing Home
  • Masonry wall
  • Partially Fenced Property
  • Aluminum or Metal Fence
  • Landscaped
  • Sprinklers on Timer

Parking

  • 3 Car Attached Garage
  • Second Garage
  • Front Facing Garage
  • Driveway

Property Views

  • Panoramic
  • Orchard Views
  • Mountain
  • Garden
  • Park or Greenbelt

Home Design

  • Custom Home
  • Brick Exterior Construction
  • Concrete Foundation
  • Pillar, Post or Pier Foundation
  • Raised Foundation
  • Blown Fiberglass Insulation
  • Ceiling Insulation
  • Floor Insulation
  • Shingle Roof
  • Fiberglass Roof
  • Concrete Perimeter Foundation
  • Stucco

Interior Spaces

  • 1,865 Sq Ft Home
  • 1-Story Property
  • Whole House Fan
  • Ceiling Fan
  • Self Contained Fireplace Unit Or Insert
  • Brick Fireplace
  • Double Pane Windows
  • Family Room
  • Living Room
  • Dining Room

Kitchen

  • Built-In Electric Oven
  • Built-In Electric Range
  • Plumbed For Ice Maker
  • Dishwasher
  • Ceramic Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms
  • Tile Bathroom Countertop
  • Bathtub with Shower
  • Separate Shower
  • Window or Skylight in Bathroom

Laundry

  • Laundry Room
  • Laundry in Garage
  • Sink Near Laundry
  • Laundry Cabinets

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Covered Patio or Porch
  • Greenhouse
  • Outbuilding

Farming

  • Barn

Utilities

  • Heat Pump System
  • Radiant Heating System
  • Three-Phase Power
  • Well
  • Electric Water Heater
  • Septic System
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Greenbelt

Listing and Financial Details

  • Assessor Parcel Number 017-066-004-000

Property Details

Home Type

Multi-Family

Year Built

Built in 1960

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Subtype Description: Semi-Custom
  • Property Subtype 1: 2 Houses on Lot
  • Remodeled Updated: No
  • Stories: 1
  • Year Built: 1960
  • Architectural Style: Ranch
  • Special Features: None
  • Property Sub Type: MultiFamily

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
  • Fireplace Features: Brick, Insert
  • Fireplaces: 1
  • Flooring: Carpet, Laminate, Vinyl
  • Master Bathroom Features: Shower Stall(s), Tile, Radiant Heat, Window
  • Master Bedroom Features: Closet
  • Total Bathrooms: 2
  • Bathroom Features: Tile, Tub, Tub w/Shower Over, Window, Radiant Heat
  • Dining Room Features: Other
  • Kitchen Features: Pantry Cabinet, Ceramic Counter
  • Living Room Features: Other
  • Room Type: Master Bathroom, Master Bedroom, Dining Room, Family Room, Kitchen, Living Room
  • Main Level: Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
  • Price Per Square Foot: 2198.39
  • Square Footage: 1865.00
  • Window Features: Caulked/Sealed, Dual Pane Full

Exterior Features

  • Other Structures: Barn(s), Second Garage, Greenhouse, Outbuilding
  • Construction Materials: Brick, Ceiling Insulation, Concrete, Stucco, Floor Insulation, Wall Insulation, Glass
  • Property Faces: South
  • Fencing: Metal, Partial, Masonry
  • Foundation: Pillar/Post/Pier, Raised, Concrete
  • Frontage Type: Borders Government Land
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 4100000.00
  • Lot Features: Auto Sprinkler F&R, Greenbelt, Landscape Back, Landscape Front
  • New Construction: No
  • Patio And Porch Features: Front Porch, Covered Patio
  • Pool: No
  • Road Surface Type: Asphalt
  • Roof: Shingle, Fiberglass
  • Spa: No
  • Topography: Hillside,Hillside
  • View Description: Orchard, Panoramic, Park, Garden/Greenbelt, Mountains
  • Land Use: Agricultural, Farm, Orchard
  • Second Unit Kitchen: Yes

Garage/Parking

  • Garage Spaces: 3.00
  • Parking Features: 1/2 Car Space, Attached, Detached, Garage Facing Front
  • Driveway/Sidewalks: Paved Driveway

Utilities

  • Security: Carbon Mon Detector, Smoke Detector
  • Sewer: Septic System, Septic Connected
  • Utilities: Electric, Internet Available
  • Cooling: Ceiling Fan(s), Whole House Fan, Heat Pump
  • Electric: 3 Phase
  • Heating: Fireplace(s), Heat Pump
  • Laundry Features: Cabinets, Sink, Space For Frzr/Refr, In Garage
  • Water Source: Well

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Ceres Unified

Lot Info

  • Zoning: A240
  • Irrigation: Irrigation District
  • Lot Size Acres: 100.3200
  • Lot Size Sq Ft: 4369939.00

Multi Family

  • Unit 2 Partial Bathrooms: 0
  • Unit 2 Description: House, built approx 1960
  • Unit 2 Occupied: No
  • Unit 2 Type: Detached

Tax Info

  • Assessor Parcel Number: 017-066-004-000
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): Stanislaus

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $13,708 $1,128,739 $353,940 $774,799
2024 $13,119 $1,128,082 $347,000 $781,082
2023 $12,646 $1,094,109 $340,197 $753,912
2022 $12,291 $1,049,985 $333,527 $716,458
2021 $11,286 $950,345 $326,988 $623,357
2020 $10,960 $941,238 $323,636 $617,602
2019 $10,893 $922,791 $317,291 $605,500
2018 $10,680 $904,742 $311,070 $593,672
2017 $10,521 $887,113 $304,971 $582,142
2016 $9,987 $869,786 $298,992 $570,794
2015 $9,862 $856,758 $294,501 $562,257
2014 $9,662 $839,954 $288,733 $551,221
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/20/2025 10/20/25 For Sale $4,100,000 -- $2,198 / Sq Ft
Source: MetroList

Purchase History

Date Type Sale Price Title Company
Grant Deed -- None Available
Interfamily Deed Transfer -- Fidelity National Title Co
Interfamily Deed Transfer -- Fidelity National Title Co
Interfamily Deed Transfer -- Fidelity National Title Co
Interfamily Deed Transfer -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $831,500 Stand Alone Refi Refinance Of Original Loan
Source: Public Records

Source: MetroList

MLS Number: 225135201

MetroList

APN: 017-66-04