Absolutely immaculate and move-in ready, this 4 bedroom, 3 bath home offers over 2,000 square feet of thoughtfully designed living space in a quiet, gated community within the acclaimed Clovis Unified School District. The open great room is perfect for entertaining or family gatherings, while the fourth bedroom doubles beautifully as a home office. A spacious utility room with abundant cabinetry, built-in storage in the garage, and an extra-wide side yard provide all the convenience and functionality you've been looking for. Energy-saving solar keeps costs low, and the pride of ownership shines through every detail. Don't miss this rare opportunity for comfort, security, and style in one of the area's most desirable neighborhoods. Solar is leased, $130 per month, and seller says there is no true up.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
PUD
Year Built
2018
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$251
Price Per Acre
$3,175,592
Days On Market
89
Cumulative Days On Market
89
County
Fresno
Leased Equipment
Solar Panels
REO / Bank Owned
No
Cross Street Address
Shaw and Leonard
Directions
From Bullard and Leonard, south on Leonard, east through the gate on Ethan, turn right then left, home is on the left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 484500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 535500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1784 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2284 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` = 1683685 OR `props-main`.`id` = 1694804 OR `props-main`.`id` = 1692557 OR `props-main`.`id` = 1694090 OR `props-main`.`id` = 1689048 OR `props-main`.`id` = 1684904 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1691329 OR `props-main`.`id` = 1694735 OR `props-main`.`id` = 1689646 OR `props-main`.`id` = 1636728 OR `props-main`.`id` = 1636687 OR `props-main`.`id` = 1666079 OR `props-main`.`id` = 1688235 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 1685923 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1691110 OR `props-main`.`id` = 1690251 OR `props-main`.`id` = 1691902 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1674965 OR `props-main`.`id` = 1677279 OR `props-main`.`id` = 1689862 OR `props-main`.`id` = 1689879 OR `props-main`.`id` = 1688799 OR `props-main`.`id` = 1673063 OR `props-main`.`id` = 1673069 OR `props-main`.`id` = 1692628 OR `props-main`.`id` = 1683147 OR `props-main`.`id` = 1691563 OR `props-main`.`id` = 1694557 OR `props-main`.`id` = 1688081 OR `props-main`.`id` = 1691901 OR `props-main`.`id` = 1689644 OR `props-main`.`id` = 1692117 OR `props-main`.`id` = 1677988 OR `props-main`.`id` = 1677736 OR `props-main`.`id` = 1694810 OR `props-main`.`id` = 1686335 OR `props-main`.`id` = 1693978 OR `props-main`.`id` = 1689142 OR `props-main`.`id` = 1689264 OR `props-main`.`id` = 1694905 OR `props-main`.`id` = 1681768 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1694402 OR `props-main`.`id` = 1681441 OR `props-main`.`id` = 1682126 OR `props-main`.`id` = 1683222 OR `props-main`.`id` = 1694595 OR `props-main`.`id` = 1695187 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1685150 OR `props-main`.`id` = 1690495 OR `props-main`.`id` = 1688289 OR `props-main`.`id` = 1689255 OR `props-main`.`id` = 1672917 OR `props-main`.`id` = 1689656 OR `props-main`.`id` = 1693684 OR `props-main`.`id` = 1687976 OR `props-main`.`id` = 1693813 OR `props-main`.`id` = 1693895 OR `props-main`.`id` = 1690345 OR `props-main`.`id` = 1689422 OR `props-main`.`id` = 1689257 OR `props-main`.`id` = 1692525 OR `props-main`.`id` = 1693867 OR `props-main`.`id` = 1684221 OR `props-main`.`id` = 1693671 OR `props-main`.`id` = 1678591 OR `props-main`.`id` = 1678544 OR `props-main`.`id` = 1691432 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1638338 OR `props-main`.`id` = 1687108 OR `props-main`.`id` = 1687047 OR `props-main`.`id` = 1690806)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno635638' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-18' 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();
1
Similar Properties
$518,000
4
2.75
1,797
0.10
3549 Taylor Ln
Clovis, CA 93619
Courtesy of Laura Corey, Realty Concepts, Ltd. - Fresno - lauracoreymelton@gmail.com Last modified 5 days ago Fresno MLS last checked for updates 46 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.
