Charming older home situated on a spacious corner lot. Property has a large yard with a detached garage with street access for extra storage and parking. Inside you will find the home has a lot of character and plenty of potential. As a bonus there is an unfinished basement!Bathroom count is different than tax records, buyer to verify if important.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1939
Levels
One
Home Warranty
No
Directions to Property
Robertson Blvd, north on 8th street house is on the corner of 8th and Riverside.
Cross Street
8th Street
County
Madera
Construction Materials
Stucco
Roof
Composition
Heating
Central
Cooling
Central
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Flooring
Laminate, Wood, Carpet
Appliances
Disposal
Basement
Unfinished
Pool
No
Spa
No
Utilities
Public
Water Source
Public
Sewer
Public Sewer
Parking Features
Detached
Garage Spaces
2.00
APN
111 500 400 0
Horse Property
No
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Madera
Elementary School District
Chowchilla Elementary
Middle or Junior School District
Chowchilla Elementary
Senior High School District
Chowchilla Union High
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 308655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 341145 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 836 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1336 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` = 1726956 OR `props-main`.`id` = 1726992 OR `props-main`.`id` = 1731353 OR `props-main`.`id` = 1723270 OR `props-main`.`id` = 1680816 OR `props-main`.`id` = 1730887 OR `props-main`.`id` = 1730994 OR `props-main`.`id` = 1716355 OR `props-main`.`id` = 1722078 OR `props-main`.`id` = 1731590 OR `props-main`.`id` = 1721098 OR `props-main`.`id` = 1052956 OR `props-main`.`id` = 1731764 OR `props-main`.`id` = 1726383 OR `props-main`.`id` = 1730655 OR `props-main`.`id` = 1730660 OR `props-main`.`id` = 1731184 OR `props-main`.`id` = 1723233 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1726932 OR `props-main`.`id` = 1714339 OR `props-main`.`id` = 1731358 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1726333 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1727460 OR `props-main`.`id` = 1725862 OR `props-main`.`id` = 1725553 OR `props-main`.`id` = 1728428 OR `props-main`.`id` = 1728415 OR `props-main`.`id` = 1731330 OR `props-main`.`id` = 1725132 OR `props-main`.`id` = 1726323 OR `props-main`.`id` = 1725135 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1714248 OR `props-main`.`id` = 1723267 OR `props-main`.`id` = 1731759 OR `props-main`.`id` = 1729336 OR `props-main`.`id` = 1729363 OR `props-main`.`id` = 1729339 OR `props-main`.`id` = 1717356 OR `props-main`.`id` = 1724281 OR `props-main`.`id` = 1704531 OR `props-main`.`id` = 1721284 OR `props-main`.`id` = 1721067 OR `props-main`.`id` = 1721227 OR `props-main`.`id` = 1731589 OR `props-main`.`id` = 1687929 OR `props-main`.`id` = 1731365 OR `props-main`.`id` = 1721804 OR `props-main`.`id` = 1723288 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1714574 OR `props-main`.`id` = 1726045 OR `props-main`.`id` = 1726047 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1731322 OR `props-main`.`id` = 1714260 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1706732 OR `props-main`.`id` = 1731675 OR `props-main`.`id` = 1725465 OR `props-main`.`id` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1731461 OR `props-main`.`id` = 1731513 OR `props-main`.`id` = 1715647 OR `props-main`.`id` = 1715622 OR `props-main`.`id` = 1715633 OR `props-main`.`id` = 1731526 OR `props-main`.`id` = 1717826 OR `props-main`.`id` = 1717855 OR `props-main`.`id` = 1726796 OR `props-main`.`id` = 1726800 OR `props-main`.`id` = 1731335 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1731574 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1724265 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1721091 OR `props-main`.`id` = 1721549 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1731515 OR `props-main`.`id` = 1727222 OR `props-main`.`id` = 1727207 OR `props-main`.`id` = 1731713 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1718358 OR `props-main`.`id` = 1718314 OR `props-main`.`id` = 1718318 OR `props-main`.`id` = 1731548 OR `props-main`.`id` = 1718231 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1730883 OR `props-main`.`id` = 1730993 OR `props-main`.`id` = 1731185 OR `props-main`.`id` = 1726733 OR `props-main`.`id` = 1731701 OR `props-main`.`id` = 1726793 OR `props-main`.`id` = 1726734 OR `props-main`.`id` = 1726794 OR `props-main`.`id` = 1731702 OR `props-main`.`id` = 1727729 OR `props-main`.`id` = 1723371)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225602747' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
4
Similar Properties
$324,900
2
1.5
1,086
0.24
801 Riverside Ave
Chowchilla, CA 93610
$320,000
3
2
1,176
0.11
701 Ventura Ave
Chowchilla, CA 93610
$320,000
3
2
1,176
0.11
701 Ventura Ave
Chowchilla, CA 93610
$309,000
3
2
1,096
0.16
1108 Kings
Chowchilla, CA 93610
Courtesy of Default zSystem, London Properties LTD 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.
