Welcome to 4066 Buckingham Ave, Clovis a stunning Wilson model home in the highly sought-after Regent Park community.This spacious 5-bedroom, 4.25-bathroom residence offers a versatile floor plan perfect for multi-generational living with two primary suites one conveniently located downstairs and another upstairs.Inside, you'll find upgraded flooring, plush carpeting, designer tile, and a stylish kitchen backsplash that enhance the home's modern appeal. The chef's kitchen opens seamlessly to the living and dining areas, making it ideal for both entertaining and everyday living.The backyard is designed for gatherings, featuring a custom masonry fire pit that creates the perfect spot for relaxing evenings. The home also includes solar for energy efficiency.Located in the heart of Clovis, this property offers easy access to top-rated schools, shopping, dining, and parks.Don't miss your chance to own this beautifully upgraded, move-in ready home in Regent Park!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2019
Region
Urban
# of Stories
Two
Price Per Square Foot
$251
Price Per Acre
$6,690,141
Days On Market
1
Cumulative Days On Market
99
County
Fresno
REO / Bank Owned
No
Cross Street Address
Ashlan and Highland
Directions
Eastbound on Ashlan Ave, pass Leonard Ave, make a right on Soledad and left on Buckingham. Property is on the right hand side.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 722000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 798000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2774 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3274 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` = 272957 OR `props-main`.`id` = 1666323 OR `props-main`.`id` = 330635 OR `props-main`.`id` = 1648719 OR `props-main`.`id` = 1673057 OR `props-main`.`id` = 1666223 OR `props-main`.`id` = 1666296 OR `props-main`.`id` = 1683054 OR `props-main`.`id` = 1654721 OR `props-main`.`id` = 1677866 OR `props-main`.`id` = 232301 OR `props-main`.`id` = 1663860 OR `props-main`.`id` = 1676868 OR `props-main`.`id` = 1668271 OR `props-main`.`id` = 1653283 OR `props-main`.`id` = 1665949 OR `props-main`.`id` = 1683013 OR `props-main`.`id` = 1664303 OR `props-main`.`id` = 1671701 OR `props-main`.`id` = 1681480 OR `props-main`.`id` = 1673593 OR `props-main`.`id` = 1651389 OR `props-main`.`id` = 1651509 OR `props-main`.`id` = 1683825 OR `props-main`.`id` = 1663878 OR `props-main`.`id` = 1674523 OR `props-main`.`id` = 1680230 OR `props-main`.`id` = 1683685 OR `props-main`.`id` = 1660687 OR `props-main`.`id` = 1684462 OR `props-main`.`id` = 1679920 OR `props-main`.`id` = 1681188 OR `props-main`.`id` = 1650593 OR `props-main`.`id` = 1663256 OR `props-main`.`id` = 1663302 OR `props-main`.`id` = 1679678 OR `props-main`.`id` = 1681988 OR `props-main`.`id` = 1684393 OR `props-main`.`id` = 1620913 OR `props-main`.`id` = 1659141 OR `props-main`.`id` = 1675105 OR `props-main`.`id` = 1666705 OR `props-main`.`id` = 1679836 OR `props-main`.`id` = 1684632 OR `props-main`.`id` = 1680200 OR `props-main`.`id` = 1656511 OR `props-main`.`id` = 1679864 OR `props-main`.`id` = 274621 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1681900 OR `props-main`.`id` = 1663393 OR `props-main`.`id` = 1670841 OR `props-main`.`id` = 1683306 OR `props-main`.`id` = 1683282 OR `props-main`.`id` = 1678063 OR `props-main`.`id` = 1679558 OR `props-main`.`id` = 1671955 OR `props-main`.`id` = 1636728 OR `props-main`.`id` = 1636687 OR `props-main`.`id` = 1666079 OR `props-main`.`id` = 1671528 OR `props-main`.`id` = 1632386 OR `props-main`.`id` = 1682229 OR `props-main`.`id` = 1678443 OR `props-main`.`id` = 1666475 OR `props-main`.`id` = 1676865 OR `props-main`.`id` = 1667523 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 1683485 OR `props-main`.`id` = 232981 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1680740 OR `props-main`.`id` = 1677821 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1673064 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1674965 OR `props-main`.`id` = 1660590 OR `props-main`.`id` = 1677279 OR `props-main`.`id` = 1632394 OR `props-main`.`id` = 1632372 OR `props-main`.`id` = 1662213 OR `props-main`.`id` = 1678059 OR `props-main`.`id` = 1682042 OR `props-main`.`id` = 1684023 OR `props-main`.`id` = 1680013 OR `props-main`.`id` = 1683002 OR `props-main`.`id` = 1683147 OR `props-main`.`id` = 1673030 OR `props-main`.`id` = 1683831 OR `props-main`.`id` = 1674325 OR `props-main`.`id` = 1680785 OR `props-main`.`id` = 1683544 OR `props-main`.`id` = 1678048 OR `props-main`.`id` = 1679965 OR `props-main`.`id` = 1684392 OR `props-main`.`id` = 1679531 OR `props-main`.`id` = 1675221 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1681441 OR `props-main`.`id` = 1663372 OR `props-main`.`id` = 1657445)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636704' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-09' 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 Kamalpreet Wade, Real Broker - kam@strivehome.com Last modified 5 hours ago Fresno MLS last checked for updates 23 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.
