Welcome to your new home, nestled at the end of a serene cul-de-sac with the prestigious Rancho Del Rey Golf Course at the end of the street. This beautiful residence offers a perfect blend of comfort, space, and convenience! As you step inside, you'll be greeted by a sense of grandeur with a separate formal dining area and living room, perfect for hosting gatherings or enjoying quiet evenings with loved ones. Adjacent to the main living area, discover an office space adorned with elegant columns, providing an ideal setting for work. The heart of the home awaits in the comfortable kitchen. Featuring a stainless steel farm-style sink, a spacious kitchen island, epoxy countertops with stylish tile backsplash, and state-of-the-art stainless-steel appliances, this kitchen is a chef's delight. Each bathroom boasts a shower over tub, ensuring both style and functionality meet seamlessly. For added convenience, an indoor laundry room with cabinets offers a dedicated space for chores. Step outside, where a covered patio awaits providing the perfect spot for outdoor dining or simply unwinding after a long day. The expansive brick slab extends into a spacious yard to accommodate your outdoor activities!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1999
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
Buhach rd, to green sands ave, to fairway dr, to Palmer pl
Cross Street
Fairway Dr
County
Merced
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco
Foundation
Slab
Roof
Composition
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central, Whole House Fan
Laundry Features
Inside Area, Inside Room
Full Bathrooms
2
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room, Family Room, Gas Piped, See Remarks
Flooring
Carpet, Laminate, Tile, Wood
Appliances
Dishwasher, Microwave
Kitchen Features
Island, Stone Counter, Synthetic Counter, Kitchen/Family Combo
Dining Room Features
Formal Area
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Solar
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Facing Front
Garage Spaces
2.00
Lot Features
Court
APN
004 302 008 000
Horse Property
No
Zoning Description
residential
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
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451395 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) >= 1303 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1803 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` = 144493 OR `props-main`.`id` = 1664241 OR `props-main`.`id` = 1692856 OR `props-main`.`id` = 1674850 OR `props-main`.`id` = 236633 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1692860 OR `props-main`.`id` = 1692862 OR `props-main`.`id` = 1691770 OR `props-main`.`id` = 1691774 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1690931 OR `props-main`.`id` = 1690155 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1696012 OR `props-main`.`id` = 1692028 OR `props-main`.`id` = 1692023 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1691572 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687248 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1687267 OR `props-main`.`id` = 1680386 OR `props-main`.`id` = 1680392 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1691764 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1692693 OR `props-main`.`id` = 1693100 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 1694839 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1693261 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1687293 OR `props-main`.`id` = 1687304 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1691911 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1695231 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1691488 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1694170 OR `props-main`.`id` = 1690040 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1694079 OR `props-main`.`id` = 1694546 OR `props-main`.`id` = 1695892 OR `props-main`.`id` = 1690886 OR `props-main`.`id` = 1691960 OR `props-main`.`id` = 1691872 OR `props-main`.`id` = 1691969 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1694815 OR `props-main`.`id` = 1696206 OR `props-main`.`id` = 1696201 OR `props-main`.`id` = 1695667 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1694068 OR `props-main`.`id` = 1690818 OR `props-main`.`id` = 1690813 OR `props-main`.`id` = 1690831 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1693304 OR `props-main`.`id` = 1694000 OR `props-main`.`id` = 1688816)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225138370' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-28' 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();
3
Similar Properties
$434,500
4
2
1,634
0.14
1384 W Almador Ter
Atwater, CA 95301
$429,000
4
2
1,375
0.14
717 Nicklaus Ct
Atwater, CA 95301
$419,000
4
2
1,791
0.16
116 Mulberry Ave
Atwater, CA 95301
Courtesy of Sonny Uppal, Lifestyle Realty 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.
