Nestled along the serene riverfront, this home offers a picturesque retreat with enchanting outdoor amenities and modern updates throughout. Step into the updated kitchen, where modern elegance meets functionality, perfect for culinary enthusiasts. The lush garden surrounds the property, adorned with cascading waterfalls that create a tranquil ambiance. Breathtaking views can be savored from every corner of the home, allowing you to immerse yourself in the beauty of nature all complemented by a cozy fireplace in the family room. Relax on the deck off the primary suite, listening to the gentle sounds of the river. The full basement adds to the home's allure, featuring a workout room, laundry, a full kitchen, bedroom, and bathroom. Additionally, indulge in the ultimate media and game room, complete with a secondary fireplace and direct access to the river. Outside, finds additional paver parking, a greenhouse for gardening enthusiasts, and a charming swingset, making this property a true haven for outdoor lovers. Experience the ultimate riverside lifestyle in this captivating retreat.
Single-familyProperty Type
1963Year Built
0.34 acresLot Size
$238Est. Price/Sq.Ft.
2 garage spacesParking
Listed by Jamie MacDonald•DRE #02070891• PMZ Real Estate
Listed by Jeannie A. MacDonald•DRE #01177273• PMZ Real Estate
*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
Permits
Beds
4
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
0.34 Acres
Year renovated
—
Sq. Ft.
3,057
Year built
1963
Style
Single Family Residential
County
Stanislaus County
APN
039007001000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
Jul 27, 2012 • Final
Residential and commercial building
Replace the furnace in the attic of a residential building.
HVAC
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, Deck, Garage Facing Front
Dining Room Features: Dining Bar, Dining/Living Combo
Basement: Full
Main Level: Bedroom(s), Living Room, Master Bedroom, Full Bath(s), Garage, Retreat, Kitchen
Lower Level: Bedroom(s), Family Room, Full Bath(s), Retreat
Exterior
Exterior Features
Exterior Features: BBQ Built-In, Entry Gate
Fencing: Fenced, Wood, Front Yard
Allows Horses: No
Roof: Tile
Pool Information
Has Private Pool: No
Has Spa: No
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Subtype Description: Detached
Property Condition: Updated/Remodeled
Year Built: 1,963
Land Information
Land Use: Residential
Lot Information
Lot Features: Auto Sprinkler F&R, River Access, Garden, Shape Regular, Landscape Front
Lot Size Square Feet: 15,002
Lot Size Acres: 0.3444
Other Structures: Pergola, Gazebo, Greenhouse
Utilities
Utility Information
Utilities: Cable Connected, Dish Antenna
Electric: 220 Volts
Sewer: Septic System
Irrigation Source: None
Water Source: Well, Private
Location
HOA Information
Association YN: No
School Information
School District County: Stanislaus
Elementary School District: Ceres Unified
Middle Or Junior School District: Ceres Unified
High School District: Ceres Unified
Location Information
Postal Code Plus 4: 4524
Postal Code: 95351
County Or Parish: Stanislaus
CrossStreet: Mitchell Road
Directions: Scenic Dr South to El Vista Ave, continue on Mitchell Rd, turn on River Rd just past the bridge or Hatch Road to Central north to River Road, turn left just around the curve on the river side.
State Or Province: CA
Street Number Numeric: 2523
Unparsed Address: 2523 River Rd, Modesto, CA 95351-4524
Street Address Filtered: 2523 River Rd
Community Information
Senior Community YN: No
Public facts
Beds: 4
Baths: 3.0
Sq. Ft.: 3,057
Stories: 1.0
Lot Size: 0.34 acres
Style: Single Family Residential
Year Built: 1963
Year Renovated: —
County: Stanislaus County
APN: 039007001000
Home facts updated by county records on Jul 13, 2026
Other
Selling Agent
Buyer Agent Full Name: Non-MLS Member
Around this home
Schools
Virginia Parks Elementary School
Public K-6 • Assigned • 0.3mi
6/10
Mae Hensley Junior High School
Public 7-8 • Assigned • 1.1mi
4/10
Ceres High School
Public 9-12 • Assigned • 1.6mi
6/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
3/10 Flood Factor
Estimated 10-14% chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
6/10 Heat Factor
5 days above 102° expected this year, 10 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
34 unhealthy days expected this year, 37 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95351
Average low and high temperatures (°F)
59
40
64
45
72
49
75
50
83
56
91
60
91
61
94
65
90
63
80
57
64
48
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13 hours in
June and 4.5 hours in December, placing it above the
U.S. average for solar exposure.
13 hrs
4.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$690,000 – $836,000
Reach more buyers when you sell with Redfin. Save up to $7,263 in fees.3 minutes to get started.