Courtesy of Kelle Ray, London Properties, Chowchilla - [email protected]
Looking for space to explore all the hobbies you have been dreaming about? This home is the perfect combination of functional and creative license. There is room for all the fun things such as a garden, chickens, goats, and 60X22ft shop with 220 power and two roll up doors. A second shop 40X22 with 220 and a septic receptacle. The garden area has a multitude of fruit tress that are in full production mode. If you are ready for quiet time in the garden this is your property.The home has 3 bedrooms 1 bath and laminate flooring throughout.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1978
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$446
Price Per Acre
$128,755
Days On London
42
Cumulative Days On London
42
County
Madera
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Avenue 24
Directions
Highway 99 to Ave 24 left on Road 18 1/2.
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
Dishwasher, Eating Area
Primary Bedroom Level
Main
Bath Features
Shower
Flooring
Laminate
# of Fireplaces
1
Fireplace Type
Masonry
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Yard
Sprinklers Front, Sprinklers Back, Fenced, Fruit/Nut Trees, Garden Area
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Existing RV Parking, Work/Shop Area
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Pasture
APN
027 031 035 000
School District
Chowchilla
School Type 1
High School
School Name 1
Chowchilla
School Type 2
Junior High School
School Name 2
Wilson
School Type 3
Grade School
School Name 3
Chowchilla Schools
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 570000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 630000 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) >= 1095 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1595 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` = 1754573 OR `props-main`.`id` = 1747527 OR `props-main`.`id` = 1749062 OR `props-main`.`id` = 1725916 OR `props-main`.`id` = 1731373 OR `props-main`.`id` = 1714020 OR `props-main`.`id` = 1696749 OR `props-main`.`id` = 1636375 OR `props-main`.`id` = 1750349 OR `props-main`.`id` = 1666061 OR `props-main`.`id` = 1729032 OR `props-main`.`id` = 1758255 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` = 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` = 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` = 1735557 OR `props-main`.`id` = 1744848 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1741743 OR `props-main`.`id` = 1749419 OR `props-main`.`id` = 1754701 OR `props-main`.`id` = 1754711 OR `props-main`.`id` = 1732730 OR `props-main`.`id` = 1732657 OR `props-main`.`id` = 1732699 OR `props-main`.`id` = 1727062 OR `props-main`.`id` = 1727191 OR `props-main`.`id` = 1727545 OR `props-main`.`id` = 1723311 OR `props-main`.`id` = 1744915 OR `props-main`.`id` = 1741745 OR `props-main`.`id` = 1741698)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649429' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-05' 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
Last modified 4 hours ago Fresno MLS last checked for updates 1 minute 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.
