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
Year Built
1949
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$340
Price Per Acre
$1,911,902
Days On Market
0
Cumulative Days On Market
0
County
Merced
REO / Bank Owned
No
Cross Street Address
Steele Ave.
Directions
from 140 turn right, left on Grove Ave. and right on Wallis Ave. Home is on the left-hand side.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Lower
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
No
Garage Type
Detached
Garage Spaces
1
APN
020 163 002 000
School District
Gustine Unified
School Type 1
High School
School Name 1
Gustine
School Type 2
Junior High School
School Name 2
Gustine
School Type 3
Grade School
School Name 3
Gustine
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) >= '3' 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`) != 'fresno642489' 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 - [email protected] Last modified 21 hours ago Fresno MLS last checked for updates 26 minutes ago
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.
