$3,800,000
SOLD FEB 26, 2026

3749 Shiloh Rd Modesto, CA 95358

3 Beds
2 Baths
1,865 Sq Ft
4,369,939 Sq Ft Lot

Recently Sold

$2,038 Per Sq Ft

7% Below List Price

84 Days on Market

Highlights

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

About This Home

As of February 2026

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.

Last Agent to Sell the Property

Lynn Garber

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

PMZ Commercial Real Estate

Co-Listed By

Kally Fulke

PMZ Commercial Real Estate License #01433242

Last Buyer's Agent

Greg Austin

PMZ Commercial Real Estate License #01951398

PMZ Commercial Real Estate

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

100.32 Acres

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: 2037.53
  • 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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 20, 2025
Closed on
Feb 20, 2026
Sold by
Stardust Farms
Bought by
Rivercrest Ranches Lp
Seller's Agent
Lynn Garber
PMZ Commercial Real Estate
Buyer's Agent
Greg Austin
PMZ Commercial Real Estate
List Price
$4,100,000
Sold Price
$3,800,000
Premium/Discount to List
-$300,000
-7.32%
Views
44

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
147.05%
Original Mortgage
$2,470,000
Outstanding Balance
$2,470,000
Interest Rate
6.06%
Mortgage Type
Credit Line Revolving
Estimated Equity
$1,541,904

Purchase Details

Closed on
Nov 20, 2014
Sold by
Taylor Marilyn M and Thompson Laura M
Bought by
Stardust Farms Llc

Purchase Details

Closed on
Nov 20, 2013
Sold by
Taylor Robert W
Bought by
Taylor Marilyn M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$831,500
Interest Rate
4.08%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Closed on
Jan 10, 2007
Sold by
Pappas James
Bought by
Pappas James
Source: Public Records

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

Purchase History

Date Type Sale Price Title Company
Grant Deed $3,800,000 Wfg National Title Insurance C
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
Open $2,470,000 Credit Line Revolving
Previous Owner $831,500 Stand Alone Refi Refinance Of Original Loan
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/26/2026 02/26/26 Sold $3,800,000 -7.3% $2,038 / Sq Ft
01/12/2026 01/12/26 Pending -- -- --
10/20/2025 10/20/25 For Sale $4,100,000 -- $2,198 / Sq Ft
Source: MetroList

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

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MetroList

MLS Number: 225135201

MetroList

APN: 017-66-04

Your Personal Tour Guide

Ask me questions while you tour the home.