Courtesy of Teresa Kleinen, Better Homes and Gardens Real - [email protected]
Set on a quiet cul-de-sac in desirable North Merced, this impressive two-story home offers approximately 3,576 square feet of thoughtfully designed living space with 5 bedrooms and 4 bathrooms. From the moment you arrive, the attractive exterior stone accents and inviting curb appeal set the tone for what awaits inside. The home features formal living and dining areas, tile flooring, and a warm gas log fireplace that creates a comfortable gathering space. At the center of the home is a spacious kitchen designed for both everyday living and entertaining, complete with granite slab countertops, abundant cabinet space, and a striking curved island with a built-in sink that adds both style and function.One bedroom and one full bathroom are conveniently located on the main floor, offering ideal flexibility for guests, extended family, or a home office. Upstairs, the expansive primary suite serves as a private retreat with a spa-like bathroom featuring a soaking tub, separate shower stall, his and hers closets, and access to a large second-story balcony overlooking the backyard oasis.Step outside and enjoy your own private resort-style setting with a sparkling pool, relaxing spa, and built-in outdoor kitchen designed for entertaining and enjoying warm Central Valley summers. Conveniently located near shopping, restaurants, schools, Merced College, UC Merced, and the Cattracks bus route, this exceptional home combines generous living space, desirable amenities, and an outstanding North Merced location.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2007
Region
Urban
# of Stories
Two
Price Per Square Foot
$173
Price Per Acre
$4,025,974
Days On London
0
Cumulative Days On London
0
County
Merced
Reports Available
NHD
Leased Equipment
Solar Panels
REO / Bank Owned
No
Cross Street Address
Avignon
Directions
From Yosemite Ave turn north on El Redondo, turn right on Avignon and left on Sisteron Ct
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Upper Level
Roofing
Tile
Foundation
Concrete
Kitchen
Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry
Dining Room Features
Formal
Primary Bedroom Level
Upper
Bath Features
Tub/Shower
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco, Stone
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
In Ground
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Lease
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
206 210 051 000
Zoning
P-D
School District
Merced
School Type 1
High School
School Name 1
Merced
School Type 2
Junior High School
School Name 2
Merced
School Type 3
Grade School
School Name 3
Merced
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 589000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 651000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3326 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3826 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` = 1726114 OR `props-main`.`id` = 1725537 OR `props-main`.`id` = 1725710 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1730790 OR `props-main`.`id` = 1719076 OR `props-main`.`id` = 1724893 OR `props-main`.`id` = 1723298 OR `props-main`.`id` = 1725758 OR `props-main`.`id` = 1722662 OR `props-main`.`id` = 1726941 OR `props-main`.`id` = 1726930 OR `props-main`.`id` = 1727360 OR `props-main`.`id` = 1726561 OR `props-main`.`id` = 1726750 OR `props-main`.`id` = 1727524 OR `props-main`.`id` = 1720609 OR `props-main`.`id` = 1714839 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1719687 OR `props-main`.`id` = 1730918 OR `props-main`.`id` = 1720457 OR `props-main`.`id` = 1722618 OR `props-main`.`id` = 1725305 OR `props-main`.`id` = 1725309 OR `props-main`.`id` = 1725313 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1728766 OR `props-main`.`id` = 1717006 OR `props-main`.`id` = 1731900 OR `props-main`.`id` = 1728905 OR `props-main`.`id` = 1728922 OR `props-main`.`id` = 1727282 OR `props-main`.`id` = 1730650 OR `props-main`.`id` = 1730642 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1732320 OR `props-main`.`id` = 1714876 OR `props-main`.`id` = 1714091 OR `props-main`.`id` = 1723262 OR `props-main`.`id` = 1728677 OR `props-main`.`id` = 1728364 OR `props-main`.`id` = 1724196 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1727728 OR `props-main`.`id` = 1727723 OR `props-main`.`id` = 1727764 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 1721038 OR `props-main`.`id` = 1715798 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1726777 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1721101 OR `props-main`.`id` = 1721326 OR `props-main`.`id` = 1716572 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1725489 OR `props-main`.`id` = 1726991 OR `props-main`.`id` = 1726957 OR `props-main`.`id` = 1731126 OR `props-main`.`id` = 1731108 OR `props-main`.`id` = 1731114 OR `props-main`.`id` = 1732333 OR `props-main`.`id` = 1732357 OR `props-main`.`id` = 1722230 OR `props-main`.`id` = 1722504 OR `props-main`.`id` = 1731748 OR `props-main`.`id` = 1728646 OR `props-main`.`id` = 1728953 OR `props-main`.`id` = 1728957 OR `props-main`.`id` = 1731938 OR `props-main`.`id` = 1728906 OR `props-main`.`id` = 1730643 OR `props-main`.`id` = 1728787 OR `props-main`.`id` = 1723222 OR `props-main`.`id` = 1731812 OR `props-main`.`id` = 1728909 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1725492 OR `props-main`.`id` = 1725228 OR `props-main`.`id` = 1724958 OR `props-main`.`id` = 1724939 OR `props-main`.`id` = 1725629 OR `props-main`.`id` = 1725121 OR `props-main`.`id` = 1728505 OR `props-main`.`id` = 1729137 OR `props-main`.`id` = 1705596 OR `props-main`.`id` = 1729241 OR `props-main`.`id` = 1718560 OR `props-main`.`id` = 1718552 OR `props-main`.`id` = 1715752 OR `props-main`.`id` = 1727165 OR `props-main`.`id` = 1727167 OR `props-main`.`id` = 1727166 OR `props-main`.`id` = 1727790 OR `props-main`.`id` = 1721288 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1727560 OR `props-main`.`id` = 1727508 OR `props-main`.`id` = 1724895 OR `props-main`.`id` = 1727559 OR `props-main`.`id` = 1724894 OR `props-main`.`id` = 1723836 OR `props-main`.`id` = 1724960 OR `props-main`.`id` = 1724962 OR `props-main`.`id` = 1727223 OR `props-main`.`id` = 1724961 OR `props-main`.`id` = 1723957 OR `props-main`.`id` = 1728178 OR `props-main`.`id` = 1723956 OR `props-main`.`id` = 1723977 OR `props-main`.`id` = 1727980 OR `props-main`.`id` = 1727994 OR `props-main`.`id` = 1723958 OR `props-main`.`id` = 1728191 OR `props-main`.`id` = 1725284 OR `props-main`.`id` = 1724004 OR `props-main`.`id` = 1728013 OR `props-main`.`id` = 1701451)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649835' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-03' 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
$589,000
5
4
3,576
0.15
4076 St Remy Ct
Merced, CA 95348
Last modified 2 hours ago Fresno MLS last checked for updates 32 minutes ago
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.
