Courtesy of Victoria Contreras, HomeSmart PV and Associates - [email protected]
Beautiful mature landscaped 5 bedroom/ 3 bath Clovis home with a breathtaking Pool! Located within the highly regarded Clovis Unified School District, the home features a 3 Car Garage and space for potential RV parking!The beautiful kitchen features quartz countertops, stainless steel appliances, a gas range, subway tile backsplash and walk-in pantry. Vaulted ceilings and large windows create a bright, open feel, while the dining area provides a comfortable gathering space. Isolated downstairs bedroom/ office with downstairs bathroom featuring tub/shower. Upstairs are four bedrooms and two baths which include the primary bedroom/ bath and a loft for your family evening gatherings. Enjoy the outdoors and host your family gatherings relaxing near the pool as you listen to the calming of the waterfall flowing. With PGE rising, the home also contains owned solar. Don't miss out, call your agent today!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 650750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 719250 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) >= 2233 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2733 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` = 1768633 OR `props-main`.`id` = 1761187 OR `props-main`.`id` = 1761216 OR `props-main`.`id` = 1775594 OR `props-main`.`id` = 1775596 OR `props-main`.`id` = 1775597 OR `props-main`.`id` = 1774599 OR `props-main`.`id` = 1770504 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1771441 OR `props-main`.`id` = 1780305 OR `props-main`.`id` = 1760610 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1759363 OR `props-main`.`id` = 1759398 OR `props-main`.`id` = 1778114 OR `props-main`.`id` = 1779033 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1766614 OR `props-main`.`id` = 1763066 OR `props-main`.`id` = 1763041 OR `props-main`.`id` = 1770964 OR `props-main`.`id` = 1746951 OR `props-main`.`id` = 1771194 OR `props-main`.`id` = 1749154 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1771017 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1773010 OR `props-main`.`id` = 1769009 OR `props-main`.`id` = 1771016 OR `props-main`.`id` = 1770884 OR `props-main`.`id` = 1776739 OR `props-main`.`id` = 1732361 OR `props-main`.`id` = 1766894 OR `props-main`.`id` = 1757662 OR `props-main`.`id` = 1761462 OR `props-main`.`id` = 1769035 OR `props-main`.`id` = 1770257 OR `props-main`.`id` = 1770016 OR `props-main`.`id` = 1753004 OR `props-main`.`id` = 1780052 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1774842 OR `props-main`.`id` = 1774502 OR `props-main`.`id` = 1767577 OR `props-main`.`id` = 1751330 OR `props-main`.`id` = 1752147 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1761852 OR `props-main`.`id` = 1779590 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1774181 OR `props-main`.`id` = 1775074 OR `props-main`.`id` = 1780008 OR `props-main`.`id` = 1736632 OR `props-main`.`id` = 1759439 OR `props-main`.`id` = 1761754 OR `props-main`.`id` = 1755862 OR `props-main`.`id` = 1771476 OR `props-main`.`id` = 1758747 OR `props-main`.`id` = 1763285 OR `props-main`.`id` = 1775041 OR `props-main`.`id` = 1771036 OR `props-main`.`id` = 1750648 OR `props-main`.`id` = 1750780 OR `props-main`.`id` = 1744938 OR `props-main`.`id` = 1730174 OR `props-main`.`id` = 1771257 OR `props-main`.`id` = 1772828 OR `props-main`.`id` = 1779985 OR `props-main`.`id` = 1754527 OR `props-main`.`id` = 1752922 OR `props-main`.`id` = 1745339 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1773783 OR `props-main`.`id` = 1749995 OR `props-main`.`id` = 1739362 OR `props-main`.`id` = 1759511 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1759004 OR `props-main`.`id` = 1775554 OR `props-main`.`id` = 1754731 OR `props-main`.`id` = 1772093 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1735948 OR `props-main`.`id` = 1729119 OR `props-main`.`id` = 1729135 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1746896 OR `props-main`.`id` = 1766282 OR `props-main`.`id` = 1766797 OR `props-main`.`id` = 1777077 OR `props-main`.`id` = 1775562 OR `props-main`.`id` = 1745941 OR `props-main`.`id` = 1753412 OR `props-main`.`id` = 1774921 OR `props-main`.`id` = 1775331 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1774747 OR `props-main`.`id` = 1732245 OR `props-main`.`id` = 1777838 OR `props-main`.`id` = 1777834 OR `props-main`.`id` = 1775259 OR `props-main`.`id` = 1773974 OR `props-main`.`id` = 1727742 OR `props-main`.`id` = 1727740 OR `props-main`.`id` = 1727738 OR `props-main`.`id` = 1727737 OR `props-main`.`id` = 1754304 OR `props-main`.`id` = 1754303 OR `props-main`.`id` = 1754302 OR `props-main`.`id` = 1754301 OR `props-main`.`id` = 1778645 OR `props-main`.`id` = 1778616 OR `props-main`.`id` = 1778612 OR `props-main`.`id` = 1779444 OR `props-main`.`id` = 1778614 OR `props-main`.`id` = 1778647 OR `props-main`.`id` = 1778615 OR `props-main`.`id` = 1778650 OR `props-main`.`id` = 1778649 OR `props-main`.`id` = 1778648 OR `props-main`.`id` = 1778611 OR `props-main`.`id` = 1758320 OR `props-main`.`id` = 1778646 OR `props-main`.`id` = 1732770 OR `props-main`.`id` = 1760193 OR `props-main`.`id` = 1766787 OR `props-main`.`id` = 1756523 OR `props-main`.`id` = 1732813 OR `props-main`.`id` = 1737032 OR `props-main`.`id` = 1773063 OR `props-main`.`id` = 1773066 OR `props-main`.`id` = 1761623)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653143' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-23' 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
$668,000
4
3
2,589
0.20
2551 Magill Ave
Clovis, CA 93611
Last modified 5 days ago Fresno MLS last checked for updates 9 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.
