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
8
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` = 1710498 OR `props-main`.`id` = 1710499 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1710500 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1710497 OR `props-main`.`id` = 1617327 OR `props-main`.`id` = 1622883 OR `props-main`.`id` = 1710355 OR `props-main`.`id` = 1710505 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1710508 OR `props-main`.`id` = 1710507 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1710506 OR `props-main`.`id` = 1710390 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1709939 OR `props-main`.`id` = 1689517 OR `props-main`.`id` = 1683299 OR `props-main`.`id` = 1701696 OR `props-main`.`id` = 1703580 OR `props-main`.`id` = 1622831 OR `props-main`.`id` = 1708408 OR `props-main`.`id` = 1693530 OR `props-main`.`id` = 1696476 OR `props-main`.`id` = 1709550 OR `props-main`.`id` = 1710605 OR `props-main`.`id` = 1710754 OR `props-main`.`id` = 1696149 OR `props-main`.`id` = 1708142 OR `props-main`.`id` = 1710725 OR `props-main`.`id` = 1622835 OR `props-main`.`id` = 1704801 OR `props-main`.`id` = 1704822 OR `props-main`.`id` = 1685963 OR `props-main`.`id` = 1703598 OR `props-main`.`id` = 1709890 OR `props-main`.`id` = 1711328 OR `props-main`.`id` = 1705120 OR `props-main`.`id` = 1709185 OR `props-main`.`id` = 1695077 OR `props-main`.`id` = 1703673 OR `props-main`.`id` = 1703755 OR `props-main`.`id` = 1705117 OR `props-main`.`id` = 1709155 OR `props-main`.`id` = 1705106 OR `props-main`.`id` = 1709186 OR `props-main`.`id` = 1709165 OR `props-main`.`id` = 1709169 OR `props-main`.`id` = 1702363 OR `props-main`.`id` = 1709164 OR `props-main`.`id` = 1709163 OR `props-main`.`id` = 1710117 OR `props-main`.`id` = 1705116 OR `props-main`.`id` = 1711084 OR `props-main`.`id` = 1694865 OR `props-main`.`id` = 1684589 OR `props-main`.`id` = 1705935 OR `props-main`.`id` = 1698061 OR `props-main`.`id` = 1695415 OR `props-main`.`id` = 1695414 OR `props-main`.`id` = 196010 OR `props-main`.`id` = 1707096 OR `props-main`.`id` = 1701453 OR `props-main`.`id` = 1698962 OR `props-main`.`id` = 1686442 OR `props-main`.`id` = 1708143 OR `props-main`.`id` = 1704893 OR `props-main`.`id` = 1701452 OR `props-main`.`id` = 1708107 OR `props-main`.`id` = 1704890 OR `props-main`.`id` = 1708114 OR `props-main`.`id` = 1704894 OR `props-main`.`id` = 1701470 OR `props-main`.`id` = 1701206 OR `props-main`.`id` = 1708106 OR `props-main`.`id` = 1680643 OR `props-main`.`id` = 1663308 OR `props-main`.`id` = 1697035 OR `props-main`.`id` = 1710765 OR `props-main`.`id` = 1710859 OR `props-main`.`id` = 1710968 OR `props-main`.`id` = 1708108 OR `props-main`.`id` = 1686586 OR `props-main`.`id` = 1696703 OR `props-main`.`id` = 1689768 OR `props-main`.`id` = 1688973 OR `props-main`.`id` = 1706884 OR `props-main`.`id` = 1672896 OR `props-main`.`id` = 1710514 OR `props-main`.`id` = 1711340 OR `props-main`.`id` = 1703143 OR `props-main`.`id` = 1642756 OR `props-main`.`id` = 1642913 OR `props-main`.`id` = 1687775 OR `props-main`.`id` = 1693646 OR `props-main`.`id` = 1703662 OR `props-main`.`id` = 1697842 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1694963 OR `props-main`.`id` = 1710921 OR `props-main`.`id` = 1710181)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82035268' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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();
2
Similar Properties
$454,990
4
3
1,842
0.11
167 River Oak Dr #178SE
Merced, CA 95341
$439,990
4
3
1,775
0.10
272 Sable St #70 AR
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.
