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/640183/8063-W-Herndon/Fresno/https://www.londonproperties.com/images/props/fresno/full/640183.jpgLondon Properties Fresno Real Estate | 8063 W Herndon
An exclusive opportunity to purchase a beautifully remodeled home on 2.00 acres situated near the City of Fresno. Enjoy country living while located within a few minutes of Fresno amenities, including the El Paseo shopping & entertainment center. The property is positioned on the bluff above the San Joaquin River and has easy access to north and south bound Highway 99. This exceptional property has many amazing features including a gated entry with a concrete circle driveway, pristine front & backyard landscaping with pool, spa & waterfalls, plus owned solar panels, to name a few. This home is perfect for entertaining. Call and book your showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1989
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$447
Price Per Acre
$637,500
Days On Market
53
Cumulative Days On Market
53
County
Fresno
Reports Available
Prelim Title Report
Special Features
Built In Cabinets, Wet/Dry Bar, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Parkway
Directions
Subject property is located on the west side of Highway 99 and 1 mile northwest of the intersection of Parkway Drive and Herndon Ave. The physical address is: 8063 W. Herndon Ave, Fresno CA 93723
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Other/See Remarks
Kitchen
F/S Range/Oven, Built In Range/Oven, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1211250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1338750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2600 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3100 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` = 1669960 OR `props-main`.`id` = 1684086 OR `props-main`.`id` = 1671895 OR `props-main`.`id` = 1691777 OR `props-main`.`id` = 1695427 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1679271 OR `props-main`.`id` = 1697235 OR `props-main`.`id` = 1689188 OR `props-main`.`id` = 1690254 OR `props-main`.`id` = 1695383 OR `props-main`.`id` = 1678847 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1695581 OR `props-main`.`id` = 1680198 OR `props-main`.`id` = 1680166 OR `props-main`.`id` = 1680181 OR `props-main`.`id` = 1685604 OR `props-main`.`id` = 1680195 OR `props-main`.`id` = 1680197 OR `props-main`.`id` = 1680164 OR `props-main`.`id` = 1686223 OR `props-main`.`id` = 1689071 OR `props-main`.`id` = 1697179 OR `props-main`.`id` = 1684407)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640183' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' 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
Courtesy of Dan Kevorkian, Pearson Realty - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 10 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.
