Listing Agent: Kristin Price, London Properties, Chowchilla
Discover the possibilities at 17107 Avenue 24 in Chowchilla! Situated on approximately .87 acres, this ranch-style home offers plenty of room to enjoy both indoor and outdoor living. The home is in need of repairs, making it a great option for someone ready to bring their own ideas and personal touches. Conveniently located near Highways 99 and 152, with easy access to Chowchilla, Los Banos, Merced, Madera, and surrounding areas. Property is being sold in its present, as-is condition. Bedroom count is different than tax records, buyer to verify if important.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1926
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Front
Price Per Square Foot
$365
Days On London
2
Cumulative Days On London
2
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
No
Directions
Highway 99 to Robertson Boulevard to Chowchilla Boulevard to Avenue 24.
Room Type
Kitchen
Cooling
None
Laundry Y/N
Yes
Laundry Features
In Kitchen
Main Level Bedrooms
3
Bathrooms Full
1
Bathrooms Full And Three Quarter
1
Main Level Bathrooms
1
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Water Source
Well
Sewer
Septic Type Unknown
Lot Features
0-1 Unit/Acre,Secluded
Lot Size Area
37897.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Common Interest
None
Parcel Number
002350012
Additional Parcels Y/N
No
Community Features
Rural
Senior Community Y/N
No
Association Y/N
No
High School District
Chowchilla Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
724
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 308750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 341250 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) >= 640 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1140 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` = 1749062 OR `props-main`.`id` = 1747713 OR `props-main`.`id` = 1747731 OR `props-main`.`id` = 1747742 OR `props-main`.`id` = 1636375 OR `props-main`.`id` = 1750349 OR `props-main`.`id` = 1666061 OR `props-main`.`id` = 1758798 OR `props-main`.`id` = 1758771 OR `props-main`.`id` = 1758774 OR `props-main`.`id` = 1729032 OR `props-main`.`id` = 1758255 OR `props-main`.`id` = 1754757 OR `props-main`.`id` = 1726956 OR `props-main`.`id` = 1726992 OR `props-main`.`id` = 1714977 OR `props-main`.`id` = 1714941 OR `props-main`.`id` = 1714947 OR `props-main`.`id` = 1732049 OR `props-main`.`id` = 1732059 OR `props-main`.`id` = 1734255 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1753602 OR `props-main`.`id` = 1752919 OR `props-main`.`id` = 1752942 OR `props-main`.`id` = 1757466 OR `props-main`.`id` = 1757638 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1750503 OR `props-main`.`id` = 1726383 OR `props-main`.`id` = 1727711 OR `props-main`.`id` = 1727716 OR `props-main`.`id` = 1759515 OR `props-main`.`id` = 1739016 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1742752 OR `props-main`.`id` = 1733239 OR `props-main`.`id` = 1727460 OR `props-main`.`id` = 1749695 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1757356 OR `props-main`.`id` = 1738257 OR `props-main`.`id` = 1721804 OR `props-main`.`id` = 1735557 OR `props-main`.`id` = 1744848 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1750370 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1726796 OR `props-main`.`id` = 1726800 OR `props-main`.`id` = 1753505 OR `props-main`.`id` = 1753313 OR `props-main`.`id` = 1753321 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1732152 OR `props-main`.`id` = 1724265 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1741743 OR `props-main`.`id` = 1749419 OR `props-main`.`id` = 1754701 OR `props-main`.`id` = 1754711 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1727222 OR `props-main`.`id` = 1727207 OR `props-main`.`id` = 1723311 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` = 1726793 OR `props-main`.`id` = 1741745 OR `props-main`.`id` = 1741698 OR `props-main`.`id` = 1726734 OR `props-main`.`id` = 1726794)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR26171154' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-08' 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
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.
