Courtesy of Lisa Garver, Realty Concepts, Ltd. - Fresno - [email protected]
Welcome to your own private retreat on 2.4 fully fenced acres, tucked away at the end of a cul-de-sac featuring a private, gated entrance. Located within the award-winning Clovis Unified School District, this impressive modern farmhouse blends style, comfort, and functionality, featuring soaring vaulted ceilings in both the main living area and primary bedroom. A versatile bonus room within the home offers additional flexible space to suit your needs, whether for a home office, hobby room, fitness space, or an additional living area. Fully owned free standing solar adds energy-conscious appeal, while two wells serve the property, one supplying the home and property with the other dedicated to the private, fish-stocked pond. Step outside to discover an outdoor oasis designed for relaxation and entertaining, featuring an enclosed backyard with a pool, multiple entertaining areas, grass area and a new spa. The possibilities continue with a shop featuring an attached office/bonus room, gated raised garden beds, kennels, and fenced animal enclosures, offering versatility for a variety of lifestyle needs. A spacious three-car garage with epoxy flooring adds convenience and a polished finish. With numerous recent upgrades throughout, this exceptional property offers a rare combination of modern farmhouse charm, outdoor recreation, gardening opportunities, room for animals, and functional amenities. Enjoy space, privacy, and a distinctive country lifestyle with an impressive array of features that make this property truly special!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1986
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$440
Price Per Acre
$458,333
Days On London
0
Cumulative Days On London
0
County
Fresno
Reports Available
NHD, Prelim Title Report
Special Features
Security System, Security Gate, Built In Cabinets, Wet/Dry Bar, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Bullard McCall
Directions
From Herndon, turn south on McCall, L on Bullard, L Constellation, L Forrestal. Home is at the end of the cul de sac on the right.
Heating & Cooling
Central Heat & Cool, Whole House Fan
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop, Kennel, Shed
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1045000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1155000 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) >= 2252 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2752 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` = 232981 OR `props-main`.`id` = 1748850 OR `props-main`.`id` = 1789329 OR `props-main`.`id` = 1778396 OR `props-main`.`id` = 1785778 OR `props-main`.`id` = 1746688 OR `props-main`.`id` = 1790058 OR `props-main`.`id` = 1785164 OR `props-main`.`id` = 1770749 OR `props-main`.`id` = 1781368 OR `props-main`.`id` = 1774611 OR `props-main`.`id` = 1755032 OR `props-main`.`id` = 1727388 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1784276 OR `props-main`.`id` = 1773163 OR `props-main`.`id` = 1756357 OR `props-main`.`id` = 1746401 OR `props-main`.`id` = 1786771)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656702' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-15' 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 1 hour ago Fresno MLS last checked for updates 24 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.
