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
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 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` = 1702364 OR `props-main`.`id` = 144493 OR `props-main`.`id` = 1664241 OR `props-main`.`id` = 1710416 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` = 1710239 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1710898 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1703285 OR `props-main`.`id` = 1703572 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1701745 OR `props-main`.`id` = 1701484 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1699137 OR `props-main`.`id` = 1699134 OR `props-main`.`id` = 1702022 OR `props-main`.`id` = 1702025 OR `props-main`.`id` = 1702031 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1702947 OR `props-main`.`id` = 1703091 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1691764 OR `props-main`.`id` = 1705043 OR `props-main`.`id` = 1704605 OR `props-main`.`id` = 1711202 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1710629 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1710069 OR `props-main`.`id` = 1698472 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1702194 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1711028 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 1691488 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 1705044 OR `props-main`.`id` = 1710977 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1705151 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1708125 OR `props-main`.`id` = 1708155 OR `props-main`.`id` = 1707998 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1708182 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1694068 OR `props-main`.`id` = 1701739 OR `props-main`.`id` = 1701720 OR `props-main`.`id` = 1701729 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1710648 OR `props-main`.`id` = 1708104 OR `props-main`.`id` = 1708071 OR `props-main`.`id` = 1688816)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225138370' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-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();
1
Similar Properties
$400,000
3
2
1,378
0.16
2900 Los Altos Ct
Atwater, CA 95301
Courtesy of Sonny Uppal, Adroit 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.
