- 4 beds
- 3 baths
- 3,262 sqft
- 6,299 sqft lot
- $217 per sqft
- 2004 build
- – on site
Stunning Cul-de-Sac Home Located In The Very Sought- After Sylvan School District In The Crossroads Neighborhood! Welcome to this beautifully updated home tucked away on a quiet cul-de-sac offering comfort, style, and the ultimate backyard escape with a Pebble Tec pool & extensive upgrades! Step inside to fresh paint throughout (including the garage), new luxury vinyl plank flooring, and a bright, open floorplan designed for easy living. The chef's kitchen impresses with granite countertops, maple cabinetry, stainless steel appliances, new double ovens, a new dishwasher, new microwave, and a spacious island ideal for hosting. Downstairs also features tile flooring, a full bath, and a den perfect for guests or a home office. Upstairs, enjoy a large loft/media room with plenty of space to relax or play. Step out back to your private retreat featuring a refreshing pool with tranquil waterfalls. Recent upgrades include a new pool pump, new sand filter, and a new water heater, offering peace of mind and resort-style living at home. This is the one you've been waiting for!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jul 3, 2025
•
MLS# 225087772 —
The Building
-
Year Built:2004
-
Year Built Source:Assessor Auto-Fill
-
Remodeled Updated:No
-
Construction Materials:Stucco, Wood
-
Construction Materials:#Collection(String)
-
Building Features:#Collection(String)
-
Architectural Style:#Collection(String)
-
Development Status:#Collection(String)
-
Structure Type:#Collection(String)
-
Subtype Description:#Collection(String)
-
Roof:Tile
-
Roof:#Collection(String)
-
Foundation Details:Slab
-
Foundation Details:#Collection(String)
-
Stories:2
-
Levels:#Collection(String)
-
Upper Level:#Collection(String)
-
Main Level:#Collection(String)
-
Lower Level:#Collection(String)
-
Basement:#Collection(String)
-
Exterior Features:Dog Run
-
Exterior Features:#Collection(String)
-
Window Features:Dual Pane Full, Window Screens
-
Window Features:#Collection(String)
-
Patio And Porch Features:#Collection(String)
-
Accessibility Features:#Collection(String)
Interior
-
Interior Features:#Collection(String)
-
Kitchen Features:Breakfast Area, Pantry Cabinet, Granite Counter, Island w/Sink, Kitchen/Family Combo
-
Flooring:Tile, Vinyl
-
Flooring:#Collection(String)
-
Upper Level:Bedroom(s), Loft, Master Bedroom, Full Bath(s)
-
Main Level:Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Street Entrance
-
Dining Room Features:Breakfast Nook, Formal Room, Dining/Living Combo
-
Living Room Features:View
-
Family Room Features:Great Room
-
Fireplaces Total:1
-
Fireplace Features:Family Room, Gas Piped
-
Fireplace Features:#Collection(String)
-
Laundry Features:Cabinets, Sink, Electric, Inside Room
-
Laundry Features:#Collection(String)
Room Dimensions
-
Living Area:3262.0
-
Living Area Source:Assessor Auto-Fill
Financial & Terms
-
Lease Type:Net
-
Lease Type:#Collection(String)
-
Lease Info:#Collection(String)
-
Lease Includes:#Collection(String)
-
Rent Includes:#Collection(String)
-
Tenant Pays:#Collection(String)
-
Owner Pays:#Collection(String)
-
Pets Allowed:#Collection(String)
Location
-
Directions:From Squire Wells, to Bracco Way to Mayberry Ct.
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Condition:#Collection(String)
-
Parcel Number:075-087-031-000
-
Current Use:#Collection(String)
-
Possible Use:#Collection(String)
-
Zoning:R-1
-
Lot Features:Auto Sprinkler F&R, Cul-De-Sac, Landscape Back, Landscape Front, Low Maintenance
-
Lot Features:#Collection(String)
-
Lot Size Acres:0.1446
-
Lot Size Square Feet:6299.0
-
Lot Size Units:Acres
-
Lot Size Source:Assessor Auto-Fill
-
Land Lease:false
-
View:#Collection(String)
-
Vegetation:#Collection(String)
-
Irrigation Source:#Collection(String)
-
Fencing:Back Yard, Wood
-
Fencing:#Collection(String)
-
Horse:false
-
Horse Amenities:#Collection(String)
-
Crops:#Collection(String)
-
Soil:#Collection(String)
-
Land Use:#Collection(String)
-
Irrigation Source:Public District
-
Frontage Type:#Collection(String)
-
Road Surface Type:#Collection(String)
-
Road Frontage Type:#Collection(String)
-
Road Responsibility:#Collection(String)
-
Road Responsibility:Public Maintained Road
-
Driveway Sidewalks:#Collection(String)
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Bedrooms Total:4
-
Bedrooms Possible:5
-
Master Bedroom Features:Walk-In Closet
Baths
-
Total Baths:3
-
Full Baths:3
-
Master Bathroom Features:Shower Stall(s), Double Sinks, Sitting Area, Soaking Tub, Multiple Shower Heads, Window
The Listing
-
Home Warranty:false
Heating & Cooling
-
Heating:Central, Fireplace(s)
-
Heating:#Collection(String)
-
Cooling:Ceiling Fan(s), Central
-
Cooling:#Collection(String)
Utilities
-
Utilities:Cable Available, Public
-
Utilities:#Collection(String)
-
Electric:220 Volts
-
Electric:#Collection(String)
-
Sewer:In & Connected, Public Sewer
-
Sewer:#Collection(String)
-
Water Source:Meter on Site, Public
-
Water Source:#Collection(String)
-
Green Energy Efficient:#Collection(String)
Appliances
-
Appliances:Built-In Electric Oven, Built-In Gas Range, Gas Water Heater, Dishwasher, Disposal, Microwave, Double Oven, Plumbed For Ice Maker
-
Appliances:#Collection(String)
Schools
-
Elementary School District:Sylvan Union
-
Middle Or Junior School District:Sylvan Union
-
High School District:Modesto City
The Community
-
Community Features:#Collection(String)
-
Association:false
-
Association Amenities:#Collection(String)
-
Spa:false
-
Spa Features:#Collection(String)
-
Pool Private:true
-
Pool Features:Built-In, On Lot, Pool Sweep, See Remarks
-
Pool Features:#Collection(String)
-
Senior Community:false
Parking
-
Garage Spaces:3.0
-
Parking Type:#Collection(String)
-
Parking Access:#Collection(String)
-
Parking Features:Attached, Garage Door Opener
-
Parking Features:#Collection(String)
Extra Units
-
Unit 1 Type:#Collection(String)
-
Unit 2 Type:#Collection(String)
-
Unit 3 Type:#Collection(String)
-
Unit 4 Type:#Collection(String)
-
Other Units:#Collection(String)
Monthly cost estimate

Asking price
$709,999
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$3,801
|
Taxes | N/A |
Insurance | $195 |
Utilities | $276 See report |
Total | $4,272/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
7/2/25
Jul 2, 2025
|
Listed / Active | METROLIST | $709,999 |