Well, maintained home, great floor plan, spacious bedrooms, indoor laundry, family room with gas burning fireplace, upgraded kitchen with stainless steel appliances, granite counter tops, custom tile back splash, move in ready home. Spacious back yard, perfect for entreating. Walk to city park and a short drive to amenities. A must see home.
Property Sub Type
Single Family Residence
Year Built
2005
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Price Per Square Foot
$236
Days On London
167
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Campus Parkway to Gerard, Right on Lily, right on Blix Ave, Right on Hydrangea Court Cross Street: Blix Avenue
Architectural Style
Contemporary
Room Type
Walk-In Closet
Cooling
Central Air
Roof
Tile
Construction Materials
Stucco
Direction Faces
East
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Room Kitchen Features
Laminate Counters
Appliances Y/N
Yes
Appliances
Gas Oven
Flooring
Laminate
Common Walls
No Common Walls
Fireplace Y/N
Yes
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Level
Lot Size Area
5471.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Parcel Number
061532012000
Zoning
R-1-5
Association Y/N
No
High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 418000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 462000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1614 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2114 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` = 1750372 OR `props-main`.`id` = 1750373 OR `props-main`.`id` = 1724910 OR `props-main`.`id` = 1757406 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1723303 OR `props-main`.`id` = 1750374 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1750371 OR `props-main`.`id` = 1754492 OR `props-main`.`id` = 1731157 OR `props-main`.`id` = 1750377 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1750380 OR `props-main`.`id` = 1750379 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1750378 OR `props-main`.`id` = 1750355 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1755640 OR `props-main`.`id` = 1745418 OR `props-main`.`id` = 1709550 OR `props-main`.`id` = 1738363 OR `props-main`.`id` = 1747597 OR `props-main`.`id` = 1757628 OR `props-main`.`id` = 1738341 OR `props-main`.`id` = 1747695 OR `props-main`.`id` = 1755177 OR `props-main`.`id` = 1756182 OR `props-main`.`id` = 1744294 OR `props-main`.`id` = 1746463 OR `props-main`.`id` = 1746464 OR `props-main`.`id` = 1757619 OR `props-main`.`id` = 1757617 OR `props-main`.`id` = 1757620 OR `props-main`.`id` = 1746444 OR `props-main`.`id` = 1718339 OR `props-main`.`id` = 1757618 OR `props-main`.`id` = 1746436 OR `props-main`.`id` = 1746445 OR `props-main`.`id` = 1734544 OR `props-main`.`id` = 1710117 OR `props-main`.`id` = 1734533 OR `props-main`.`id` = 1746437 OR `props-main`.`id` = 1750518 OR `props-main`.`id` = 1755747 OR `props-main`.`id` = 1756050 OR `props-main`.`id` = 1753455 OR `props-main`.`id` = 1754697 OR `props-main`.`id` = 1727938 OR `props-main`.`id` = 1752512 OR `props-main`.`id` = 1746124 OR `props-main`.`id` = 1746130 OR `props-main`.`id` = 1705935 OR `props-main`.`id` = 1716724 OR `props-main`.`id` = 1749924 OR `props-main`.`id` = 196010 OR `props-main`.`id` = 1742786 OR `props-main`.`id` = 1753397 OR `props-main`.`id` = 1707096 OR `props-main`.`id` = 1698962 OR `props-main`.`id` = 1754756 OR `props-main`.`id` = 1754803 OR `props-main`.`id` = 1744437 OR `props-main`.`id` = 1756154 OR `props-main`.`id` = 1751645 OR `props-main`.`id` = 1701206 OR `props-main`.`id` = 1680643 OR `props-main`.`id` = 1757800 OR `props-main`.`id` = 1755173 OR `props-main`.`id` = 1714053 OR `props-main`.`id` = 1719554 OR `props-main`.`id` = 1727779 OR `props-main`.`id` = 1719524 OR `props-main`.`id` = 1741033 OR `props-main`.`id` = 1741110 OR `props-main`.`id` = 1741124 OR `props-main`.`id` = 1725968 OR `props-main`.`id` = 1734301 OR `props-main`.`id` = 1723225 OR `props-main`.`id` = 1723794 OR `props-main`.`id` = 1725724 OR `props-main`.`id` = 1740678 OR `props-main`.`id` = 1711417 OR `props-main`.`id` = 1725535 OR `props-main`.`id` = 1725536 OR `props-main`.`id` = 1755818 OR `props-main`.`id` = 1642756 OR `props-main`.`id` = 1642913 OR `props-main`.`id` = 1687775 OR `props-main`.`id` = 1753905 OR `props-main`.`id` = 1753912 OR `props-main`.`id` = 1717574 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1694963 OR `props-main`.`id` = 1693646 OR `props-main`.`id` = 1753379 OR `props-main`.`id` = 1736077)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82035268' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-05' 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
$460,990
4
3
1,842
0.12
156 Sugar Creek Ct #147 S2
Merced, CA 95341
$459,000
4
3
1,945
0.11
63 Maia Ct
Merced, CA 95341
$456,100
4
3
1,750
0.15
18 Squaw Valley Ct.
Merced, CA 95341
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.
