Welcome to your private country retreat in Cumorah Knolls! This fully updated 4-bedroom, 2.25-bath home sits on 2.34 acres of beautifully manicured grounds, complete with fruit trees and mature landscaping. The standout feature of this property is the 6-car garage setup, including a 3-car garage with a drive-thru RV barn and a detached 3-car garage/shop, perfect for car lovers or hobbyists. Inside, the home offers spacious living with hardwood floors, a large kitchen with stainless steel appliances, granite countertops, and a cozy Great Room with a pellet stove for those winter nights and a fully enclosed sunroom with AC unit. The isolated 4th bedroom is ideal for an office or in-law suite or office. The primary suite includes a luxurious on-suite with a freestanding tub, shower, and double sinks and a large closet with custom built in cabinetry. The fenced pasture is perfect for livestock, and the peaceful neighborhood offers bridal paths for outdoor activities. There arebridal paths throughout this community. Schedule your private showing today to see all this home has to offer!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 831250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 918750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2308 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2808 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` = 1691010 OR `props-main`.`id` = 1683540 OR `props-main`.`id` = 1683530 OR `props-main`.`id` = 1696179 OR `props-main`.`id` = 1690250 OR `props-main`.`id` = 1666026 OR `props-main`.`id` = 1665864 OR `props-main`.`id` = 656330 OR `props-main`.`id` = 1671669 OR `props-main`.`id` = 1697377 OR `props-main`.`id` = 1693969 OR `props-main`.`id` = 1693765 OR `props-main`.`id` = 1689269 OR `props-main`.`id` = 1697248 OR `props-main`.`id` = 1692074 OR `props-main`.`id` = 1700063 OR `props-main`.`id` = 1664638 OR `props-main`.`id` = 1701843 OR `props-main`.`id` = 1695727 OR `props-main`.`id` = 1660897 OR `props-main`.`id` = 1660904 OR `props-main`.`id` = 1702225 OR `props-main`.`id` = 1686722 OR `props-main`.`id` = 1691531 OR `props-main`.`id` = 1697919 OR `props-main`.`id` = 1665976 OR `props-main`.`id` = 1687662 OR `props-main`.`id` = 1659285)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640921' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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
Courtesy of Beth Garcia, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 53 minutes 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.
