Courtesy of Casey Chumley, Real Brokerage Technologies - [email protected]
This beautifully updated Clovis gem at 2671 Fremont offers a bright and airy living experience, featuring a spacious 4-bedroom, 2-bathroom layout illuminated by an abundance of windows that wrap the home in natural light. The interior shines with freshly updated flooring throughout, while the standout backyard provides a rare sense of privacy with no rear neighborsideal for quiet mornings or weekend entertaining in a peaceful neighborhood. Perfectly positioned for convenience, you are just minutes away from top-rated Clovis Unified schools and the Clovis Community Medical Center, making this an incredible opportunity for anyone seeking a serene, light-filled lifestyle in the heart of the community.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1994
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$257
Price Per Acre
$3,057,846
Days On London
46
Cumulative Days On London
46
County
Fresno
REO / Bank Owned
No
Cross Street Address
Herndon & Temperance
Directions
From Herndon and Temperance, go east on herndon, right on Coventry, right on Fremont, and home is on the right of street.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 436905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 482895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1537 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2037 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` = 1722918 OR `props-main`.`id` = 1726250 OR `props-main`.`id` = 1697275 OR `props-main`.`id` = 1721031 OR `props-main`.`id` = 1728339 OR `props-main`.`id` = 1727496 OR `props-main`.`id` = 1718568 OR `props-main`.`id` = 1718959 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1705332 OR `props-main`.`id` = 1732230 OR `props-main`.`id` = 1727125 OR `props-main`.`id` = 1727762 OR `props-main`.`id` = 1727761 OR `props-main`.`id` = 1727767 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` = 1730602 OR `props-main`.`id` = 1730234 OR `props-main`.`id` = 1725880 OR `props-main`.`id` = 1720527 OR `props-main`.`id` = 1728554 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1728924 OR `props-main`.`id` = 1731148 OR `props-main`.`id` = 1731829 OR `props-main`.`id` = 1727061 OR `props-main`.`id` = 1721724 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1715688 OR `props-main`.`id` = 1730582 OR `props-main`.`id` = 1730587 OR `props-main`.`id` = 1726529 OR `props-main`.`id` = 1717400 OR `props-main`.`id` = 1700055 OR `props-main`.`id` = 1724473 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1728724 OR `props-main`.`id` = 1685150 OR `props-main`.`id` = 1732184 OR `props-main`.`id` = 1731120 OR `props-main`.`id` = 1727133 OR `props-main`.`id` = 1712341 OR `props-main`.`id` = 1732163 OR `props-main`.`id` = 1720270 OR `props-main`.`id` = 1728874 OR `props-main`.`id` = 1728877 OR `props-main`.`id` = 1728899 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 1718239 OR `props-main`.`id` = 1702478 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1700881 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1720830 OR `props-main`.`id` = 1728346 OR `props-main`.`id` = 1721860 OR `props-main`.`id` = 1726398 OR `props-main`.`id` = 1726287 OR `props-main`.`id` = 1726840 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1723006 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1731542 OR `props-main`.`id` = 1723835 OR `props-main`.`id` = 1723817 OR `props-main`.`id` = 1725062 OR `props-main`.`id` = 1724803 OR `props-main`.`id` = 1721879 OR `props-main`.`id` = 1731594 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1726080 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1731908 OR `props-main`.`id` = 1723559 OR `props-main`.`id` = 1731997 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` = 1732214 OR `props-main`.`id` = 1726451 OR `props-main`.`id` = 1730174 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1731436 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` = 1716326 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1717456 OR `props-main`.`id` = 1717420 OR `props-main`.`id` = 1717431 OR `props-main`.`id` = 1717440 OR `props-main`.`id` = 1721608 OR `props-main`.`id` = 1724857 OR `props-main`.`id` = 1729298 OR `props-main`.`id` = 1724751 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1729321 OR `props-main`.`id` = 1729341 OR `props-main`.`id` = 1720901)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646503' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-03' 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
Last modified 2 days ago Fresno MLS last checked for updates 25 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.
