Welcome to 509 Stewart Rd. Modesto, CA - a beautifully updated midcentury-style home featuring 3-4 bedrooms, 3-4 bathrooms, and 1,612 sq. ft. of living space on a 0.5-acre lot. The home boasts bamboo floors, an open beam ceiling in the living room, and remodeled kitchen and bathrooms with quartz countertops. The backyard is perfect for entertaining with a built-in gas grill, a solar-heated pool, and an updated pool house. Recent upgrades include a new HVAC unit, front door, well filter, and auxiliary pump for the pool. Located within walking distance of the prestigious Del Rio Country Club, this home offers an unparalleled lifestyle in a prime location. Don't miss the opportunity to own this exquisite midcentury gem that combines timeless elegance with modern amenities. Come see and fall in love with 509 Stewart Rd!
Single-familyProperty Type
1952Year Built
0.56 acresLot Size
$896Est. Price/Sq.Ft.
2 garage spacesParking
Listed by Randy Thomas•DRE #02114775• PMZ Real Estate
Listed by Daniel Del Real•DRE #01423976• PMZ Real Estate
Bought with Alex Walker•DRE #02228968• Craft & Bauer Real Estate Co.
*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
3
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
0.56 Acres
Year renovated
—
Sq. Ft.
1,612
Year built
1952
Style
Single Family Residential
County
Stanislaus County
APN
004085044000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 15, 2026.
Apr 26, 2018 • Final
Hvac
Replace the existing rooftop heating and air conditioning unit. No ductwork is included in the scope of work.
HVAC
Jan 13, 2014 • Final
Residential and commercial building
Perform fire damage repairs on a building.
Remodel
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: Covered, Detached, Garage Door Opener, Garage Facing Front, Guest Parking Available