Welcome home to 600 Atherton Court in the prestigious community of Del Rio located in Modesto, CA. Located just moments from Del Rio's clubhouse, Atherton Court offers style, class and elegance that one may be looking to find. The main home offers 3235 square feet of living space with 3 bedrooms and 2.5 baths. Atherton Court underwent renovations in 2014 with the kitchen, bathrooms and floorings being upgraded. Upon entering Atherton Court, you will fall in love with the expansive living and dining room that flows into the outdoor living space with large windows and doors enhancing your experience with natural light. The kitchen offers beautiful cabinetry and countertops with wonderful appliances and a matching breakfast table which flows into the family room. One will be amazed as the outdoors comes in with the oversized windows. The opposite side of the home offers 3 bedrooms including a large primary suite with fireplace. A Bose whole home sound system brings the home to life and the outdoor patio area can become a screened in patio with the touch of a button. Speaking of outside, the grounds are landscaped beautifully with great fountains, pergola and more. The 490 Square foot Villa caps off this great property with kitchenette, sitting room, and a primary suite. Come and fall in love with Atherton Court.
Insert, Primary Bedroom, Family Room, Gas Log, Other
Flooring
Carpet, Stone, Tile, Wood
Appliances
Built-In Electric Oven, Built-In Electric Range, Gas Water Heater, Built-In Refrigerator, Dishwasher, Disposal, Microwave, Plumbed For Ice Maker, Electric Cook Top
Room Type
Office, Dining Room, Family Room, Kitchen, Laundry, Living Room
Kitchen Features
Breakfast Area, Pantry Cabinet, Pantry Closet, Granite Counter, Island, Stone Counter, Kitchen/Family Combo
Cable Available, Public, Electric, Internet Available, Natural Gas Connected, See Remarks
Electric
220 Volts,220 Volts in Kitchen,220 Volts in Laundry
Irrigation
None
Water Source
Public, Meter on Site
Sewer
See Remarks
2nd Unit Approx SqFt
490
2nd Unit SqFt Source
Appraiser
Parking Features
Attached, Garage Door Opener, Garage Facing Front
Garage Spaces
3.00
Open Parking Spaces
4.00
Lot Features
Auto Sprinkler F&R, Cul-De-Sac, Curb(s)/Gutter(s), Shape Irregular, Landscape Back, Landscape Front
APN
004 086 028 000
Land Use
Residential
Topography
Level
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Fencing
Back Yard, Wood, Masonry
Horse Property
No
Road Surface Type
Asphalt
Road Responsibility
Public Maintained Road
Zoning Description
R1
Subdivision
Del Rio Country Estates 02
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Stanislaus Union
Middle or Junior School District
Stanislaus Union
Senior High School District
Modesto City
Census Tract
5.01
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1567405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1732395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2985 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3485 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` = 1710768 OR `props-main`.`id` = 1710649 OR `props-main`.`id` = 1676264 OR `props-main`.`id` = 1691237 OR `props-main`.`id` = 1690230)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226012996' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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 Joshua Reeve, PMZ 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.
