Welcome home to this charming residence nestled on a quiet court in the heart of Atwater. Situated on an oversized lot, this property offers an expansive side yard with ample space for RV parking, boat storage, or additional recreational vehiclesa rare and desirable feature. Step inside to an inviting open-concept floor plan designed for comfortable everyday living and effortless entertaining. The spacious kitchen offers abundant cabinetry, generous counter space, and seamlessly overlooks the family room and dining area, creating the perfect gathering place for family and friends. The well-designed layout features generously sized secondary bedrooms that share a conveniently located hall bathroom with a shower-over-tub combination. Retreat to the spacious primary suite, complete with a private ensuite bathroom featuring a large walk-in shower and single-sink vanity. With its functional floor plan, exceptional storage potential, and desirable court location, this home offers the perfect blend of comfort and convenience. Don't miss your opportunity to make this wonderful Atwater property your next homeschedule your private showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1993
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
North on Fairway Dr, Right on Summerfield Left on Brentwood Ct
Cross Street
Summerfield Dr
County
Merced
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Frame, Wood
Foundation
Slab
Roof
Tile, Other
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Area
Full Bathrooms
2
Bath Features
Tile, Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Other
Flooring
Carpet, Tile
Appliances
Hood Over Range, Dishwasher, Disposal, Free Standing Electric Range
Kitchen Features
Tile Counter
Dining Room Features
Dining/Family Combo
Living Room Features
Great Room
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts
Irrigation
None
Water Source
Meter on Site
Sewer
Other
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Auto Sprinkler Front
APN
004 191 015 000
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Atwater Elementary
Middle or Junior School District
Atwater Elementary
Senior High School District
Merced Union High
Census Tract
8.02
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 365750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 404250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1039 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1539 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` = 1078072 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1750486 OR `props-main`.`id` = 1730748 OR `props-main`.`id` = 1730840 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1717756 OR `props-main`.`id` = 1717748 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1749152 OR `props-main`.`id` = 1754407 OR `props-main`.`id` = 1727719 OR `props-main`.`id` = 1728599 OR `props-main`.`id` = 1728309 OR `props-main`.`id` = 1738219 OR `props-main`.`id` = 1720310 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1723863 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1752508 OR `props-main`.`id` = 1723150 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1740557 OR `props-main`.`id` = 1754746 OR `props-main`.`id` = 1755088 OR `props-main`.`id` = 1731188 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1723302 OR `props-main`.`id` = 1721065 OR `props-main`.`id` = 1723280 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1753457 OR `props-main`.`id` = 1723294 OR `props-main`.`id` = 1724484 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1723293 OR `props-main`.`id` = 1743898 OR `props-main`.`id` = 1742833 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1752153 OR `props-main`.`id` = 1755857 OR `props-main`.`id` = 1744330 OR `props-main`.`id` = 1723297 OR `props-main`.`id` = 1740956 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1727284 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1740984 OR `props-main`.`id` = 1725250 OR `props-main`.`id` = 1724879 OR `props-main`.`id` = 1746086 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1726183 OR `props-main`.`id` = 1732098 OR `props-main`.`id` = 1728911 OR `props-main`.`id` = 1732524 OR `props-main`.`id` = 1742756 OR `props-main`.`id` = 1742406 OR `props-main`.`id` = 1732735 OR `props-main`.`id` = 1739111 OR `props-main`.`id` = 1754328 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1740651 OR `props-main`.`id` = 1739301 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1750422 OR `props-main`.`id` = 1737170 OR `props-main`.`id` = 1749651 OR `props-main`.`id` = 1754280 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 1746267 OR `props-main`.`id` = 1746248 OR `props-main`.`id` = 1746258 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1694847)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226097009' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-31' 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 Bethany Mendoza, 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.
