Move-in ready and thoughtfully updated, 1628 S Hazelwood offers peace of mind and modern comfort throughout, the actual sq footage is more than the tax record says (buyer to verify if important). Enjoy major upgrades including a new roof, new HVAC system, electric Panel (all permitted) new flooring, and fresh interior and exterior paint. The functional layout features comfortable living spaces, a good-sized laundry room, and plenty of natural light. Step outside to a generous backyard, perfect for entertaining, gardening, or simply relaxing. Conveniently located near schools, shopping, and everyday amenities, this well-maintained home is a fantastic opportunity you won't want to miss.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1930
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$291
Price Per Acre
$1,858,623
Days On Market
4
Cumulative Days On Market
4
County
Fresno
REO / Bank Owned
No
Cross Street Address
Butler/ E Lane
Directions
Head S on S Hazelwood, property is on the right-hand side.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 289750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 320250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 798 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1298 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` = 1697091 OR `props-main`.`id` = 1702655 OR `props-main`.`id` = 1697095 OR `props-main`.`id` = 1681564 OR `props-main`.`id` = 1698440 OR `props-main`.`id` = 1702336 OR `props-main`.`id` = 1697276 OR `props-main`.`id` = 1702136 OR `props-main`.`id` = 1701916 OR `props-main`.`id` = 1689025 OR `props-main`.`id` = 174244 OR `props-main`.`id` = 1697956 OR `props-main`.`id` = 1695212 OR `props-main`.`id` = 1666148 OR `props-main`.`id` = 1696490 OR `props-main`.`id` = 1696734 OR `props-main`.`id` = 1697424 OR `props-main`.`id` = 1678673 OR `props-main`.`id` = 1625090 OR `props-main`.`id` = 1691288 OR `props-main`.`id` = 1662537 OR `props-main`.`id` = 1674203 OR `props-main`.`id` = 1678452 OR `props-main`.`id` = 1679671 OR `props-main`.`id` = 1698126 OR `props-main`.`id` = 1683102 OR `props-main`.`id` = 1683103 OR `props-main`.`id` = 1701259 OR `props-main`.`id` = 1695121 OR `props-main`.`id` = 1666102 OR `props-main`.`id` = 1701781 OR `props-main`.`id` = 1702386 OR `props-main`.`id` = 1684372 OR `props-main`.`id` = 1698926 OR `props-main`.`id` = 1666327 OR `props-main`.`id` = 1701757 OR `props-main`.`id` = 1699057 OR `props-main`.`id` = 1680010 OR `props-main`.`id` = 1696424 OR `props-main`.`id` = 1650116 OR `props-main`.`id` = 1666338 OR `props-main`.`id` = 1697896 OR `props-main`.`id` = 1703554 OR `props-main`.`id` = 1665709 OR `props-main`.`id` = 1662145 OR `props-main`.`id` = 1688948 OR `props-main`.`id` = 1702688 OR `props-main`.`id` = 1697180 OR `props-main`.`id` = 1660381 OR `props-main`.`id` = 1699146 OR `props-main`.`id` = 1692298 OR `props-main`.`id` = 1702590 OR `props-main`.`id` = 1697224 OR `props-main`.`id` = 1698791 OR `props-main`.`id` = 1702998 OR `props-main`.`id` = 1684874 OR `props-main`.`id` = 1692127 OR `props-main`.`id` = 1702485 OR `props-main`.`id` = 1689230 OR `props-main`.`id` = 1702813 OR `props-main`.`id` = 1686980 OR `props-main`.`id` = 1702004 OR `props-main`.`id` = 1693693 OR `props-main`.`id` = 1695041 OR `props-main`.`id` = 1692596 OR `props-main`.`id` = 1694232 OR `props-main`.`id` = 1654292 OR `props-main`.`id` = 1625610 OR `props-main`.`id` = 1694336 OR `props-main`.`id` = 1701178 OR `props-main`.`id` = 1698007 OR `props-main`.`id` = 1659149 OR `props-main`.`id` = 1698989 OR `props-main`.`id` = 1691548 OR `props-main`.`id` = 1702098 OR `props-main`.`id` = 1696292 OR `props-main`.`id` = 1695817 OR `props-main`.`id` = 1696288 OR `props-main`.`id` = 1681209 OR `props-main`.`id` = 1702354 OR `props-main`.`id` = 1690534 OR `props-main`.`id` = 1696941 OR `props-main`.`id` = 194016 OR `props-main`.`id` = 1702892 OR `props-main`.`id` = 1688397 OR `props-main`.`id` = 1702739 OR `props-main`.`id` = 1681919 OR `props-main`.`id` = 1450737 OR `props-main`.`id` = 1696514 OR `props-main`.`id` = 1702589 OR `props-main`.`id` = 1689281 OR `props-main`.`id` = 1665713 OR `props-main`.`id` = 1690346 OR `props-main`.`id` = 1702891 OR `props-main`.`id` = 1700851 OR `props-main`.`id` = 1689682 OR `props-main`.`id` = 1693849 OR `props-main`.`id` = 1671540 OR `props-main`.`id` = 1695473 OR `props-main`.`id` = 232302 OR `props-main`.`id` = 232595 OR `props-main`.`id` = 1702236 OR `props-main`.`id` = 1703062 OR `props-main`.`id` = 1697418 OR `props-main`.`id` = 1692451 OR `props-main`.`id` = 228066 OR `props-main`.`id` = 1638674 OR `props-main`.`id` = 1689174 OR `props-main`.`id` = 1701724 OR `props-main`.`id` = 1694958 OR `props-main`.`id` = 1673753 OR `props-main`.`id` = 131234 OR `props-main`.`id` = 1695466 OR `props-main`.`id` = 1695789 OR `props-main`.`id` = 1683104 OR `props-main`.`id` = 1687842 OR `props-main`.`id` = 1636734 OR `props-main`.`id` = 1695894 OR `props-main`.`id` = 1703427 OR `props-main`.`id` = 1703666 OR `props-main`.`id` = 1697261 OR `props-main`.`id` = 1702209 OR `props-main`.`id` = 1700964 OR `props-main`.`id` = 1685273 OR `props-main`.`id` = 1696635 OR `props-main`.`id` = 1681713 OR `props-main`.`id` = 1703699 OR `props-main`.`id` = 1685894 OR `props-main`.`id` = 52454 OR `props-main`.`id` = 361177 OR `props-main`.`id` = 282686)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642337' 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();
3
Similar Properties
$315,000
3
1.75
1,202
0.14
4679 E Pitt Ave
Fresno, CA 93725
$307,500
3
1
1,140
0.15
3769 E McKenzie Ave
Fresno, CA 93702
$289,900
3
2
940
0.14
2458 S Poppy Ave
Fresno, CA 93706
Courtesy of Viola Gabriel, Real Broker - [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.
