This is History in the making when you move your family to this GORGEOUS 4bd/2.5ba newer build!Enjoy the perks of a newer build home with all the amazing landscaping, upgrades, finishing touches and love done for you!An entertainer's paradise with an open concept living space that opens up seamlessly to an opulent oasis. You'll be the talk of the town with your Saltwater Sports Pool with large Rockfall and six small waterfalls, convenient outdoor kitchen, breezy lanai with twist down sunshade, lush artificial turf to lounge and catch some rays, rock space area perfect for a fire pit for those fall evenings. This spacious backyard has something for everyone. A gated dog run on the side w/ shed Bring the party inside w/ int & ext surround sound wiring!You'll want for nothing in this show stoppingly beautiful interior. Too many upgrades to list! If History has shown us anything, these once in a lifetime opportunities don't stick around long!
Single-familyProperty Type
2017Year Built
5,205 sq ftLot Size
$308Est. Price/Sq.Ft.
2 car garageParking
Listed by • Side, Inc.
•415-525-4913 (broker)
Bought with Olufemi Oyenuga•DRE #DRE #01033377• Intero Real Estate Services
*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
Zoning
Permits
Beds
4
Baths
2.5
Stories
—
Lot width
—
Lot depth
—
Lot size
5,205 Sq. Ft.
Year renovated
—
Sq. Ft.
1,974
Year built
2017
Style
Single Family Residential
County
Stanislaus County
APN
082026054000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
SP
Specific Plan Zone
Specific plans are established to enable land to be planned and developed as coordinated, comprehensive projects providing for systematic implementation of the General Plan, and provide a means to plan for specific areas, providing land use pattern, development standards, design guidelines, and development processes for these areas. The Purpose and Intent of the SP Zone is to permit various land uses including residential, industrial, and commercial development through Specific Plans, pursuant to Government Code Section 65450, et seq. The intent of this is to implement policies regarding certain uses, standards, and development review processes adopted through the Specific Plan process.
Jun 25, 2018 • Final
Res pool
Pool and hot tub
Sep 1, 2017 • Final
New sfd
New construction
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
Garage Information
Has Garage
# of Garage Spaces: 2
Parking Information
# of Covered Spaces: 2
Interior
Bedrooms Information
# of Bedrooms: 4
Bathroom Information
Count of Bathrooms: 3
# of Full Bathrooms: 2
# of Half Bathrooms: 1
Interior Features
Laundry Features: Inside Room, Upper Level
Has Heating
Heating: Central
Has Cooling
Cooling: Ceiling Fan(s), Central Air
Flooring: Carpet, Tile
Has Fireplace(s)
# of Fireplaces Total: 1
Fireplace Features: Family Room, Gas
Appliances: Tankless Water Heater
Exterior
Exterior Features
Exterior Features: Outdoor Kitchen
Entry Level: 0
Building Information
Living Area: 1974
Living Area Units: Square Feet
Living Area Source: Assessor Auto-Fill
Building Area Total: 1974
Building Area Units: Square Feet
Building Area Source: Assessor Auto-Fill
Construction Materials: Brick, Stucco, Wood
Year Built: 2017
Remodeled/Updated Description: Other-Rmks 0-5YR
Roof: Tile
Foundation Details: Slab
Mobile Home Information
Mobile Dim Units: Feet
Pool Information
Pool Features: In Ground, On Lot
Property Type
Property Type: Residential
Property SubType: Single Family Residence
Property Information
Property Condition: Updated/Remodeled
Other Equipment: Audio/Video Prewired
Land Information
Irrigation Source: None
Lot Information
Lot Features: Shape Regular
Lot Size Sq. Ft.: 5205.42
Lot Size Acres: 0.1195
Lot Size Area: 5205.42
Lot Size Units: Acres
Lot Size Units: Square Feet
Elevation: 0
Elevation Units: Feet
Road Responsibility: Public Maintained Road
Road Surface Type: Sidewalk/Curb/Gutter
Zoning: Residential
Utilities
Utility Information
Sewer: In & Connected
Water Source: Public
Location
HOA Information
Association Fee: 0
School Information
Elementary School District: Sylvan Union
Middle Or Junior School District: Sylvan Union
High School District: Modesto City
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 1,974
Stories: —
Lot Size: 5,205 square feet
Style: Single Family Residential
Year Built: 2017
Year Renovated: —
County: Stanislaus County
APN: 082026054000
Home facts updated by county records on Jul 13, 2026
Around this home
Schools
Stockard Coffee Elementary School
Public K-5 • Assigned • 0.4mi
5/10
Elizabeth Ustach Middle School
Public 6-8 • Assigned • 1.3mi
7/10
Fred C. Beyer High School
Public 9-12 • Assigned • 0.7mi
6/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.15% chance of being in a wildfire in next 30 years
7/10 Heat Factor
7 days above 102° expected this year, 16 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 • 95357
Average low and high temperatures (°F)
59
40
64
44
72
48
74
49
83
55
91
59
90
61
93
64
89
63
79
56
63
47
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13.2 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.
13.2 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$579,000 – $701,000
Reach more buyers when you sell with Redfin. Save up to $6,088 in fees.3 minutes to get started.