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/crmls/ML81909981/8831-E-Herndon-Ave/Clovis/https://www.londonproperties.com/images/props/crmls/full/ML81909981.jpgLondon Properties Clovis Real Estate | 8831 E Herndon Ave
Listing Agent: Jesse Rivera, eXp Realty of California Inc Listing Co-Agent: Viviana Gunter, eXp Realty of California Inc
Great opportunity to own approximate 5 acres plus a home near to Clovis community hospital. Bring your creativity and enjoy this lovely remodeled home ready to move in. 3 bedrooms 2 bathrooms with 1468 sf of living space and lots of possibilities.
Property Sub Type
Single Family Residence
Year Built
1966
Year Built Source
Other
Special Listing Conditions
Standard
Price Per Square Foot
$416
Days On Market
1156
County Or Parish
Fresno
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Heading east on Herndon, pass Highland and gate to enter is located on you right. When enter the gate, drive down drive way and the house is located in the back. Cross Street: Herndon/McCall
Heating
Central
Cooling
Central Air
Roof
Composition
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Water Source
Well
Sewer
Conventional Septic
Parking Y/N
Yes
Parking Features
Other
Attached Garage Y/N
No
Lot Size Area
215800.0000
Lot Size Units
Square Feet
Parcel Number
30828009
Zoning
RR5
Association Y/N
No
High School District
Clovis Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 579500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 640500 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) >= 1218 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1718 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` = 1691902 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1697296 OR `props-main`.`id` = 1696054 OR `props-main`.`id` = 1696106 OR `props-main`.`id` = 1696107 OR `props-main`.`id` = 1696118 OR `props-main`.`id` = 1696331 OR `props-main`.`id` = 1683147 OR `props-main`.`id` = 1697445 OR `props-main`.`id` = 1691563 OR `props-main`.`id` = 1688081 OR `props-main`.`id` = 1696918 OR `props-main`.`id` = 1689644 OR `props-main`.`id` = 1695519 OR `props-main`.`id` = 1686335 OR `props-main`.`id` = 1693978 OR `props-main`.`id` = 1689264 OR `props-main`.`id` = 1694905 OR `props-main`.`id` = 1695993 OR `props-main`.`id` = 1695988 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1697401 OR `props-main`.`id` = 1681441 OR `props-main`.`id` = 1682126 OR `props-main`.`id` = 1694595 OR `props-main`.`id` = 1695187 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1689255 OR `props-main`.`id` = 1684221 OR `props-main`.`id` = 1691432 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1638338 OR `props-main`.`id` = 1687108 OR `props-main`.`id` = 1687047 OR `props-main`.`id` = 1691378 OR `props-main`.`id` = 1693364 OR `props-main`.`id` = 1690806 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1678915 OR `props-main`.`id` = 1696270 OR `props-main`.`id` = 1695858 OR `props-main`.`id` = 1686178)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81909981' 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();
1
Similar Properties
$610,000
3
2
1,468
4.95
8831 E Herndon Ave
Clovis, CA 93619
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.
