🏡 Opportunity in the Central Valley This home offers 3 to 4 bedrooms and 2 full bathrooms, perfect for families looking for space and comfort. The property is in good condition, only needing a little cleaning and minor touch-ups to show its full potential. This property is a great opportunity for anyone looking for a move-in ready home or an investment.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1956
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
Walnut Ave to Cypress Ave to Fairlane Ave
Cross Street
Cypress Ave
County
Merced
Special Listing Conditions
Offer As Is
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Kitchen, Street Entrance
Construction Materials
Wood, Other
Foundation
Raised
Roof
Shingle
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Other
Full Bathrooms
1
Bath Features
Tub w/Shower Over
Possible Bedrooms
4
Flooring
Carpet, Laminate, Tile
Kitchen Features
Breakfast Area, Tile Counter
Dining Room Features
Dining/Living Combo, Formal Area, Other
Living Room Features
View, Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Other
Electric
220 Volts in Laundry,Other
Irrigation
None
Water Source
Public, Other
Sewer
Other
Parking Features
No Garage, Other
Lot Features
Other
APN
147 080 061 000
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Winton
Middle or Junior School District
Winton
Senior High School District
Merced Union High
Census Tract
5.05
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 275500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 304500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 854 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1354 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` = 1686888 OR `props-main`.`id` = 1697204 OR `props-main`.`id` = 1697661 OR `props-main`.`id` = 1692907 OR `props-main`.`id` = 1692458 OR `props-main`.`id` = 1696460 OR `props-main`.`id` = 1697464 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1687780 OR `props-main`.`id` = 1692678 OR `props-main`.`id` = 1696793 OR `props-main`.`id` = 1690176 OR `props-main`.`id` = 1690198 OR `props-main`.`id` = 1678843 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1693372 OR `props-main`.`id` = 1692125 OR `props-main`.`id` = 1685496 OR `props-main`.`id` = 1691063 OR `props-main`.`id` = 1697937 OR `props-main`.`id` = 1697917 OR `props-main`.`id` = 1692490 OR `props-main`.`id` = 1692479 OR `props-main`.`id` = 1692484 OR `props-main`.`id` = 1622832 OR `props-main`.`id` = 1622833 OR `props-main`.`id` = 1692657 OR `props-main`.`id` = 1692658 OR `props-main`.`id` = 1683263 OR `props-main`.`id` = 1667509 OR `props-main`.`id` = 1692986 OR `props-main`.`id` = 1691534 OR `props-main`.`id` = 1690963 OR `props-main`.`id` = 1691914 OR `props-main`.`id` = 1692176 OR `props-main`.`id` = 1668550 OR `props-main`.`id` = 1668432 OR `props-main`.`id` = 1695695 OR `props-main`.`id` = 1696643 OR `props-main`.`id` = 586564 OR `props-main`.`id` = 1687986 OR `props-main`.`id` = 1693249 OR `props-main`.`id` = 1685495 OR `props-main`.`id` = 1697635 OR `props-main`.`id` = 874388 OR `props-main`.`id` = 1515932 OR `props-main`.`id` = 1692662 OR `props-main`.`id` = 1695184 OR `props-main`.`id` = 1637763 OR `props-main`.`id` = 1637752)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225113485' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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();
0
Courtesy of Demetrio Robles, Casa Robles R.E. Inc. 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.
