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` = 1731932 OR `props-main`.`id` = 1739557 OR `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` = 1739132 OR `props-main`.`id` = 1739156 OR `props-main`.`id` = 1732049 OR `props-main`.`id` = 1732059 OR `props-main`.`id` = 1734255 OR `props-main`.`id` = 1730887 OR `props-main`.`id` = 1730994 OR `props-main`.`id` = 1737838 OR `props-main`.`id` = 1737843 OR `props-main`.`id` = 1716355 OR `props-main`.`id` = 1052956 OR `props-main`.`id` = 1726383 OR `props-main`.`id` = 1730655 OR `props-main`.`id` = 1731184 OR `props-main`.`id` = 1723233 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1739016 OR `props-main`.`id` = 1714339 OR `props-main`.`id` = 1731358 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1727460 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` = 1738037 OR `props-main`.`id` = 1738257 OR `props-main`.`id` = 1731759 OR `props-main`.`id` = 1729336 OR `props-main`.`id` = 1729363 OR `props-main`.`id` = 1729339 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` = 1687929 OR `props-main`.`id` = 1731365 OR `props-main`.`id` = 1740190 OR `props-main`.`id` = 1740194 OR `props-main`.`id` = 1739209 OR `props-main`.`id` = 1739261 OR `props-main`.`id` = 1721804 OR `props-main`.`id` = 1723288 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1714574 OR `props-main`.`id` = 1735557 OR `props-main`.`id` = 1734811 OR `props-main`.`id` = 1734809 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` = 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` = 1732152 OR `props-main`.`id` = 1724265 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1739425 OR `props-main`.`id` = 1739536 OR `props-main`.`id` = 1721549 OR `props-main`.`id` = 1732058 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` = 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-22' 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();
5
Similar Properties
$339,000
3
2
1,232
0.11
406 Jefferson St
Chowchilla, CA 93610
$325,000
3
2
1,110
0.15
101 Oak Ct
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
Courtesy of Non-MLS Member, 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.
