Experience the ultimate in luxury living in Clovis with almost 20 acres of stunning views and unparalleled amenities. Magnificent 4 bdrms 4 baths Elite custom estate is more than just a residence; it's a lifestyle where every day feels like a vacation. Step inside and enjoy scenic views from your expansive great room adorned with architectural elegance from dramatic arched wood windows to the wood doorways that will leave you in awe.Gourmet kitchen boasts high-end Viking cooktop, double oven, warming drawer, two Bosch dishwashers, SubZero separate refrigerator & freezer, and ultra-strong Nuage quartzite counters perfect for culinary creativity. Elegant formal dining room w/ a striking tray ceiling that imparts a unique personality and is perfect for family gatherings. Cozy up w/ a book in the exquisite wood-paneled library, an ideal retreat for quiet afternoons. Unwind w/ family movie nights in the media room, complete w/ a charming brick fireplace. Retreat to the impressive primary suite w/ ensuite bathroom featuring dual vanities, lavish soaking tub, and his/her walk-in closets. Each guest bdrm have spacious layouts. Indulge in the resort-style amenities that this home offers and imagine spending your days lounging by the infinity edge pool, cooking up a storm on the Teppan grill, perfecting your swing on the putting green, or getting a workout on the pickle ball court. Shop ready w/a 1600sq.ft.insul.barn,10ft.roll-up doors and large carport. Your family's dream home awaits!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1989
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$533
Price Per Acre
$103,414
Days On Market
141
Cumulative Days On Market
141
County
Fresno
Reports Available
Septic, Well, NHD
Special Features
Security Gate, Built In Cabinets, Wet/Dry Bar, Satellite Dish, Private Tennis Court
REO / Bank Owned
No
Cross Street Address
Tollhouse Road/ Sample Road
Directions
Tollhouse Road to Sample Road Pull up to Quail Oaks gate (code to be provided upon appt. confirmation) Follow Deer Path Lane to Coyote Pass Lane Pull up to 2nd gate (meet agent at 2nd gate)
Unit Description
Ground Floor
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room, On Lower Level
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop, Barn
Kitchen
Built In Range/Oven, Gas Appliances, Dishwasher, Microwave, Eating Area, Pantry, Refrigerator, Wine Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1899050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2098950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3500 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4000 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` = 1696036 OR `props-main`.`id` = 1687594 OR `props-main`.`id` = 1666084 OR `props-main`.`id` = 1651789)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno628574' 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();
0
Courtesy of Ann Lee, HomeSmart PV and Associates - [email protected] Last modified 3 months 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.
