A true diamond in the rough! This property is packed with potential for the right investor or creative buyer eager to design a custom home! Being sold as-is, it's ready for a complete makeover. Your vision, your rules! Don't miss the chance to transform opportunity into reality!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1979
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
CA 99 South, Exit 201 for Hammatt Ave, Turn left onto Hammatt Ave, Turn left onto Walnut Ave, Turn right onto Olds Ave, Property will be on the left.
Cross Street
Walnut Ave
County
Merced
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Wood
Foundation
Concrete, Slab
Roof
Shingle
Heating
None, See Remarks
Cooling
Ceiling Fan(s), Window Unit(s), See Remarks
Laundry Features
In Garage
Full Bathrooms
2
Bath Features
Shower Stall(s), Tile, Tub w/Shower Over
Flooring
Tile
Appliances
Hood Over Range
Kitchen Features
Synthetic Counter
Dining Room Features
Dining/Family Combo
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Solar
Electric
220 Volts
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Facing Front
Garage Spaces
2.00
Lot Features
Landscape Back, Landscape Front
APN
024 336 004 000
Horse Property
No
Zoning Description
Residential
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Livingston Union
Middle or Junior School District
Livingston Union
Senior High School District
Merced Union High
Census Tract
3.01
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 342000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 378000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 871 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1371 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` = 1703731 OR `props-main`.`id` = 1711015 OR `props-main`.`id` = 1707991 OR `props-main`.`id` = 1702779 OR `props-main`.`id` = 1710791 OR `props-main`.`id` = 1683262 OR `props-main`.`id` = 1710224 OR `props-main`.`id` = 1710241 OR `props-main`.`id` = 1622858 OR `props-main`.`id` = 1710310 OR `props-main`.`id` = 1707889 OR `props-main`.`id` = 1707902 OR `props-main`.`id` = 1707898 OR `props-main`.`id` = 1707910 OR `props-main`.`id` = 1710816 OR `props-main`.`id` = 1704708 OR `props-main`.`id` = 1638025 OR `props-main`.`id` = 1710382 OR `props-main`.`id` = 1710800 OR `props-main`.`id` = 1693519 OR `props-main`.`id` = 1710418 OR `props-main`.`id` = 1710419 OR `props-main`.`id` = 1699156 OR `props-main`.`id` = 1707178 OR `props-main`.`id` = 1710539 OR `props-main`.`id` = 1677807)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226015121' 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();
0
Courtesy of Maria Sosa Ruiz, Up Star Home Investment, 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.
