This home is simply Gorgeous! Offering 4 Bedrooms, 2.5 Baths, Den/Study option. Custom interior two toned paint, tile floors and a Beautiful custom fireplace. Kitchen features Granite countertops with large Island and cabinets with pull-out sliding shelves. Family room offers a built in Entertainment Center. Home also offers a dual thermostat AC unit, Plantation shutters on both floors, a beautiful staircase that features custom wrought iron railing, a loft and can and accent lighting throughout. The Backyard is an Entertainer's dream. Custom built-in Pool and Spa, custom covered patio with lights and ceiling fan. Stamped concrete all the way around, making for the most immaculate backyard. Not to mention the beautiful landscaping. The court is located directly across from Ustach Park. This park offers a basketball court, grass area for picnicking or for puppy play, along with a play area for the kids. Also within walking distance of both a Middle and High School. Come and See!
Single-familyProperty Type
2004Year Built
5,271 sq ftLot Size
$224Est. Price/Sq.Ft.
2 car garageParking
Listed by Karen Johnson•DRE #01713982• Endurance Real Estate
Bought with Joyce Wagner•DRE #01158536• 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
Zoning
Permits
Beds
4
Baths
2.5
Stories
—
Lot width
—
Lot depth
—
Lot size
5,272 Sq. Ft.
Year renovated
—
Sq. Ft.
2,691
Year built
2004
Style
Single Family Residential
County
Stanislaus County
APN
077049039000
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.
Jul 3, 2025 • Final
Res hvac
HVAC
Nov 19, 2021 • Final
Res solar
Install a roof-mounted solar system with solar panels on a residential building.
Electrical
Solar
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: Garage Door Opener, Garage Facing Front