Prepare to be impressed! Stunning family home situated in a cul-de-sac in a prime Clovis location. Upon arrival the lush landscaping and charm show that pride of ownership is apparent. As you enter you have a large living room with plenty of windows allowing plenty of natural light. Down the way you have an open concept offering a family room with a fireplace and a wall of windows. The well appointed kitchen offers an abundance of cabinetry, gas range, pantry and an island with prep-sink. Off the kitchen enjoy friends and family in the dining area. As you make your way down the hall you have 3 nice size bedrooms 2 bathrooms 2 of the bedrooms adjoin by the Jack and Jill bathroom which has dual sinks. The primary bedroom with spa-like en-suite showcases separate tub and shower and dual vanities. There's an indoor laundry room with sink and built-in cabinetry which adds to the amenities this home has to offer. Out back you can entertain in your own PRIVATE OASIS equipped with a sparkling salt water beach entry pool, covered patio and quaint sitting area to relax and enjoy! On the side yard you have TRUE RV PARKING with clean-outs and a large storage shed. An attached 3 car garage and extra large driveway can accommodate all of the toys! Conveniently located close to a neighborhood park, shopping and restaurants makes this truly a wonderful place to call home. If you're looking for convenience, luxury and amenities, this is it. Schedule your appointment today before it's gone!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2003
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$315
Price Per Acre
$2,174,797
Days On London
31
Cumulative Days On London
31
County
Fresno
REO / Bank Owned
No
Cross Street Address
Fowler
Directions
From Fowler and Gettysburg make a left, right on Burl, right on Ashcroft and property is on the right.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 711550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 786450 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) >= 2128 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2628 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` = 1726887 OR `props-main`.`id` = 1723455 OR `props-main`.`id` = 1720617 OR `props-main`.`id` = 1723009 OR `props-main`.`id` = 1723017 OR `props-main`.`id` = 1723021 OR `props-main`.`id` = 1666305 OR `props-main`.`id` = 1722067 OR `props-main`.`id` = 1722406 OR `props-main`.`id` = 1726253 OR `props-main`.`id` = 1721611 OR `props-main`.`id` = 1698022 OR `props-main`.`id` = 1723930 OR `props-main`.`id` = 1701402 OR `props-main`.`id` = 1724536 OR `props-main`.`id` = 1723929 OR `props-main`.`id` = 1691985 OR `props-main`.`id` = 1706044 OR `props-main`.`id` = 1716680 OR `props-main`.`id` = 1712847 OR `props-main`.`id` = 1724554 OR `props-main`.`id` = 1726128 OR `props-main`.`id` = 1698500 OR `props-main`.`id` = 1718981 OR `props-main`.`id` = 1709801 OR `props-main`.`id` = 1717880 OR `props-main`.`id` = 1724490 OR `props-main`.`id` = 1724431 OR `props-main`.`id` = 1724489 OR `props-main`.`id` = 1729141 OR `props-main`.`id` = 689708 OR `props-main`.`id` = 1721935 OR `props-main`.`id` = 1718737 OR `props-main`.`id` = 1654721 OR `props-main`.`id` = 1728130 OR `props-main`.`id` = 1724303 OR `props-main`.`id` = 1720336 OR `props-main`.`id` = 1719825 OR `props-main`.`id` = 1725333 OR `props-main`.`id` = 1727759 OR `props-main`.`id` = 232301 OR `props-main`.`id` = 1716621 OR `props-main`.`id` = 1729294 OR `props-main`.`id` = 1724029 OR `props-main`.`id` = 1721007 OR `props-main`.`id` = 1720939 OR `props-main`.`id` = 1720441 OR `props-main`.`id` = 1727395 OR `props-main`.`id` = 1728695 OR `props-main`.`id` = 1720539 OR `props-main`.`id` = 1720579 OR `props-main`.`id` = 1727206 OR `props-main`.`id` = 1726174 OR `props-main`.`id` = 1721280 OR `props-main`.`id` = 1725104 OR `props-main`.`id` = 1728279 OR `props-main`.`id` = 1713979 OR `props-main`.`id` = 1718460 OR `props-main`.`id` = 1721485 OR `props-main`.`id` = 1715821 OR `props-main`.`id` = 1714840 OR `props-main`.`id` = 1727840 OR `props-main`.`id` = 1718819 OR `props-main`.`id` = 1714072 OR `props-main`.`id` = 1711394 OR `props-main`.`id` = 1726762 OR `props-main`.`id` = 1721640 OR `props-main`.`id` = 1727147 OR `props-main`.`id` = 1715621 OR `props-main`.`id` = 1724668 OR `props-main`.`id` = 1708412 OR `props-main`.`id` = 1728965 OR `props-main`.`id` = 1728974 OR `props-main`.`id` = 1726021 OR `props-main`.`id` = 180610 OR `props-main`.`id` = 1728083 OR `props-main`.`id` = 1726013 OR `props-main`.`id` = 1725911 OR `props-main`.`id` = 1728326 OR `props-main`.`id` = 1701755 OR `props-main`.`id` = 1725804 OR `props-main`.`id` = 235509 OR `props-main`.`id` = 1718828 OR `props-main`.`id` = 1719384 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1728529 OR `props-main`.`id` = 1727004 OR `props-main`.`id` = 1729817 OR `props-main`.`id` = 1727068 OR `props-main`.`id` = 1722446 OR `props-main`.`id` = 1707114 OR `props-main`.`id` = 1700214 OR `props-main`.`id` = 1698700 OR `props-main`.`id` = 1700216 OR `props-main`.`id` = 1712804 OR `props-main`.`id` = 1722354 OR `props-main`.`id` = 1722227 OR `props-main`.`id` = 1727677 OR `props-main`.`id` = 1725096 OR `props-main`.`id` = 1716978 OR `props-main`.`id` = 1729227 OR `props-main`.`id` = 1721089 OR `props-main`.`id` = 1718751 OR `props-main`.`id` = 1697079 OR `props-main`.`id` = 1716655 OR `props-main`.`id` = 1716157 OR `props-main`.`id` = 1729312 OR `props-main`.`id` = 1722529 OR `props-main`.`id` = 1724532 OR `props-main`.`id` = 1725806 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1713121 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1717580 OR `props-main`.`id` = 1718093 OR `props-main`.`id` = 1722918 OR `props-main`.`id` = 1709456 OR `props-main`.`id` = 1720741 OR `props-main`.`id` = 1726250 OR `props-main`.`id` = 1715629 OR `props-main`.`id` = 1719118 OR `props-main`.`id` = 1721788 OR `props-main`.`id` = 1725303 OR `props-main`.`id` = 1697275 OR `props-main`.`id` = 1721031 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1728339 OR `props-main`.`id` = 1728168 OR `props-main`.`id` = 1717844 OR `props-main`.`id` = 1727496 OR `props-main`.`id` = 1718568 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1727125 OR `props-main`.`id` = 1726920 OR `props-main`.`id` = 1723088 OR `props-main`.`id` = 1721948 OR `props-main`.`id` = 1728341 OR `props-main`.`id` = 1728340 OR `props-main`.`id` = 1725836 OR `props-main`.`id` = 1725880 OR `props-main`.`id` = 1720527 OR `props-main`.`id` = 1728554 OR `props-main`.`id` = 1707233 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1717166 OR `props-main`.`id` = 1728924 OR `props-main`.`id` = 1727061 OR `props-main`.`id` = 1703700 OR `props-main`.`id` = 1721724 OR `props-main`.`id` = 1718677 OR `props-main`.`id` = 1715688 OR `props-main`.`id` = 1726529 OR `props-main`.`id` = 1717400 OR `props-main`.`id` = 1724473 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1685150 OR `props-main`.`id` = 1721535 OR `props-main`.`id` = 1721541 OR `props-main`.`id` = 1721492 OR `props-main`.`id` = 1727133 OR `props-main`.`id` = 1728886 OR `props-main`.`id` = 1728874 OR `props-main`.`id` = 1728877 OR `props-main`.`id` = 1728899 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 1702478 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1720830 OR `props-main`.`id` = 1728346 OR `props-main`.`id` = 1721860)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647375' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-29' 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 Robin Sparks, Better Homes & Garden Real Estate GoldLeaf - [email protected] Last modified 1 week ago Fresno MLS last checked for updates 13 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.
