Please provide the following information and Lillian Frankian will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.lilfrankian.com/agent/14897/lillian-frankian/property/link/crmls/ML81909981/8831-E-Herndon-Ave/Clovis/https://www.lilfrankian.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 London
1323
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
72870
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` = 1727154 OR `props-main`.`id` = 1708280 OR `props-main`.`id` = 1702248 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1722052 OR `props-main`.`id` = 1715630 OR `props-main`.`id` = 1713841 OR `props-main`.`id` = 1718201 OR `props-main`.`id` = 1718498 OR `props-main`.`id` = 1700151 OR `props-main`.`id` = 1718090 OR `props-main`.`id` = 1725534 OR `props-main`.`id` = 1726630 OR `props-main`.`id` = 1718456 OR `props-main`.`id` = 1727108 OR `props-main`.`id` = 1718959 OR `props-main`.`id` = 1705332 OR `props-main`.`id` = 1727762 OR `props-main`.`id` = 1727761 OR `props-main`.`id` = 1727767 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1728924 OR `props-main`.`id` = 1721724 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1730582 OR `props-main`.`id` = 1730587 OR `props-main`.`id` = 1700055 OR `props-main`.`id` = 1724473 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1728724 OR `props-main`.`id` = 1729337 OR `props-main`.`id` = 1712341 OR `props-main`.`id` = 1720270 OR `props-main`.`id` = 1718239 OR `props-main`.`id` = 1700881 OR `props-main`.`id` = 1724858 OR `props-main`.`id` = 1727388 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1726080 OR `props-main`.`id` = 1719303 OR `props-main`.`id` = 1719304 OR `props-main`.`id` = 1727983 OR `props-main`.`id` = 1726822 OR `props-main`.`id` = 1727962 OR `props-main`.`id` = 1726680)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81909981' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-01' 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.