Your Ultimate Equestrian Dream Estate AwaitsStep into luxury country living with this pristine, move-in-ready 15-acre horse property designed for both equine excellence and effortless entertaining. Nestled beneath 60 majestic, shade-providing oak trees, this park-like sanctuary combines top-tier functionality with resort-style relaxation. This prime property is only 20 minutes from Clovis but a world away with cooler evenings and peace and tranquility. Only 35 minutes to Shaver Lake ....or head up the hill further skiing and beautiful Huntington Lake....take your horses to any of these paradises for a nice ride!The ResidenceSpacious Living: Impeccably maintained 3-bedroom, 2-bathroom home featuring a bright open-concept layout and pristine finishes. Many windows to enjoy views out of each one.Primary Retreat: Unwind in the Large primary suite complete with a luxurious jacuzzi soaking tub, huge walkin closet and double headed oversize shower !Modern Upgrades: Enjoy complete peace of mind with a newly installed roof and zero electricity bills for the home thanks to fully covered solar as per seller.Convenience & Cleanliness: Attached 3-car garage, dual electric entry gates, and extensive concrete and pavement surrounds keeping the grounds impeccably tidy.Equestrian ParadisePrime Barn Setup: 6 oversized stalls with spacious runs, paired with a massive hay barn, a dedicated tack room, and a professional wash station.Training Hub: Fully equipped riding arena and automated horse walker that needs repaired and then ready for daily conditioning.Safe Pastures: 5 separate, well-maintained pastures featuring built-in canopies, individual feeders and water.Top-Tier Fencing: Premium no-climb pipe fencing throughout with zero barbed wire, ensuring ultimate safety for your horses.Resort-Style EntertainingOasis Pool: Sparkling swimming pool accented by a stunning rock waterfall, surrounded by professional landscaping.Versatile Pool House: Flexible space ideal for a private guest house, remote home office, or poolside lounge.Outdoor Living: Expansive covered porches framing breathtaking, panoramic sunset views that are second to none.A rare turnkey masterpiece where luxury meets functionality. Bring your horses and start living the dream today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1987
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$399
Price Per Acre
$57,776
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
on Loper Valley /Nicholas
Directions
With my phone I have to put 20100 Loper Valley to get directions Home is located on Loper valley rd less than one mile and on the Left
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 854050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 943950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2004 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2504 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` = 1774442 OR `props-main`.`id` = 1704706 OR `props-main`.`id` = 1704721 OR `props-main`.`id` = 1745183 OR `props-main`.`id` = 1726296 OR `props-main`.`id` = 1722004)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655079' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-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
Last modified 1 hour ago Fresno MLS last checked for updates 55 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.
