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/ML81908973/8831-E-Herndon-Ave/Clovis/https://www.londonproperties.com/images/props/crmls/full/ML81908973.jpgLondon Properties Clovis Real Estate | 8831 E Herndon Ave
Listing Agent: Viviana Gunter, eXp Realty of California Inc Listing Co-Agent: Jesse Rivera, eXp Realty of California Inc
Lovely remodeled 3 bedroom 2 bathroom home ready to move in. New kitchen and bathroom granite countertops, renovated cabinets. Air conditioner and ceiling fans. There is a detached 2 car carport with 2 big storages on the side, permits unknown. Almost 5 acres of land, perfect for country life with endless possibilities. Don't miss the opportunity to leave close to shopping, restaurants, Community Medical Center and freeway access.
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
1224
County Or Parish
Fresno
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
No
Directions
Cross Street: North Highland Ave
Cooling
None
Roof
Composition
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Room Kitchen Features
Granite Counters
Appliances Y/N
Yes
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Wood Burning
Water Source
Well
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` = 1708280 OR `props-main`.`id` = 1691902 OR `props-main`.`id` = 1701422 OR `props-main`.`id` = 1702248 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1704253 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1700151 OR `props-main`.`id` = 1706998 OR `props-main`.`id` = 1707001 OR `props-main`.`id` = 1707021 OR `props-main`.`id` = 1707947 OR `props-main`.`id` = 1700937 OR `props-main`.`id` = 1707007 OR `props-main`.`id` = 1703867 OR `props-main`.`id` = 1697445 OR `props-main`.`id` = 1707230 OR `props-main`.`id` = 1700213 OR `props-main`.`id` = 1700211 OR `props-main`.`id` = 1709269 OR `props-main`.`id` = 1704799 OR `props-main`.`id` = 1702303 OR `props-main`.`id` = 1705332 OR `props-main`.`id` = 1705997 OR `props-main`.`id` = 1703521 OR `props-main`.`id` = 1693978 OR `props-main`.`id` = 1703915 OR `props-main`.`id` = 1694905 OR `props-main`.`id` = 1695993 OR `props-main`.`id` = 1695988 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1704945 OR `props-main`.`id` = 1705574 OR `props-main`.`id` = 1710213 OR `props-main`.`id` = 1700055 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1700881 OR `props-main`.`id` = 1711280 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1691378 OR `props-main`.`id` = 1710688 OR `props-main`.`id` = 1704367 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1696270 OR `props-main`.`id` = 1707196 OR `props-main`.`id` = 1704072 OR `props-main`.`id` = 1705677)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81908973' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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.
