SELLER WILL CONSIDER UP TO $30,000 CREDIT TOWARD UPDATES! This property is just walking minutes from Del Rio Country Club. Over a half an acre with an inviting pool/spa, 4 car garage with drive through access to the boathouse/extra garage, outdoor swim room/bathroom, lovely gazebo, and flourishing fruit trees/garden, this property is beautiful. The 4700+ sf home features a gourmet granite kitchen, master suite with covered veranda, a finished basement and much more.
Single-familyProperty Type
1991Year Built
0.54 acresLot Size
$310Est. Price/Sq.Ft.
4 car garageParking
Listed by Angela Watson•DRE #02010115• PMZ Real Estate
Listed by Robin Popolizio•DRE #01943091• PMZ Real Estate
Bought with Erin Nussbaumer•DRE #01929045• RE/MAX Executive
*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
5
Baths
3
Stories
2
Lot width
—
Lot depth
—
Lot size
0.54 Acres
Year renovated
—
Sq. Ft.
4,738
Year built
1991
Style
Single Family Residential
County
Stanislaus County
APN
004004081000
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 an HVAC split system at a residential building. The system includes a 95% AFUE and 16 SEER rating.
HVAC
Jul 27, 2012 • Final
Residential and commercial building
Install electrical components and cover an existing balcony and patio.
Electrical
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: 4
Parking Features: Attached, Drive Thru Garage, Garage Door Opener
Driveway Sidewalks: Sidewalk/Curb/Gutter
Interior
Bathroom Information
# of Bathrooms (Full): 3
# of Bathrooms (Partial): 2
Other Bathroom Features: Double Sinks, Jetted Tub, Shower Stall(s), Tub
Bedroom Information
# of Bedrooms (Total): 6
Heating & Cooling
Cooling: Ceiling Fan(s), Central
Heating: Central
Interior Features
Appliances: Gas Water Heater
Fireplaces Total: 1
Fireplace Features: See Remarks
Flooring: Carpet, Tile, Wood
Laundry Features: Cabinets, Inside Room, Sink
Patio And Porch Features: Back Porch, Covered Deck
Window Features: Dual Pane Full
# of Stories: 2
Room Information
Room Type: Baths Other
Dining Room Features: Dining Bar, Dining/Living Combo, Formal Room
Main Level: Bedroom(s), Full Bath(s)
Exterior
Exterior Features
Exterior Features: Balcony
Allows Horses: No
Roof: Tile
Pool Information
Pool Features: Built-In, Gunite Construction, On Lot, Pool/Spa Combo, Heated
Has Private Pool: Yes
Has Spa: Yes
Spa Features: Spa/Hot Tub Built-In
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Subtype Description: Detached, Custom
Property Condition: Updated/Remodeled
Year Built: 1,991
Lot Information
Lot Features: Close to Clubhouse
Lot Size Square Feet: 23,522
Lot Size Acres: 0.54
Other Structures: Gazebo, Outbuilding, Workshop
Utilities
Utility Information
Utilities: Cable Connected, Natural Gas Connected
Electric: 220 Volts, 220 Volts in Laundry
Sewer: Septic Connected
Irrigation Source: Meter on Site
Water Source: Public
Location
HOA Information
Association YN: No
School Information
School District County: Stanislaus
Elementary School District: Stanislaus Union
Middle Or Junior School District: Stanislaus Union
High School District: Modesto City
Location Information
Postal Code Plus 4: 8843
Postal Code: 95356
County Or Parish: Stanislaus
CrossStreet: St. John
Directions: St John to Stewart or McHenry to Stewart.
State Or Province: CA
Street Number Numeric: 512
Unparsed Address: 512 Stewart Rd, Modesto, CA 95356-8843
Street Address Filtered: 512 Stewart Rd
Community Information
Senior Community YN: No
Public facts
Beds: 5
Baths: 3.0
Sq. Ft.: 4,738
Stories: 2.0
Lot Size: 0.54 acres
Style: Single Family Residential
Year Built: 1991
Year Renovated: —
County: Stanislaus County
APN: 004004081000
Home facts updated by county records on Jul 13, 2026
Other
Selling Agent
Buyer Agent Full Name: Erin C Nussbaumer
Around this home
Schools
Stanislaus Elementary School
Public K-6 • Assigned • 2.5mi
6/10
Prescott Junior High School
Public 7-8 • Assigned • 4.4mi
4/10
Joseph A. Gregori High School
Public 9-12 • Assigned • 3.6mi
7/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
3/10 Fire Factor
0.31% chance of being in a wildfire in next 30 years
6/10 Heat Factor
7 days above 102° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
28 unhealthy days expected this year, 32 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95356
Average low and high temperatures (°F)
59
39
64
44
72
48
74
49
83
54
89
58
91
59
94
62
89
61
79
55
64
47
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.6 hours in December, placing it above the
U.S. average for solar exposure.
13 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.40M – $1.69M
Reach more buyers when you sell with Redfin. Save up to $14,711 in fees.3 minutes to get started.