Discover 2315 Magill Ave in a tranquil Clovis neighborhoodperfect for families seeking peace and minimal traffic. Nestled in a quiet, low-noise pocket, this home offers a serene setting with convenient access to everything you need. Within walking distance to Cox Elementary School and less than two miles from CA-168, commuting and daily errands are a breeze.This could be your next home sweet homeembrace comfort, simplicity, and potential in a great location.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1999
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$281
Price Per Acre
$2,425,181
Days On London
40
Cumulative Days On London
40
County
Fresno
REO / Bank Owned
No
Cross Street Address
Freemont Ave
Directions
Drive North and turn right on N. Temperance Ave, take a right on E. Sierra Ave, make a right on N. Mckelvy Ave. property on your right hand side 2315 Magill Ave.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Gas Hook Up, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 446500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 493500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1422 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1922 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` = 1697275 OR `props-main`.`id` = 1728339 OR `props-main`.`id` = 1728168 OR `props-main`.`id` = 1727496 OR `props-main`.`id` = 1718568 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1727125 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` = 1692117 OR `props-main`.`id` = 1725836 OR `props-main`.`id` = 1725880 OR `props-main`.`id` = 1720527 OR `props-main`.`id` = 1728554 OR `props-main`.`id` = 1707233 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1717166 OR `props-main`.`id` = 1727061 OR `props-main`.`id` = 1703700 OR `props-main`.`id` = 1721724 OR `props-main`.`id` = 1728397 OR `props-main`.`id` = 1718677 OR `props-main`.`id` = 1715688 OR `props-main`.`id` = 1726529 OR `props-main`.`id` = 1717400 OR `props-main`.`id` = 1724473 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1728724 OR `props-main`.`id` = 1685150 OR `props-main`.`id` = 1721535 OR `props-main`.`id` = 1721541 OR `props-main`.`id` = 1721492 OR `props-main`.`id` = 1727133 OR `props-main`.`id` = 1712341 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 1702478 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1700881 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1720830 OR `props-main`.`id` = 1728346 OR `props-main`.`id` = 1665941 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` = 217381 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1718249 OR `props-main`.`id` = 1718246 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` = 1724299 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1724886 OR `props-main`.`id` = 1726022 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1728384 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` = 1727721 OR `props-main`.`id` = 1728253 OR `props-main`.`id` = 1726451 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1722430 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` = 1716508 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` = 1720435 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1720820 OR `props-main`.`id` = 1720797)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646956' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-25' 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
$449,900
3
2.5
1,596
0.21
344 Mckelvy Ave
Clovis, CA 93611
Courtesy of Mayra Lopez Mendoza, London Properties-Kingsburg - [email protected] Last modified 1 month 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.
