Listing Agent: Yei Chan Lee, Real Brokerage Technologies
Charming 3 bedroom 1 bathroom 1050 sqft single story residence situated in a cul-de-sac and on an expansive 7,623 sf lot. The ideal starter home with a large backyard for plenty of room for your entire family. Don't miss out on this opportunity.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1980
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$357
Days On London
0
Cumulative Days On London
0
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
From Railroad Ave, turn into Wallis Ave, Right on Walnut Dr
Room Type
All Bedrooms Down, Kitchen, Living Room
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Roof
Composition, Shingle
Main Level Bedrooms
3
Bathrooms Full
1
Bathrooms Full And Three Quarter
1
Main Level Bathrooms
1
Room Kitchen Features
Granite Counters
Appliances Y/N
Yes
Appliances
Disposal, Range Hood, Gas Range, Dishwasher
Flooring
Vinyl
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Utilities
Natural Gas Connected, Sewer Connected, Electricity Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
1.00
Parking Features
Garage, Driveway
Attached Garage Y/N
Yes
Garage Spaces
1.00
Lot Features
Irregular Lot
Lot Size Area
7654.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Fencing
Wood
Common Interest
None
Parcel Number
020172026000
Additional Parcels Y/N
No
Community Features
Curbs, Street Lights, Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Gustine Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
5
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356155 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393645 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) >= 800 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1300 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` = 1783484 OR `props-main`.`id` = 1720989 OR `props-main`.`id` = 1776100 OR `props-main`.`id` = 1775584 OR `props-main`.`id` = 1784151 OR `props-main`.`id` = 1756840 OR `props-main`.`id` = 1785714 OR `props-main`.`id` = 1771634 OR `props-main`.`id` = 1765271 OR `props-main`.`id` = 1774482 OR `props-main`.`id` = 1776139 OR `props-main`.`id` = 1785539 OR `props-main`.`id` = 1774706 OR `props-main`.`id` = 1781644 OR `props-main`.`id` = 1782467)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsPT26215211' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-02' 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
$379,000
3
2
1,080
0.15
44 Fairview Ave
Gustine, CA 95322
$365,000
3
2
1,158
0.15
913 Sylvia St
Gustine, CA 95322
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.
