Courtesy of Nathan Yoder, London Properties, Ltd. - [email protected]
Country Living Awaits! Discover the possibilities of nearly 6 acres surrounding this spacious 3-bedroom, 2.5-bathroom home offering nearly 3,500 square feet of living space. Designed for comfortable living and entertaining, the main home features both a generous family room and separate living room, each highlighted by its own fireplace. The formal dining room overlooks the beautifully landscaped backyard and sparkling in-ground pool, creating an inviting setting for gatherings.The well-appointed kitchen offers a large center island, abundant counter space, a convenient eat-in area, and a brand-new cooktop. Down the hallway are three bedrooms, including a recently renovated primary suite featuring an oversized walk-in closet and luxurious soaking tub. A spacious laundry room and access to the recently added covered carport add convenience.Additional living and workspace options abound with a versatile loft above the main entrance---ideal for a home office, playroom, media room, or hobby space. Owned solar adds energy-saving potential. The property continues to impress with a detached garage featuring a work bench and full bathroom. Above the garage is a studio apartment, offering excellent flexibility as an ADU, guest quarters, home office, or potential income-producing space. Outside, a large sport court provides room for basketball, volleyball, pickleball, and more. A separate kennel/livestock building offers additional storage and space for animals or hobby use.If you've dreamed of having room to spread out, space for children to play, a pool for summer enjoyment, and acreage with the flexibility to accommodate animals, hobbies, recreation, and future projects, this unique property provides an exceptional canvas for your country living vision. Bring your ideas and make this special property your own!
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) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3220 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3720 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` = 1776899 OR `props-main`.`id` = 274621 OR `props-main`.`id` = 849021 OR `props-main`.`id` = 1759514 OR `props-main`.`id` = 1771225 OR `props-main`.`id` = 1762285 OR `props-main`.`id` = 1780029 OR `props-main`.`id` = 1785675 OR `props-main`.`id` = 1764744 OR `props-main`.`id` = 1764044 OR `props-main`.`id` = 656330 OR `props-main`.`id` = 232981 OR `props-main`.`id` = 1748850 OR `props-main`.`id` = 1778396 OR `props-main`.`id` = 1785778 OR `props-main`.`id` = 1746688 OR `props-main`.`id` = 1748240 OR `props-main`.`id` = 1733748 OR `props-main`.`id` = 1770749 OR `props-main`.`id` = 1785710 OR `props-main`.`id` = 1774611 OR `props-main`.`id` = 1755032 OR `props-main`.`id` = 1727388 OR `props-main`.`id` = 1784276 OR `props-main`.`id` = 1756357 OR `props-main`.`id` = 1746401)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655986' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-02' 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 3 hours ago Fresno MLS last checked for updates 46 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.
