Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/225134970/1351-River-Rd/Modesto/https://www.londonproperties.com/images/props/metrolist/full/225134970.jpgLondon Properties Modesto Real Estate | 1351 River Rd
Nestled along the serene Tuolumne River, this breathtaking custom-built Santa Fe-style home offers unparalleled beauty and tranquility, with panoramic views of the river and surrounding natural landscapes. Designed to blend seamlessly with its surroundings, this exquisite property combines the rustic elegance of Southwestern architecture with modern luxury. Upon entering, you are greeted with high ceilings with exposed wooden beams, a beautifully remodeled kitchen including quartz countertops, and breathtaking views overlooking the river. The primary bedroom offers an oasis of calm with its own private wooden fireplace and oversized walk in closet. Custom high end restrooms, beautiful landscaping including a one of a kind fire pit, and a possible in law studio make this unique riverfront property the perfect blend of elegance, comfort, and nature. Don't miss this opportunity to own a piece of paradise along the river. Schedule your private tour today and step into the home of your dreams.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
Updated/Remodeled
Year Built
1941
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 0-5YR, Bed 0-5YR, Other-Rmks 0-5YR
Stories
2
Home Warranty
No
Other Equipment
Water Cond Equipment Owned, Water Filter System
Directions to Property
Herndon to River Road.
Cross Street
Herndon Rd
County
Stanislaus
Special Listing Conditions
None
Lower Level
Primary Bedroom, Full Bath(s), Garage
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Kitchen
Construction Materials
Brick, Stucco, Wood
Foundation
Raised, Slab
Roof
Tile
Heating
Central
Cooling
Central
Laundry Features
Inside Room
Window Features
Dual Pane Full
Other Structures
Storage
Full Bathrooms
2
Bath Features
Shower Stall(s), Stone, Window
# of Fireplaces
2
Fireplace Features
Primary Bedroom, Family Room, Wood Burning
Flooring
Concrete, Tile, Wood
Appliances
Hood Over Range, Dishwasher, Disposal, Double Oven, Free Standing Electric Range
Room Type
Attic, Bonus Room, Office, Possible Guest, Storage, Studio, In Law Apartment
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 603249.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 666748.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2106 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2606 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` = 1692702 OR `props-main`.`id` = 1674469 OR `props-main`.`id` = 1697462 OR `props-main`.`id` = 1694808 OR `props-main`.`id` = 1693039 OR `props-main`.`id` = 1693040 OR `props-main`.`id` = 1693038 OR `props-main`.`id` = 1671906 OR `props-main`.`id` = 1693351 OR `props-main`.`id` = 1687815 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1691482 OR `props-main`.`id` = 1692784 OR `props-main`.`id` = 1692885 OR `props-main`.`id` = 1692883 OR `props-main`.`id` = 1692884 OR `props-main`.`id` = 1697511 OR `props-main`.`id` = 1697587 OR `props-main`.`id` = 1691126 OR `props-main`.`id` = 1694913 OR `props-main`.`id` = 1697866 OR `props-main`.`id` = 1693259 OR `props-main`.`id` = 1695662 OR `props-main`.`id` = 1646283 OR `props-main`.`id` = 1693548 OR `props-main`.`id` = 1692829 OR `props-main`.`id` = 1697403 OR `props-main`.`id` = 1693117 OR `props-main`.`id` = 1695820 OR `props-main`.`id` = 1694984 OR `props-main`.`id` = 1692805 OR `props-main`.`id` = 1695522 OR `props-main`.`id` = 1691502 OR `props-main`.`id` = 1695067 OR `props-main`.`id` = 1694773 OR `props-main`.`id` = 1696909 OR `props-main`.`id` = 1691641 OR `props-main`.`id` = 1690659 OR `props-main`.`id` = 1694588 OR `props-main`.`id` = 1693181 OR `props-main`.`id` = 1697287 OR `props-main`.`id` = 1692804 OR `props-main`.`id` = 1683622 OR `props-main`.`id` = 1697509 OR `props-main`.`id` = 1697619 OR `props-main`.`id` = 1697625 OR `props-main`.`id` = 1693377 OR `props-main`.`id` = 1697638 OR `props-main`.`id` = 1692908 OR `props-main`.`id` = 1693344 OR `props-main`.`id` = 1677808 OR `props-main`.`id` = 1693084 OR `props-main`.`id` = 1693086 OR `props-main`.`id` = 1692870 OR `props-main`.`id` = 1694981 OR `props-main`.`id` = 1692607 OR `props-main`.`id` = 1692292 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1695853 OR `props-main`.`id` = 1693123 OR `props-main`.`id` = 1692857 OR `props-main`.`id` = 1695671 OR `props-main`.`id` = 1673314 OR `props-main`.`id` = 1673305 OR `props-main`.`id` = 1693667 OR `props-main`.`id` = 1688054 OR `props-main`.`id` = 1668130 OR `props-main`.`id` = 1695198 OR `props-main`.`id` = 1695700 OR `props-main`.`id` = 1695688 OR `props-main`.`id` = 1693387 OR `props-main`.`id` = 1680781 OR `props-main`.`id` = 1696210 OR `props-main`.`id` = 1690812 OR `props-main`.`id` = 1646613 OR `props-main`.`id` = 1691773 OR `props-main`.`id` = 1697766 OR `props-main`.`id` = 1697393 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1697495 OR `props-main`.`id` = 1673085 OR `props-main`.`id` = 1697572 OR `props-main`.`id` = 1697501 OR `props-main`.`id` = 1693703)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225134970' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-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();
1
Similar Properties
$635,000
4
2
2,174
0.35
1305 River Rd
Modesto, CA 95351
Courtesy of Daniel Rodriguez, HomeSmart PV & Associates 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.
