Please provide the following information and Larry Schrimp will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.larryschrimp.com/agent/10259/larry-schrimp/property/link/fresno/644489/1565-W-Hawes-Ave/Fresno/https://www.larryschrimp.com/images/props/fresno/full/644489.jpgLondon Properties Fresno Real Estate | 1565 W Hawes Ave
Fri, Mar 6 11:00am - 2:00pm Courtesy of Market Partners Real Estate
Sat, Mar 7 11:00am - 2:00pm Courtesy of Market Partners Real Estate
Schedule a Tour
Contact Info
Presented By:
Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
Property Description
Refreshed and ready! This lovely home has recently received a touch of care in preparation for its next owner. The roof has been replaced by a licensed roofer, new paint inside and out, a new garage door, and some upgraded windows. Its owner replaced the HVAC unit within the last three years and also installed new laminate flooring and kitchen cabinets. If you're looking for move-in ready and for the tranquility that comes with living at the edge of town, this is it.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1972
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$238
Price Per Acre
$2,304,293
Days On London
1
Cumulative Days On London
1
County
Fresno
REO / Bank Owned
No
Cross Street Address
Crystal Avenue
Directions
From State Route 180, travel south on Marks Avenue. Make a left (eastbound) turn onto Kearney Blvd, make a right (southbound) turn onto Crystal Avenue, make a left (eastbound) turn onto Hawes Avenue.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 346750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 383250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1284 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1784 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` = 1690032 OR `props-main`.`id` = 1697094 OR `props-main`.`id` = 1709789 OR `props-main`.`id` = 1683287 OR `props-main`.`id` = 1679412 OR `props-main`.`id` = 1680010 OR `props-main`.`id` = 1696834 OR `props-main`.`id` = 1701669 OR `props-main`.`id` = 1709753 OR `props-main`.`id` = 1709426 OR `props-main`.`id` = 1706118 OR `props-main`.`id` = 1666338 OR `props-main`.`id` = 1697896 OR `props-main`.`id` = 1688672 OR `props-main`.`id` = 1701251 OR `props-main`.`id` = 1712673 OR `props-main`.`id` = 1697772 OR `props-main`.`id` = 1708219 OR `props-main`.`id` = 1707033 OR `props-main`.`id` = 1703613 OR `props-main`.`id` = 1692298 OR `props-main`.`id` = 1697911 OR `props-main`.`id` = 1703649 OR `props-main`.`id` = 1712376 OR `props-main`.`id` = 1674219 OR `props-main`.`id` = 1704536 OR `props-main`.`id` = 1704310 OR `props-main`.`id` = 1692127 OR `props-main`.`id` = 1681366 OR `props-main`.`id` = 1681364 OR `props-main`.`id` = 1681362 OR `props-main`.`id` = 1681344 OR `props-main`.`id` = 1681343 OR `props-main`.`id` = 1681342 OR `props-main`.`id` = 1692397 OR `props-main`.`id` = 1709145 OR `props-main`.`id` = 1700848 OR `props-main`.`id` = 1696514 OR `props-main`.`id` = 1705959 OR `props-main`.`id` = 1712642 OR `props-main`.`id` = 1690827 OR `props-main`.`id` = 1678139 OR `props-main`.`id` = 1689918 OR `props-main`.`id` = 1703084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644489' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-01' 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 Leonardo Rodriguez, Market Partners Real Estate - realtor.leorodriguez@gmail.com Last modified 1 day ago Fresno MLS last checked for updates 56 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.
