PRICE IMPROVEMENT! This beautifully maintained 1,929 sq ft residence offers the perfect blend of classic charm and modern upgrades, featuring 4 bedrooms and 2 bathrooms in a spacious, comfortable layout. Ideally situated directly across from a lovely park and within a short walk to the local elementary and middle schools. The location delivers both convenience and family friendly atmosphere. The front yard boast low-maintenance artificial turf and stunning Govee Permanent exterior lighting, while 8-camera outdoor 4K CCTV system and ring doorbell provide added piece of mind. Inside the bright and expensive great room showcases a gorgeous fireplace, elegant laminate flooring and an open layout for entertaining or hosting holiday gatherings. The kitchen was fully remodeled in 2023 and includes premium GE Profile appliances paired with timeless granite countertops. Additional upgrades include a new HVAC system ad ducting (2023) for optimal comfort and efficiency. Step into the backyard and enjoy the private oasis complete with refreshing pool and charming pavilion added in 2020. The garage offers practical attic storage and EV outlet for added convenience. Don't miss this opportunity to make this stunning move in ready home yours!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2002
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Kitchen 0-5YR, Bath 6-10YR, Bed 6-10YR
Stories
1
Levels
One
Home Warranty
No
Directions to Property
Briggsmore left to Claus left on Merle right on Fine and left on Sharon
Cross Street
MERLE
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 541405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 598395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1679 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2179 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` = 1710959 OR `props-main`.`id` = 1709720 OR `props-main`.`id` = 1707938 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1711183 OR `props-main`.`id` = 1711309 OR `props-main`.`id` = 1710542 OR `props-main`.`id` = 1697604 OR `props-main`.`id` = 1689722 OR `props-main`.`id` = 1671549 OR `props-main`.`id` = 1704457 OR `props-main`.`id` = 1695807 OR `props-main`.`id` = 1698444 OR `props-main`.`id` = 1680573 OR `props-main`.`id` = 1710771 OR `props-main`.`id` = 1701445 OR `props-main`.`id` = 1711347 OR `props-main`.`id` = 1695660 OR `props-main`.`id` = 1711152 OR `props-main`.`id` = 1709507 OR `props-main`.`id` = 1705412 OR `props-main`.`id` = 1708272 OR `props-main`.`id` = 1689340 OR `props-main`.`id` = 1708424 OR `props-main`.`id` = 1704625 OR `props-main`.`id` = 1709273 OR `props-main`.`id` = 1704839 OR `props-main`.`id` = 1711279 OR `props-main`.`id` = 1703942 OR `props-main`.`id` = 1708497 OR `props-main`.`id` = 1709921 OR `props-main`.`id` = 1711235 OR `props-main`.`id` = 1697854 OR `props-main`.`id` = 1707084 OR `props-main`.`id` = 1691865 OR `props-main`.`id` = 1705253 OR `props-main`.`id` = 1703104 OR `props-main`.`id` = 1711168 OR `props-main`.`id` = 1697714 OR `props-main`.`id` = 1708484 OR `props-main`.`id` = 1710987 OR `props-main`.`id` = 1708218 OR `props-main`.`id` = 1706866 OR `props-main`.`id` = 1710812 OR `props-main`.`id` = 1704885 OR `props-main`.`id` = 1697447 OR `props-main`.`id` = 1707027 OR `props-main`.`id` = 1686997 OR `props-main`.`id` = 1706068 OR `props-main`.`id` = 1703452 OR `props-main`.`id` = 1708276 OR `props-main`.`id` = 1703802 OR `props-main`.`id` = 1708028 OR `props-main`.`id` = 1692060 OR `props-main`.`id` = 1697497 OR `props-main`.`id` = 1710184 OR `props-main`.`id` = 1702925 OR `props-main`.`id` = 1675168 OR `props-main`.`id` = 1709941 OR `props-main`.`id` = 1707869 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1710666)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225143392' 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
$559,990
4
2
1,718
0.14
2621 Red Tail Hawk Rd
Modesto, CA 95357
Courtesy of Elizabeth Carrillo, JRP Realty Group 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.
