Welcome to 674 Wallis Ave! This well-maintained 3 bedroom, 2 bathroom home offers a nice blend of modern touches and unique character, with clear pride of ownership throughout. The living room features original hardwood floors that add warmth and charm to the space. The home has been freshly painted and includes several recent upgrades. The spacious primary bedroom includes a flexible nursery or office area, perfect for working from home or creating a cozy retreat, with a pleasant view overlooking the large backyard and citrus trees. The backyard offers plenty of space to relax, garden, or entertain. Conveniently located with close proximity to the freeway, this home is ideal for Bay Area commuters seeking easy access while still enjoying a neighborhood setting. Please note, public records reflect this property as a 2 bedroom, 1 bathroom home; however, it is currently used as a 3 bedroom, 2 bathroom. Buyer to conduct their own investigations regarding permits, as seller is not aware of any. A great opportunity to own a comfortable home with character and room to enjoy both indoors and out.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1949
Year Built Source
Other
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR
Stories
1
Home Warranty
No
Directions to Property
from 140 turn right, left on Grove Ave. and right on Wallis Ave. Home is on the left-hand side.
Cross Street
Steele Ave.
County
Merced
Special Listing Conditions
None
Main Level
Bedroom(s)
Architectural Style
Craftsman
Construction Materials
Stucco
Foundation
Raised
Roof
Composition
Heating
Central
Cooling
Central
Laundry Features
Inside Area, Inside Room
Full Bathrooms
2
Bath Features
Tub w/Shower Over
Possible Bedrooms
3
Flooring
Carpet, Tile, Vinyl, Wood
Appliances
Built-In Gas Range, Gas Water Heater, Microwave
Kitchen Features
Laminate Counter
Dining Room Features
Breakfast Nook
Living Room Features
View
Primary Bedroom Features
Sitting Room
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts in Laundry
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Detached
Garage Spaces
1.00
Lot Features
Shape Regular
APN
020 163 002 000
View Description
Water
Horse Property
No
Zoning Description
residential
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Gustine Unified
Middle or Junior School District
Gustine Unified
Senior High School District
Merced Union High
Census Tract
20.02
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375249.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414748.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 912 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1412 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` = 1700390 OR `props-main`.`id` = 1703345 OR `props-main`.`id` = 1700302 OR `props-main`.`id` = 1683643 OR `props-main`.`id` = 1701292 OR `props-main`.`id` = 1696049 OR `props-main`.`id` = 1703504 OR `props-main`.`id` = 1702231 OR `props-main`.`id` = 1697626 OR `props-main`.`id` = 1691150 OR `props-main`.`id` = 1671771 OR `props-main`.`id` = 1700279 OR `props-main`.`id` = 1684539 OR `props-main`.`id` = 1690024 OR `props-main`.`id` = 1687850 OR `props-main`.`id` = 1693900 OR `props-main`.`id` = 1696650 OR `props-main`.`id` = 1696646 OR `props-main`.`id` = 1700750 OR `props-main`.`id` = 1693723 OR `props-main`.`id` = 1697791)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226006568' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-21' 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 Ramirez, Concierge Homes 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.
