Move-In Ready Family Home in a Great Neighborhood!You'll fall in love with this beautifully remodeled 4-bed, 2-bath home in a safe, family-friendly neighborhood. From the moment you walk in, you'll notice the warm, open feel and thoughtful updates throughout.The kitchen is a dream, featuring butcher block countertops perfect for cooking family meals or entertaining friends. The bathrooms are freshly updated, and every room feels bright, comfortable, and inviting. New fence and potential RV parking.Outside, enjoy quiet streets, friendly neighbors, and easy access to nearby parks and schools. Everything's been done for you just move in, unpack, and start making memories!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1977
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$260
Price Per Acre
$2,799,771
Days On London
184
Cumulative Days On London
184
County
Fresno
REO / Bank Owned
No
Cross Street Address
Fowler / Bullard
Directions
East of Fowler, north of Bullard. N/E corner of those roads.
Heating & Cooling
Central Heat & Cool, Whole House Fan
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Electric Appliances, Disposal, Dishwasher, Microwave
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 463600 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 512400 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1624 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2124 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` = 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` = 1716978 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` = 1722529 OR `props-main`.`id` = 1724532 OR `props-main`.`id` = 1722862 OR `props-main`.`id` = 1713121 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 1724529 OR `props-main`.`id` = 1724528 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1717580 OR `props-main`.`id` = 1718093 OR `props-main`.`id` = 1721673 OR `props-main`.`id` = 1722918 OR `props-main`.`id` = 1709456 OR `props-main`.`id` = 1705309 OR `props-main`.`id` = 1720741 OR `props-main`.`id` = 1726250 OR `props-main`.`id` = 1721788 OR `props-main`.`id` = 1725303 OR `props-main`.`id` = 1697275 OR `props-main`.`id` = 1696835 OR `props-main`.`id` = 1721031 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1717844 OR `props-main`.`id` = 1718568 OR `props-main`.`id` = 1718053 OR `props-main`.`id` = 1718060 OR `props-main`.`id` = 1718054 OR `props-main`.`id` = 1709218 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` = 1692117 OR `props-main`.`id` = 1725836 OR `props-main`.`id` = 1725880 OR `props-main`.`id` = 1720527 OR `props-main`.`id` = 1707233 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1717166 OR `props-main`.`id` = 1717180 OR `props-main`.`id` = 1717194 OR `props-main`.`id` = 1727061 OR `props-main`.`id` = 1703700 OR `props-main`.`id` = 1726743 OR `props-main`.`id` = 1721724 OR `props-main`.`id` = 1711200 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` = 1712341 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 1702478 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1700881 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1720830 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1721860 OR `props-main`.`id` = 1718789 OR `props-main`.`id` = 1724677 OR `props-main`.`id` = 1724667 OR `props-main`.`id` = 1726398 OR `props-main`.`id` = 1726287 OR `props-main`.`id` = 1721120 OR `props-main`.`id` = 1726840 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1723006 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1718249 OR `props-main`.`id` = 1718246 OR `props-main`.`id` = 1723835 OR `props-main`.`id` = 1723817 OR `props-main`.`id` = 1725062 OR `props-main`.`id` = 1724803 OR `props-main`.`id` = 1722482 OR `props-main`.`id` = 1721879 OR `props-main`.`id` = 1724299 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1724886 OR `props-main`.`id` = 1726022 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1723559 OR `props-main`.`id` = 1723131 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1727349 OR `props-main`.`id` = 1721072)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639972' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-17' 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();
5
Similar Properties
$499,000
4
2
1,693
0.27
210 N Sunnyside Ave
Clovis, CA 93611
$495,000
5
2
2,014
0.24
1488 Whittier Ave
Clovis, CA 93611
$470,000
4
2
2,121
0.18
2549 Purvis Ave
Clovis, CA 93611
$469,900
4
1.75
1,650
0.20
1668 Bedford Ave
Clovis, CA 93611
Courtesy of Christopher Bilbo, London Properties, Ltd. - [email protected] Last modified 2 days 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.
