A must see Unique House overlooking the Tuolumne River on an approx. 6 acre lot!! Lots of concrete driveway completely fenced and gated estate, 60x40 Shop with 2 12ft rolling doors, Pick a deck and enjoy your own backyard river view or Front yard view of the mountains. Modern well was re-wired, and works great. 15min from DT Modesto, and 1hr from the Bay. Home needs work, AS-IS Sale!
Single-familyProperty Type
1978Year Built
5.97 acresLot Size
$222Est. Price/Sq.Ft.
2 car garageParking
Listed by Trisha Martinho•DRE #01458367• Atlantic Realty
Bought with Trisha Martinho•DRE #01458367• Atlantic Realty
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
5
Baths
3.5
Stories
—
Lot width
—
Lot depth
—
Lot size
5.97 Acres
Year renovated
—
Sq. Ft.
3,749
Year built
1978
Style
Vacant Land
County
Stanislaus County
APN
017027026000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
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
Feb 6, 2026 • Final
Residential reroof
Tear off and replace the roof on a residential building with composition shingles. Work includes resheathing and minor repairs as needed.
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: 2
Parking Features: Attached
Interior
Bathroom Information
# of Bathrooms (Full): 3
# of Bathrooms (Partial): 1
Other Bathroom Features: Tub w/Shower Over
Bedroom Information
# of Bedrooms (Total): 5
Heating & Cooling
Cooling: Window Unit(s)
Heating: See Remarks
Interior Features
Fireplaces Total: 1
Fireplace Features: Family Room
Flooring: See Remarks
Room Information
Room Type: Baths Other
Dining Room Features: Dining/Family Combo
Exterior
Exterior Features
Allows Horses: No
Roof: Composition
Pool Information
Has Private Pool: No
Has Spa: No
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Subtype Description: Detached
Year Built: 1,978
Lot Information
Lot Features: Lake/River Access
Lot Size Square Feet: 260,053
Lot Size Acres: 5.97
Lot Size Dimensions: see map
Utilities
Utility Information
Electric: 220 Volts, 220 Volts in Laundry
Sewer: Septic Connected
Irrigation Source: Agricultural Well
Location
HOA Information
Association YN: No
School Information
School District County: Stanislaus
Elementary School District: Modesto City
Middle Or Junior School District: Modesto City
High School District: Modesto City
Location Information
Postal Code Plus 4: 8233
Postal Code: 95358
County Or Parish: Stanislaus
CrossStreet: Grayson Rd
Directions: Crayson to Shiloh or Paradise Rd to Shiloh
State Or Province: CA
Street Number Numeric: 2848
Unparsed Address: 2848 Shiloh Rd, Modesto, CA 95358-8233
Street Address Filtered: 2848 Shiloh Rd
Community Information
Senior Community YN: No
Public facts
Beds: 5
Baths: 3.5
Sq. Ft.: 3,749
Stories: —
Lot Size: 5.97 acres
Style: Vacant Land
Year Built: 1978
Year Renovated: —
County: Stanislaus County
APN: 017027026000
Home facts updated by county records on Jul 13, 2026
Other
Selling Agent
Buyer Agent Full Name: Trisha M Martinho
Around this home
Schools
Places
Transit
Westport Elementary School
Public K-6 • Assigned • 6.2mi
3/10
Blaker-Kinser Junior High School
Public 7-8 • Assigned • 9.1mi
6/10
Central Valley High School
Public 9-12 • Assigned • 9.5mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
6/10 Flood Factor
Estimated 67-75% chance of a flood reaching the building in the next 30 years
3/10 Fire Factor
0.62% chance of being in a wildfire in next 30 years
7/10 Heat Factor
7 days above 102° expected this year, 16 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
27 unhealthy days expected this year, 29 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
$792,000 – $959,000
Sell confidently with a local market expert in Modesto. 3 minutes to get started.