Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/639094/12789-E-Herndon-Ave/Clovis/https://www.londonproperties.com/images/props/fresno/full/639094.jpgLondon Properties Clovis Real Estate | 12789 E Herndon Ave
Stunning 5 Bedroom Colonial Retreat on Nearly 5 Acres in ClovisWelcome to your private sanctuary in the heart of Clovis! This beautifully maintained 5 bedroom, 3 bathroom Colonial style home sits on just under 5 acres of lush, usable land, offering the perfect blend of elegance, functionality, and serene country living.Enter through a picturesque tree-lined driveway to your breathtaking view of your private pond and experience the charm of a property that's thoughtfully designed inside and out. Outdoors, you'll find everything you need for entertaining and relaxing: an equestrian-ready grazing pasture with horse setup, owned solar, sparkling pool and hot tub, and a gazebo with built-in gas fireplace, all framed by mature landscaping. Property features a recently installed well pump, pipe and control board.Inside, the spacious and well-appointed interior features an open-concept kitchen, formal dining room, temperature controlled wine cellar, and an expansive soundproof game room, perfect for movies, music, or entertaining guests. The primary suite offers a peaceful escape, while a versatile loft adds additional living or workspace flexibility. All 3 air conditioning units have been replaced in the last 3 years.Whether you're looking for multi-generational living, space to entertain, or a peaceful escape just minutes from Clovis conveniences, this exceptional estate checks every box.Don't miss your opportunity to own this rare Clovis gem! Schedule your private tour today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2000
Region
Rural
# of Stories
Two
Price Per Square Foot
$346
Price Per Acre
$295,699
Days On London
204
Cumulative Days On London
204
County
Fresno
Leased Equipment
Water Softener
REO / Bank Owned
No
Cross Street Address
Herndon/Academy
Directions
From herndon and Temperance head east on Herndon, home is 2nd to last house before Academy on the right hand side
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1306250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1443750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3722 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4222 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` = 1733748 OR `props-main`.`id` = 1728973 OR `props-main`.`id` = 1691531 OR `props-main`.`id` = 1659285 OR `props-main`.`id` = 1696541 OR `props-main`.`id` = 1694075)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639094' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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 weeks ago Fresno MLS last checked for updates 14 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.
