Please provide the following information and Lorelei Van Sack will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.loreleisellshomes.com/agent/20413/lorelei-vansack/property/link/crmls/ML81908973/8831-E-Herndon-Ave/Clovis/https://www.loreleisellshomes.com/images/props/crmls/full/ML81908973.jpgLondon Properties Clovis Real Estate | 8831 E Herndon Ave
Lorelei Van Sack559.826.8808lvansack@londonproperties.comEmail Agent
Property Description
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 Market
1138
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` = 1695565 OR `props-main`.`id` = 1691902 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1677279 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` = 1691563 OR `props-main`.`id` = 1688081 OR `props-main`.`id` = 1691901 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` = 1694402 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` = 1693867 OR `props-main`.`id` = 1684221 OR `props-main`.`id` = 1693671 OR `props-main`.`id` = 1678591 OR `props-main`.`id` = 1678544 OR `props-main`.`id` = 1691432 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1638338 OR `props-main`.`id` = 1681190 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` = 1677157 OR `props-main`.`id` = 1678915 OR `props-main`.`id` = 1696270 OR `props-main`.`id` = 1695858 OR `props-main`.`id` = 1686178 OR `props-main`.`id` = 1690181)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81908973' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-30' 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.