First time on the market! Pride of ownership shines throughout this impeccably maintained Clovis home featuring single story, 4 bedrooms, a functional layout, and timeless appeal and no HOA. The isolated fourth bedroom with a private ensuite offers flexibility for guests, multigenerational living, or a potential in-law setup. From the pristine condition to the thoughtful floorplan, this home has been exceptionally cared for and is truly move-in ready. Located in a desirable Clovis neighborhood near shopping, dining, parks, and award-winning schools. Schedule your private tour today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2016
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$293
Price Per Acre
$3,787,175
Days On London
1
Cumulative Days On London
1
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
Locan/Nees
Directions
From 168 East, left on Owens Mountain Mkwy, right on Kenosha, property on your left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 774250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 855750 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) >= 2535 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3035 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` = 1726840 OR `props-main`.`id` = 1723006 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 1725062 OR `props-main`.`id` = 1721879 OR `props-main`.`id` = 1724299 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1726080 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1724886 OR `props-main`.`id` = 1723559 OR `props-main`.`id` = 1723131 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1727349 OR `props-main`.`id` = 1721072 OR `props-main`.`id` = 1727387 OR `props-main`.`id` = 1728253 OR `props-main`.`id` = 1726451 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1727983 OR `props-main`.`id` = 1722430 OR `props-main`.`id` = 1726822 OR `props-main`.`id` = 1722623 OR `props-main`.`id` = 1727962 OR `props-main`.`id` = 1722847 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1716751 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1710090 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 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` = 1721608 OR `props-main`.`id` = 1724857 OR `props-main`.`id` = 1726814 OR `props-main`.`id` = 1724751 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1726680 OR `props-main`.`id` = 1712677 OR `props-main`.`id` = 1721325 OR `props-main`.`id` = 1728171 OR `props-main`.`id` = 1724586 OR `props-main`.`id` = 1725116 OR `props-main`.`id` = 1720820 OR `props-main`.`id` = 1720797 OR `props-main`.`id` = 1720901 OR `props-main`.`id` = 1724652 OR `props-main`.`id` = 1727497 OR `props-main`.`id` = 1726715 OR `props-main`.`id` = 1720903 OR `props-main`.`id` = 1721973 OR `props-main`.`id` = 1728251 OR `props-main`.`id` = 1725336)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649240' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-22' 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();
2
Similar Properties
$794,950
5
3
2,601
0.17
3544 Prescott Ave
Clovis, CA 93619
$789,000
4
3
2,600
0.25
1890 N Hornet Ave
Clovis, CA 93619
Courtesy of Alexandra Cetti, London Properties, Ltd. - [email protected] Last modified 17 hours 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.
