Rare opportunity to own a property with incredible potential and river access! This home sits on just over a half-acre lot with river access, offering a peaceful natural setting. The property is one of three adjacent parcels currently for sale, with the main parcel connected to two additional vacant lots on either side providing a unique opportunity to expand, build additional structures (buyer to verify), or enjoy added space and privacy along the river. Whether you're looking for a private retreat, investment opportunity, or future development potential, this property offers a variety of possibilities. (See other related listings MLS#226028982 & MLS#226029063)
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built Details
Unknown
Year Built Source
Owner
Remodeled/Updated
Unknown
Stories
1
Levels
One
Home Warranty
No
Directions to Property
Use GPS
Cross Street
Mosher Ave
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Full Bath(s), Kitchen
Construction Materials
Concrete, Wood, Wood Siding
Foundation
Other
Roof
Composition
Heating
Ductless, Other
Cooling
Wall Unit(s), Ductless
Laundry Features
Other
Other Structures
Gazebo, Shed(s), Storage
Full Bathrooms
1
Bath Features
Shower Stall(s)
Flooring
Laminate, Vinyl
Kitchen Features
Kitchen/Family Combo
Dining Room Features
Other
Living Room Features
Other
Exterior Features
Built-In Barbeque
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Other
Electric
Other
Irrigation
None
Water Source
Public
Sewer
Other
Parking Features
No Garage
Open Parking Spaces
10.00
Lot Features
River Access
APN
017 033 017 000
Horse Property
No
Zoning Description
Rural Residential
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Census Tract
15.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '1' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 150 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 650 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1705571 OR `props-main`.`id` = 1713354 OR `props-main`.`id` = 1713218 OR `props-main`.`id` = 1715827 OR `props-main`.`id` = 1714913 OR `props-main`.`id` = 1714434 OR `props-main`.`id` = 1715950 OR `props-main`.`id` = 1715944 OR `props-main`.`id` = 1715720 OR `props-main`.`id` = 1715949 OR `props-main`.`id` = 1712896 OR `props-main`.`id` = 1714742 OR `props-main`.`id` = 1716273 OR `props-main`.`id` = 1705396 OR `props-main`.`id` = 1714357 OR `props-main`.`id` = 1715591 OR `props-main`.`id` = 1715604 OR `props-main`.`id` = 1713114 OR `props-main`.`id` = 1712686 OR `props-main`.`id` = 1716051 OR `props-main`.`id` = 1703092 OR `props-main`.`id` = 1714265)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226029040' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-16' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Andrew Moran, J.Peter Realtors IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
