Experience the perfect blend of contemporary with low maintenance landscape in this beautiful two story (Wilson Home), on a Corner Lot. Comes with 4 bedrooms, a Bonus Room, 3 baths and is Move in Ready. The modern open concept kitchen flows into the living and dining areas, has stainless steel appliances and elegant granite countertops. A whole house Fan was recently added to cool down the home in the warmer California climate, especially in the evenings. The 3 year old Solar System has a fixed $117 a month loan payment with a very low true up bill. There is synthetic lawn in front and back yard for hassle free landscaping with a bonus putting green and fire pit ready for your relaxation and entertaining. Sellers are amenable to contributing to Buyers Closing Costs, ask me how!Call for your appointment today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2016
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$258
Price Per Acre
$5,823,864
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Ashlan and DeWolf
Directions
From N Dewolf Ave to Lansing Ave
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 584250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 645750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2134 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2634 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` = 1690603 OR `props-main`.`id` = 272957 OR `props-main`.`id` = 1725501 OR `props-main`.`id` = 1666323 OR `props-main`.`id` = 1720617 OR `props-main`.`id` = 1722067 OR `props-main`.`id` = 1718982 OR `props-main`.`id` = 1725406 OR `props-main`.`id` = 1698022 OR `props-main`.`id` = 1724536 OR `props-main`.`id` = 1706044 OR `props-main`.`id` = 1716680 OR `props-main`.`id` = 1712847 OR `props-main`.`id` = 1726128 OR `props-main`.`id` = 1698500 OR `props-main`.`id` = 1718981 OR `props-main`.`id` = 1716477 OR `props-main`.`id` = 1709801 OR `props-main`.`id` = 1717880 OR `props-main`.`id` = 1724490 OR `props-main`.`id` = 1724431 OR `props-main`.`id` = 1724489 OR `props-main`.`id` = 689708 OR `props-main`.`id` = 1721935 OR `props-main`.`id` = 1718737 OR `props-main`.`id` = 1654721 OR `props-main`.`id` = 1721056 OR `props-main`.`id` = 1725333 OR `props-main`.`id` = 1722429 OR `props-main`.`id` = 232301 OR `props-main`.`id` = 1726004 OR `props-main`.`id` = 1716621 OR `props-main`.`id` = 1724029 OR `props-main`.`id` = 1721007 OR `props-main`.`id` = 1720939 OR `props-main`.`id` = 1720441 OR `props-main`.`id` = 1720539 OR `props-main`.`id` = 1720579 OR `props-main`.`id` = 1726174 OR `props-main`.`id` = 1725769 OR `props-main`.`id` = 1721280 OR `props-main`.`id` = 1653283 OR `props-main`.`id` = 1718460 OR `props-main`.`id` = 1718819 OR `props-main`.`id` = 1721640 OR `props-main`.`id` = 1721006 OR `props-main`.`id` = 1725998 OR `props-main`.`id` = 1715621 OR `props-main`.`id` = 1724668 OR `props-main`.`id` = 1721532 OR `props-main`.`id` = 1726021 OR `props-main`.`id` = 1719744 OR `props-main`.`id` = 1706692 OR `props-main`.`id` = 1724014 OR `props-main`.`id` = 1726013 OR `props-main`.`id` = 1725911 OR `props-main`.`id` = 1726001 OR `props-main`.`id` = 1702315 OR `props-main`.`id` = 1725113 OR `props-main`.`id` = 1725112 OR `props-main`.`id` = 1702305 OR `props-main`.`id` = 1719645 OR `props-main`.`id` = 1721123 OR `props-main`.`id` = 1725804 OR `props-main`.`id` = 1719384 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1707114 OR `props-main`.`id` = 1700214 OR `props-main`.`id` = 1698700 OR `props-main`.`id` = 1700216 OR `props-main`.`id` = 1712804 OR `props-main`.`id` = 1722354 OR `props-main`.`id` = 1722227 OR `props-main`.`id` = 1725096 OR `props-main`.`id` = 1716978 OR `props-main`.`id` = 1721842 OR `props-main`.`id` = 1721089 OR `props-main`.`id` = 1725047 OR `props-main`.`id` = 1718751 OR `props-main`.`id` = 1702761 OR `props-main`.`id` = 1722529 OR `props-main`.`id` = 1724752 OR `props-main`.`id` = 1724532 OR `props-main`.`id` = 1718741 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 1722528 OR `props-main`.`id` = 1725806 OR `props-main`.`id` = 1718740 OR `props-main`.`id` = 1722862 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1725798 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 1725791 OR `props-main`.`id` = 1725812 OR `props-main`.`id` = 1721673 OR `props-main`.`id` = 1708280 OR `props-main`.`id` = 1691902 OR `props-main`.`id` = 1724570 OR `props-main`.`id` = 1702248 OR `props-main`.`id` = 1722918 OR `props-main`.`id` = 1705309 OR `props-main`.`id` = 1722130 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1715629 OR `props-main`.`id` = 1722052 OR `props-main`.`id` = 1715630 OR `props-main`.`id` = 1713841 OR `props-main`.`id` = 1718201 OR `props-main`.`id` = 1697275 OR `props-main`.`id` = 1718498 OR `props-main`.`id` = 1721031 OR `props-main`.`id` = 1700151 OR `props-main`.`id` = 1721610 OR `props-main`.`id` = 1717874 OR `props-main`.`id` = 1717877 OR `props-main`.`id` = 1717889 OR `props-main`.`id` = 1717894 OR `props-main`.`id` = 1718090 OR `props-main`.`id` = 1725534 OR `props-main`.`id` = 1718456 OR `props-main`.`id` = 1725429 OR `props-main`.`id` = 1718959 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1705332 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1717166 OR `props-main`.`id` = 1717174 OR `props-main`.`id` = 1717180 OR `props-main`.`id` = 1717194 OR `props-main`.`id` = 1717520)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648055' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-08' 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();
4
Similar Properties
$645,000
4
3
2,499
0.28
2684 Armstrong Ave
Clovis, CA 93611
$639,000
5
3
2,607
0.21
3613 N Dee Ann Ave
Fresno, CA 93727
$615,000
4
3
2,495
0.12
3497 Lincoln Ave
Clovis, CA 93619
$600,000
4
3
2,384
0.10
3606 Saginaw Ave
Clovis, CA 93619
Courtesy of Paula Rogers, Modern Broker - [email protected] Last modified 19 hours ago Fresno MLS last checked for updates 39 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.
