WOW! Commuters dream 5 minutes from the freeway. This Stunning home presents three-bedrooms at ground level with a spacious upstairs loft for a possible fourth bedroom or game room. The kitchen showcases elegant granite countertops, gas range, double oven and butler's pantry, offering a luxurious space for culinary adventures. This home is perfect for an entertainment, large formal dining room, living room and family room complete with built-in surround sound with great acoustics inside and outside. New HVAC and New Dishwasher. Sitting on a over sized lot this resort-style backyard boast a serene oasis, including a charming tiki hut and a BBQ island complete with rotisserie on grill, refrigerator and sink ideal for relaxation and entertaining guests. A magnificent pool constructed with authentic rocks sourced from Yosemite features a double waterfall coming off the pool and spa cascades beautifully over the rocks this adds a touch of nature's grandeur to this spectacular outdoor retreat. The backyard also offers a peaceful garden with Atlas cedar, multiple fruit trees, and raised garden box. This backyard has it all! The home has many amenities too many to mention. This home blends comfort and style, creating an ideal space for both everyday living and special gatherings.This is a must see! Come and make this house your home!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2003
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
1
Levels
One
Home Warranty
No
Directions to Property
Snyder, Madison Point, Dayton
Cross Street
Madison Pointe
County
Stanislaus
Special Listing Conditions
Other
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Wood
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central, Other
Laundry Features
Gas Hook-Up, Hookups Only, Inside Area, Inside Room
Window Features
Dual Pane Full
Property Faces
South
Other Structures
Pergola, Gazebo, Shed(s), Storage
Full Bathrooms
3
Bath Features
Double Sinks, Tub w/Shower Over
Possible Bedrooms
4
# of Fireplaces
1
Fireplace Features
Brick, Stone, Wood Burning
Flooring
Carpet, Laminate, Tile, Wood
Appliances
Built-In Electric Oven, Built-In Electric Range, Gas Cook Top, Gas Water Heater, Dishwasher, Disposal, Microwave, Double Oven, Plumbed For Ice Maker
Kitchen Features
Butlers Pantry, Granite Counter, Island, Kitchen/Family Combo
Dining Room Features
Dining/Family Combo, Space in Kitchen
Living Room Features
Cathedral/Vaulted
Primary Bedroom Features
Surround Sound, Walk-In Closet
Primary Bathroom Features
Shower Stall(s), Double Sinks, Soaking Tub
Exterior Features
Kitchen, Built-In Barbeque
Pool
Yes
Pool Features
Built-In, Pool/Spa Combo, Fenced, Gunite Construction
Spa
Yes
Spa Features
Spa/Hot Tub Built-In, Spa/Hot Tub Personal
ADU/2nd Unit
No
Utilities
Public, Sewer In & Connected
Electric
220 Volts in Kitchen,220 Volts in Laundry
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Energy Efficient
Cooling, Thermostat, Water Heater
Parking Features
Attached, Garage Door Opener, Garage Facing Front
Garage Spaces
3.00
Lot Features
Auto Sprinkler F&R, Cul-De-Sac, Garden, Landscape Back, Landscape Front
APN
046 024 032 000
Horse Property
No
Zoning Description
R-1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Census Tract
5.11
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 688750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 761250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2487 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2987 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1719243 OR `props-main`.`id` = 1721174 OR `props-main`.`id` = 1721607 OR `props-main`.`id` = 1709443 OR `props-main`.`id` = 1722961 OR `props-main`.`id` = 1722841 OR `props-main`.`id` = 1720612 OR `props-main`.`id` = 1721846 OR `props-main`.`id` = 1713186 OR `props-main`.`id` = 1722324 OR `props-main`.`id` = 1721152 OR `props-main`.`id` = 1625562 OR `props-main`.`id` = 1718559 OR `props-main`.`id` = 1714779 OR `props-main`.`id` = 1722985 OR `props-main`.`id` = 1721041 OR `props-main`.`id` = 1714740 OR `props-main`.`id` = 1714244 OR `props-main`.`id` = 1717161 OR `props-main`.`id` = 1722286 OR `props-main`.`id` = 1712775 OR `props-main`.`id` = 1723553 OR `props-main`.`id` = 1702731 OR `props-main`.`id` = 1721714 OR `props-main`.`id` = 1717568 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1716594 OR `props-main`.`id` = 1718072 OR `props-main`.`id` = 1716436 OR `props-main`.`id` = 1694263 OR `props-main`.`id` = 1720866 OR `props-main`.`id` = 1694971 OR `props-main`.`id` = 1722600 OR `props-main`.`id` = 1718538 OR `props-main`.`id` = 1717181 OR `props-main`.`id` = 1717240 OR `props-main`.`id` = 1722602 OR `props-main`.`id` = 1711297 OR `props-main`.`id` = 1707055 OR `props-main`.`id` = 1721491 OR `props-main`.`id` = 1717558 OR `props-main`.`id` = 1721716 OR `props-main`.`id` = 1715828 OR `props-main`.`id` = 1719287 OR `props-main`.`id` = 1722038 OR `props-main`.`id` = 1719261 OR `props-main`.`id` = 1694633 OR `props-main`.`id` = 1718681 OR `props-main`.`id` = 1712575 OR `props-main`.`id` = 1720798 OR `props-main`.`id` = 1722393 OR `props-main`.`id` = 1715807 OR `props-main`.`id` = 1719267 OR `props-main`.`id` = 1716483 OR `props-main`.`id` = 1722201 OR `props-main`.`id` = 1716442 OR `props-main`.`id` = 1723601 OR `props-main`.`id` = 1709712 OR `props-main`.`id` = 1720300 OR `props-main`.`id` = 1715829 OR `props-main`.`id` = 1716275 OR `props-main`.`id` = 1723521 OR `props-main`.`id` = 1720664 OR `props-main`.`id` = 1716418 OR `props-main`.`id` = 1716203 OR `props-main`.`id` = 1712487 OR `props-main`.`id` = 1720850 OR `props-main`.`id` = 1704269 OR `props-main`.`id` = 1694579 OR `props-main`.`id` = 1694304 OR `props-main`.`id` = 1721749 OR `props-main`.`id` = 1719090 OR `props-main`.`id` = 1713231 OR `props-main`.`id` = 1721580 OR `props-main`.`id` = 1723229)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226049182' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-24' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Donna Haug, Weeks Real Estate IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
