This home offers a multi-generational setup with the common area being the kitchen as the focal point. French doors offer separation of two living spaces while still having an open flow of the home as one residence.divbr/divdivspan style=''font-size:'' 10pt;=''''Enjoy the convenience of a four car garage, a spacious heavy equipment port connected to a 40x18 workshop that consist of 6ft roll-up doors./span/divdivThis is an expectational opportunity to own a home and acreage with limitless potential to shape and enjoy./divdivbr/divdivThis 2.26 acre lot is a country living experience with an oasis-like retreat, complete with a pool and spa for those hot summer days./div
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 783750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 866250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2890 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3390 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` = 1671188 OR `props-main`.`id` = 1671191 OR `props-main`.`id` = 1671194 OR `props-main`.`id` = 1694795 OR `props-main`.`id` = 1694743 OR `props-main`.`id` = 1674009 OR `props-main`.`id` = 1692418 OR `props-main`.`id` = 1693555 OR `props-main`.`id` = 1693531 OR `props-main`.`id` = 1666359 OR `props-main`.`id` = 1687635 OR `props-main`.`id` = 1696184 OR `props-main`.`id` = 1696187 OR `props-main`.`id` = 1674617 OR `props-main`.`id` = 1695987 OR `props-main`.`id` = 1687374 OR `props-main`.`id` = 1693466 OR `props-main`.`id` = 1687295 OR `props-main`.`id` = 1692551 OR `props-main`.`id` = 1656886 OR `props-main`.`id` = 1696085 OR `props-main`.`id` = 1668912 OR `props-main`.`id` = 1696809 OR `props-main`.`id` = 1650126)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637697' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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();
1
Similar Properties
$830,000
5
4
3,176
2.25
17324 17328 Bonita Rd
Madera, CA 93636
Courtesy of Miguel Munoz, Laber Enterprises - [email protected] Last modified 5 days 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.
