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/646474/1323-Oak-Ave/Clovis/https://www.lilfrankian.com/images/props/fresno/full/646474.jpgLondon Properties Clovis Real Estate | 1323 Oak Ave
Welcome to your next home! This beautifully maintained 3 bedroom, 3 bathroom property offers 2,175 sq ft of versatile living space, perfectly situated on a premium corner lot with a newly renovated tub and shower. This open-concept layout has generous room sizes, and plenty of natural light, this home is perfect for both relaxing and entertaining. The backyard features a spacious deck, good size grass area, and a separate gate to the RV/boat/extra parking area. Located in the highly sought after Clovis Unified School District, with easy access to amenities this is the one you've been waiting for!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1994
Region
Urban
# of Stories
Multi/Split
Price Per Square Foot
$253
Price Per Acre
$2,963,362
Days On London
13
Cumulative Days On London
194
County
Fresno
REO / Bank Owned
No
Cross Street Address
Sunnyside & Alluvial
Directions
Alluvial & Sunnyside, Turn left on Duke, right on Oak, home on left
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Electric Appliances, Dishwasher, Microwave, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 522500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 577500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1925 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2425 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` = 1707233 OR `props-main`.`id` = 1703700 OR `props-main`.`id` = 1718677 OR `props-main`.`id` = 1721492 OR `props-main`.`id` = 1716552 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 1718515 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1720830 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1721860 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1718789 OR `props-main`.`id` = 1718483 OR `props-main`.`id` = 1709968 OR `props-main`.`id` = 1692098 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1692107 OR `props-main`.`id` = 1701105 OR `props-main`.`id` = 1717261 OR `props-main`.`id` = 1721120 OR `props-main`.`id` = 1720606 OR `props-main`.`id` = 1706150 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1717466 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1693905 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1718249 OR `props-main`.`id` = 1718246 OR `props-main`.`id` = 1720801 OR `props-main`.`id` = 1721879 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1704516 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1721507 OR `props-main`.`id` = 1718676 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1711434 OR `props-main`.`id` = 1711436 OR `props-main`.`id` = 1697265 OR `props-main`.`id` = 1718000 OR `props-main`.`id` = 1719566 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 1713568 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1705398 OR `props-main`.`id` = 1717159 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1721439 OR `props-main`.`id` = 1721072 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1718254 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1720324 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1716751 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1720564 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1721608 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1713049 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1720820 OR `props-main`.`id` = 1720797 OR `props-main`.`id` = 1721354 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1720903 OR `props-main`.`id` = 1716028 OR `props-main`.`id` = 1712606 OR `props-main`.`id` = 1716498 OR `props-main`.`id` = 1719778 OR `props-main`.`id` = 1719773 OR `props-main`.`id` = 1719777 OR `props-main`.`id` = 1719779 OR `props-main`.`id` = 1719786 OR `props-main`.`id` = 1719769 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1719770 OR `props-main`.`id` = 1719785 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1719767 OR `props-main`.`id` = 1719784 OR `props-main`.`id` = 1719787 OR `props-main`.`id` = 1719768 OR `props-main`.`id` = 1719793 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1719791 OR `props-main`.`id` = 1719792 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1719790 OR `props-main`.`id` = 1719783 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1719782 OR `props-main`.`id` = 1719788 OR `props-main`.`id` = 1719789 OR `props-main`.`id` = 1718323 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1719772 OR `props-main`.`id` = 1721220 OR `props-main`.`id` = 1720316 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646474' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-15' 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
Courtesy of Jonathan Contrestano, Real Broker - jt@brokerjt.com Last modified 1 week ago Fresno MLS last checked for updates 31 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.
