A beautifully updated 3-bed, 2-bath home in an established, quiet Clovis neighborhood. The open floorplan showcases a fabulous kitchen with quartz counters, subway tile backsplash, and gas stainless-steel appliances, perfect for entertaining. Enjoy the dramatic floor-to-ceiling stone fireplace and laminate flooring throughout the common areas. The well-shaped backyard is a blank canvas ready for the new owner's finishing touches. Don't miss this move-in-ready home offering modern finishes and comfortable, relaxed living.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1993
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$275
Price Per Acre
$3,301,394
Days On Market
13
Cumulative Days On Market
13
County
Fresno
Leased Equipment
Solar Panels
REO / Bank Owned
No
Cross Street Address
Clovis and Shields
Directions
Going East on Ashlan, make a right on Clovis, make a left on Dakota Ave, right on Sabre Ave, right on Ramona, Left on Judy Ave, and left on Garland. Home on right hand side.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Dishwasher, Microwave
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 360050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 397950 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) >= 1130 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1630 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` = 1695080 OR `props-main`.`id` = 1702614 OR `props-main`.`id` = 1701845 OR `props-main`.`id` = 1701405 OR `props-main`.`id` = 1701404 OR `props-main`.`id` = 1696797 OR `props-main`.`id` = 1703405 OR `props-main`.`id` = 1685109 OR `props-main`.`id` = 1701397 OR `props-main`.`id` = 1690666 OR `props-main`.`id` = 1701406 OR `props-main`.`id` = 1701414 OR `props-main`.`id` = 1701408 OR `props-main`.`id` = 1701407 OR `props-main`.`id` = 1701409 OR `props-main`.`id` = 1701410 OR `props-main`.`id` = 1701415 OR `props-main`.`id` = 1701399 OR `props-main`.`id` = 1690669 OR `props-main`.`id` = 1701398 OR `props-main`.`id` = 1690677 OR `props-main`.`id` = 1701400 OR `props-main`.`id` = 1690570 OR `props-main`.`id` = 1701419 OR `props-main`.`id` = 1701416 OR `props-main`.`id` = 1701401 OR `props-main`.`id` = 1690671 OR `props-main`.`id` = 1690678 OR `props-main`.`id` = 1689501 OR `props-main`.`id` = 1684912 OR `props-main`.`id` = 1701421 OR `props-main`.`id` = 1696891 OR `props-main`.`id` = 1696893 OR `props-main`.`id` = 1691096 OR `props-main`.`id` = 1690749 OR `props-main`.`id` = 1666305 OR `props-main`.`id` = 1690830 OR `props-main`.`id` = 1702503 OR `props-main`.`id` = 1702481 OR `props-main`.`id` = 1703319 OR `props-main`.`id` = 1698022 OR `props-main`.`id` = 1701402 OR `props-main`.`id` = 1703049 OR `props-main`.`id` = 1691985 OR `props-main`.`id` = 1695102 OR `props-main`.`id` = 1691688 OR `props-main`.`id` = 1680358 OR `props-main`.`id` = 1671592 OR `props-main`.`id` = 1671586 OR `props-main`.`id` = 1698500 OR `props-main`.`id` = 1687464 OR `props-main`.`id` = 689708 OR `props-main`.`id` = 1701643 OR `props-main`.`id` = 1691776 OR `props-main`.`id` = 1696495 OR `props-main`.`id` = 1703287 OR `props-main`.`id` = 1690548 OR `props-main`.`id` = 1698820 OR `props-main`.`id` = 1702153 OR `props-main`.`id` = 1691180 OR `props-main`.`id` = 1691273 OR `props-main`.`id` = 1700210 OR `props-main`.`id` = 1703486 OR `props-main`.`id` = 1690446 OR `props-main`.`id` = 1665613 OR `props-main`.`id` = 1692350 OR `props-main`.`id` = 1702090 OR `props-main`.`id` = 1702321 OR `props-main`.`id` = 1692399 OR `props-main`.`id` = 1692277 OR `props-main`.`id` = 180610 OR `props-main`.`id` = 1703585 OR `props-main`.`id` = 1697339 OR `props-main`.`id` = 1701755 OR `props-main`.`id` = 1702097 OR `props-main`.`id` = 1696259 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1679178 OR `props-main`.`id` = 235509 OR `props-main`.`id` = 1681864 OR `props-main`.`id` = 1679179 OR `props-main`.`id` = 1695439 OR `props-main`.`id` = 1702045 OR `props-main`.`id` = 1696455 OR `props-main`.`id` = 1696213 OR `props-main`.`id` = 1696446 OR `props-main`.`id` = 1696456 OR `props-main`.`id` = 1696215 OR `props-main`.`id` = 1696447 OR `props-main`.`id` = 1701725 OR `props-main`.`id` = 1696457 OR `props-main`.`id` = 1696448 OR `props-main`.`id` = 1696452 OR `props-main`.`id` = 1701728 OR `props-main`.`id` = 1695584 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1702120 OR `props-main`.`id` = 1701174 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1700126 OR `props-main`.`id` = 1700806 OR `props-main`.`id` = 1698713 OR `props-main`.`id` = 1697751 OR `props-main`.`id` = 1702948 OR `props-main`.`id` = 1702993 OR `props-main`.`id` = 1697079 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1696937 OR `props-main`.`id` = 1699176 OR `props-main`.`id` = 1702183 OR `props-main`.`id` = 1697925 OR `props-main`.`id` = 1702647 OR `props-main`.`id` = 1702630 OR `props-main`.`id` = 1689226 OR `props-main`.`id` = 1701295 OR `props-main`.`id` = 1684202 OR `props-main`.`id` = 1694690 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1700887 OR `props-main`.`id` = 1692325 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1698811 OR `props-main`.`id` = 1703079 OR `props-main`.`id` = 1703510 OR `props-main`.`id` = 1696835 OR `props-main`.`id` = 1697089 OR `props-main`.`id` = 1683107)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642458' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-21' 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();
7
Similar Properties
$381,990
3
2.5
1,402
0.05
6552 E Blushing Dr
Fresno, CA 93727
$381,990
3
2.5
1,402
0.05
2128 N Autumnglo Dr
Fresno, CA 93727
$381,990
3
2.5
1,402
0.05
6564 E Cresthaven Dr
Fresno, CA 93727
$379,000
3
2
1,478
0.17
698 W Donner Ave
Clovis, CA 93612
Courtesy of Alejandra Charest, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 28 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.
