Welcome home to your very own slice of paradise! This truly amazing property checks off every single box on your wish list. The perfect family floor plan with the owner's suite on the main level complimented by either an adjoining office, TV area, gym or perfect babies' nursery. There are 2 additional bedrooms on the main level and 2 upstairs. Plenty of elbow room for the whole family to spread out across 3 distinct living spaces; formal living, family room and an upstairs bonus room with a huge balcony. Whether you are raising a large family or just love to host friends, this layout is absolutely ideal. Tucked away on a quiet cul de sac, the home exudes a peaceful country feel, yet you are minutes from conveniences like the grocery store, restaurants, the gym and school. Perhaps the most breathtaking feature is the park like setting situated on your own private lake! The ambiance is taken to the next level by the soothing sounds of a waterfall at the lake and a shelf spillway flowing from spa to pool. This special 2 acre estate is shaded by mature trees and lush grass areas, all surrounding a newly rebuilt pool and spa with beautiful updated hardscape. Ample room for parking, incredible storage, and a prime location within CUSD this home offers 5 dedicated bedrooms, and a 6th if needed. This is the one you have been waiting for! Bath count differs from tax records. Buyer to verify.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1984
Region
Urban
# of Stories
Two
Price Per Square Foot
$417
Price Per Acre
$883,085
Days On London
23
Cumulative Days On London
23
County
Fresno
Reports Available
Pest
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets, Wet/Dry Bar, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Shepherd/Temperance
Directions
From the intersection of Temperance and Shepherd head south. Left on Heritage. Property will be on your left.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1686250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1863750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4007 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4507 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` = 1703999 OR `props-main`.`id` = 1714983 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1718676 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1714009 OR `props-main`.`id` = 1720522 OR `props-main`.`id` = 1719566 OR `props-main`.`id` = 1704367 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1717159 OR `props-main`.`id` = 1719854 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1716972 OR `props-main`.`id` = 1718254 OR `props-main`.`id` = 1712495 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1713847 OR `props-main`.`id` = 1716845 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1689212 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1715990 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1707196 OR `props-main`.`id` = 1710090 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1705677 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1709935 OR `props-main`.`id` = 1716627 OR `props-main`.`id` = 1717197 OR `props-main`.`id` = 1717456 OR `props-main`.`id` = 1717420 OR `props-main`.`id` = 1717431 OR `props-main`.`id` = 1717440 OR `props-main`.`id` = 1715709 OR `props-main`.`id` = 1719684 OR `props-main`.`id` = 1681726 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1712677 OR `props-main`.`id` = 1713049 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1715897 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 1708087 OR `props-main`.`id` = 1703958 OR `props-main`.`id` = 1716028 OR `props-main`.`id` = 1719778 OR `props-main`.`id` = 1719773 OR `props-main`.`id` = 1719777 OR `props-main`.`id` = 1719779 OR `props-main`.`id` = 1719786 OR `props-main`.`id` = 1719769 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1719770 OR `props-main`.`id` = 1719785 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1708311 OR `props-main`.`id` = 1719767 OR `props-main`.`id` = 1719784 OR `props-main`.`id` = 1719787 OR `props-main`.`id` = 1719768 OR `props-main`.`id` = 1719793 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1719791 OR `props-main`.`id` = 1719792 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1719790 OR `props-main`.`id` = 1719783 OR `props-main`.`id` = 1719780 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1719782 OR `props-main`.`id` = 1719788 OR `props-main`.`id` = 1719789 OR `props-main`.`id` = 1719771 OR `props-main`.`id` = 1718323 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1719772 OR `props-main`.`id` = 1720316 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645066' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-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 Danyelle Conner, London Properties, Ltd. - [email protected] Last modified 2 weeks 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.
