Please provide the following information and Lillian Frankian will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.lilfrankian.com/agent/14897/lillian-frankian/property/link/fresno/638868/3147-Indianapolis-Ave/Clovis/https://www.lilfrankian.com/images/props/fresno/full/638868.jpgLondon Properties Clovis Real Estate | 3147 Indianapolis Ave
This charming property showcases beautifully modern updates, including refreshed flooring and renovated kitchen and bathrooms. The kitchen and dining nook feature easy-to-maintain ceramic tile flooring that elegantly complements the granite countertops and stylish backsplash. Ample storage throughout the kitchen and dining areas ensures both convenience and functionality. Nestled on a quiet cul-de-sac, this inviting single-level home offers three bedrooms and two bathrooms, encompassing 1,821 square feet of living space on a 7,700-square-foot lot. The open living room, complete with a cozy fireplace, creates a warm and welcoming atmosphere. The formal dining room, which can easily serve as an office or bonus room, provides versatile space to suit your needs. The primary suite boasts a spacious walk-in closet and a luxurious bathroom with a soaking tub, perfect for relaxation. Outside, the property impresses with stunning curb appeal and a low-maintenance backyard featuring stamped concrete, a sparkling pool, a covered patio, and a 12' x 10' storage shed with electricity. Move-in ready and meticulously maintained, this Clovis gem offers everything you've been searching for.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$272
Price Per Acre
$2,798,643
Days On Market
32
Cumulative Days On Market
32
County
Fresno
REO / Bank Owned
No
Cross Street Address
S/Gettysburg, E/Locan
Directions
From the intersection of Gettysburg and Locan, south on Locan, left on Ashcroft, left on Maine, left on Indianapolis
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 470060 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 519540 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1571 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2071 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` = 1687386 OR `props-main`.`id` = 1691125 OR `props-main`.`id` = 1686880 OR `props-main`.`id` = 1683687 OR `props-main`.`id` = 1680358 OR `props-main`.`id` = 1671592 OR `props-main`.`id` = 1671586 OR `props-main`.`id` = 1696069 OR `props-main`.`id` = 1695639 OR `props-main`.`id` = 1695576 OR `props-main`.`id` = 1696340 OR `props-main`.`id` = 689708 OR `props-main`.`id` = 1666223 OR `props-main`.`id` = 1694264 OR `props-main`.`id` = 1654721 OR `props-main`.`id` = 1677866 OR `props-main`.`id` = 232301 OR `props-main`.`id` = 1688300 OR `props-main`.`id` = 1688268 OR `props-main`.`id` = 1687422 OR `props-main`.`id` = 1691180 OR `props-main`.`id` = 1681288 OR `props-main`.`id` = 1653283 OR `props-main`.`id` = 1696003 OR `props-main`.`id` = 1665613 OR `props-main`.`id` = 1693954 OR `props-main`.`id` = 1688926 OR `props-main`.`id` = 1686356 OR `props-main`.`id` = 1685470 OR `props-main`.`id` = 1688566 OR `props-main`.`id` = 1688738 OR `props-main`.`id` = 1692039 OR `props-main`.`id` = 1692452 OR `props-main`.`id` = 1692399 OR `props-main`.`id` = 1692277 OR `props-main`.`id` = 1695818 OR `props-main`.`id` = 1685405 OR `props-main`.`id` = 1694271 OR `props-main`.`id` = 1683685 OR `props-main`.`id` = 1694804 OR `props-main`.`id` = 1683621 OR `props-main`.`id` = 1683514 OR `props-main`.`id` = 1692557 OR `props-main`.`id` = 1694090 OR `props-main`.`id` = 1696259 OR `props-main`.`id` = 235509 OR `props-main`.`id` = 1684904 OR `props-main`.`id` = 1686691 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1690333 OR `props-main`.`id` = 1688745 OR `props-main`.`id` = 1695872 OR `props-main`.`id` = 1695896 OR `props-main`.`id` = 1695887 OR `props-main`.`id` = 1695845 OR `props-main`.`id` = 1691329 OR `props-main`.`id` = 1694735 OR `props-main`.`id` = 1679921 OR `props-main`.`id` = 1691989 OR `props-main`.`id` = 1689646 OR `props-main`.`id` = 1695372 OR `props-main`.`id` = 1674222 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 1667529 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 1685923 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1691885 OR `props-main`.`id` = 1691110 OR `props-main`.`id` = 1690251 OR `props-main`.`id` = 1695565 OR `props-main`.`id` = 1691902 OR `props-main`.`id` = 1691815 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1691202 OR `props-main`.`id` = 1677279 OR `props-main`.`id` = 1689862 OR `props-main`.`id` = 1689879 OR `props-main`.`id` = 1684837 OR `props-main`.`id` = 1673063 OR `props-main`.`id` = 1673069 OR `props-main`.`id` = 1692628 OR `props-main`.`id` = 1696054 OR `props-main`.`id` = 1696106 OR `props-main`.`id` = 1696107 OR `props-main`.`id` = 1696118 OR `props-main`.`id` = 1696331 OR `props-main`.`id` = 1688992 OR `props-main`.`id` = 1683147 OR `props-main`.`id` = 1691563 OR `props-main`.`id` = 1694557 OR `props-main`.`id` = 1694658 OR `props-main`.`id` = 1694663 OR `props-main`.`id` = 1694666 OR `props-main`.`id` = 1688081 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1691901 OR `props-main`.`id` = 1689644 OR `props-main`.`id` = 1692117 OR `props-main`.`id` = 1677988 OR `props-main`.`id` = 1694811 OR `props-main`.`id` = 1695519 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` = 1695993 OR `props-main`.`id` = 1695988 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` = 1696158 OR `props-main`.`id` = 1688289 OR `props-main`.`id` = 1689656 OR `props-main`.`id` = 1693684 OR `props-main`.`id` = 1687976 OR `props-main`.`id` = 1693895 OR `props-main`.`id` = 1690345 OR `props-main`.`id` = 1689422)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno638868' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-30' 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();
16
Similar Properties
$509,900
3
2.5
1,797
0.10
1579 Medellin Ln
Clovis, CA 93619
$495,000
3
2.5
1,740
0.20
3975 Ramona Ave
Clovis, CA 93619
$479,000
3
2
1,702
0.09
2459 Lombard
Clovis, CA 93619
$479,000
3
2
1,588
0.21
3083 N Stanley Ave
Fresno, CA 93737
Courtesy of Sarah Hedrick, Realty Concepts, Ltd. - Fresno - sarahhedrickrealtor@gmail.com Last modified 1 day ago Fresno MLS last checked for updates 11 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.
