Wonderful single story Leo Wilson home in the Loma Vista area. This home has 3 bedrooms plus a bonus room. Bonus room can be used as office, game room or guest room. Gated community with Los Arbolitos Park right outside of the gates. Close to the scenic Jefferson Trail, offering easy access to green space and walking paths. Chefs kitchen with granite counter tops and large center island. Dinning room area fits a large table for entertaining. On a corner lot with a nice back yard. The yard has extended concrete with a great BBQ spot. Set up your appointment to see this one today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2018
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$273
Price Per Acre
$5,406,977
Days On London
168
Cumulative Days On London
168
County
Fresno
REO / Bank Owned
No
Cross Street Address
Shaw/ Dewolf
Directions
Shaw to Leonard
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Tub
Flooring
Carpet, Tile
Exterior
Stucco, Wood
Pool
No
Pool
No
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto, Fenced, Drip System
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 441750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 488250 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) >= 1452 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1952 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` = 1666223 OR `props-main`.`id` = 1712797 OR `props-main`.`id` = 1701900 OR `props-main`.`id` = 1654721 OR `props-main`.`id` = 232301 OR `props-main`.`id` = 1716621 OR `props-main`.`id` = 1711067 OR `props-main`.`id` = 1706133 OR `props-main`.`id` = 1709275 OR `props-main`.`id` = 1709880 OR `props-main`.`id` = 1707081 OR `props-main`.`id` = 1705721 OR `props-main`.`id` = 1715928 OR `props-main`.`id` = 1712880 OR `props-main`.`id` = 1653283 OR `props-main`.`id` = 1713649 OR `props-main`.`id` = 1713807 OR `props-main`.`id` = 1715926 OR `props-main`.`id` = 1665613 OR `props-main`.`id` = 1715621 OR `props-main`.`id` = 1703829 OR `props-main`.`id` = 1706692 OR `props-main`.`id` = 1710192 OR `props-main`.`id` = 1694090 OR `props-main`.`id` = 1702315 OR `props-main`.`id` = 1702305 OR `props-main`.`id` = 1715639 OR `props-main`.`id` = 1715689 OR `props-main`.`id` = 235509 OR `props-main`.`id` = 1716212 OR `props-main`.`id` = 1716232 OR `props-main`.`id` = 1707973 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1704977 OR `props-main`.`id` = 1716492 OR `props-main`.`id` = 1716458 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` = 1695896 OR `props-main`.`id` = 1695887 OR `props-main`.`id` = 1707239 OR `props-main`.`id` = 1712754 OR `props-main`.`id` = 1695845 OR `props-main`.`id` = 1706653 OR `props-main`.`id` = 1702948 OR `props-main`.`id` = 1702993 OR `props-main`.`id` = 1702474 OR `props-main`.`id` = 1702502 OR `props-main`.`id` = 1702761 OR `props-main`.`id` = 1697079 OR `props-main`.`id` = 1701844 OR `props-main`.`id` = 1712980 OR `props-main`.`id` = 1712840 OR `props-main`.`id` = 1716655 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 1705215 OR `props-main`.`id` = 1713585 OR `props-main`.`id` = 1707217 OR `props-main`.`id` = 1709233 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1713121 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 1685923 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1714023 OR `props-main`.`id` = 1708280 OR `props-main`.`id` = 1691902 OR `props-main`.`id` = 1697720 OR `props-main`.`id` = 1701422 OR `props-main`.`id` = 1702248 OR `props-main`.`id` = 1696687 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1704253 OR `props-main`.`id` = 1705309 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1715629 OR `props-main`.`id` = 1715630 OR `props-main`.`id` = 1713841 OR `props-main`.`id` = 1697275 OR `props-main`.`id` = 1700151 OR `props-main`.`id` = 1705362 OR `props-main`.`id` = 1706998 OR `props-main`.`id` = 1707001 OR `props-main`.`id` = 1707021 OR `props-main`.`id` = 1707947 OR `props-main`.`id` = 1700937 OR `props-main`.`id` = 1707007 OR `props-main`.`id` = 1709205 OR `props-main`.`id` = 1697445 OR `props-main`.`id` = 1707230 OR `props-main`.`id` = 1700213 OR `props-main`.`id` = 1700211 OR `props-main`.`id` = 1709269 OR `props-main`.`id` = 1709815 OR `props-main`.`id` = 1703993 OR `props-main`.`id` = 1709901 OR `props-main`.`id` = 1702303 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1705332 OR `props-main`.`id` = 1704482 OR `props-main`.`id` = 1708030 OR `props-main`.`id` = 1692117 OR `props-main`.`id` = 1702654 OR `props-main`.`id` = 1709509 OR `props-main`.`id` = 1693978 OR `props-main`.`id` = 1716676 OR `props-main`.`id` = 1712631 OR `props-main`.`id` = 1703915 OR `props-main`.`id` = 1695993 OR `props-main`.`id` = 1695988 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1705574 OR `props-main`.`id` = 1710213 OR `props-main`.`id` = 1711200 OR `props-main`.`id` = 1683222 OR `props-main`.`id` = 1709626 OR `props-main`.`id` = 1716511 OR `props-main`.`id` = 1715688 OR `props-main`.`id` = 1700055 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1685150 OR `props-main`.`id` = 1710112 OR `props-main`.`id` = 1688289 OR `props-main`.`id` = 1712341 OR `props-main`.`id` = 1713564 OR `props-main`.`id` = 1705014 OR `props-main`.`id` = 1702478 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1700881 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1704102)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637223' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-17' 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();
14
Similar Properties
$464,900
3
2
1,494
0.16
2746 Beverly Ave
Clovis, CA 93611
$459,900
3
2
1,540
0.13
7206 E Dayton Ave
Fresno, CA 93737
$450,000
3
2
1,620
0.15
793 Applegate Ave
Clovis, CA 93611
$449,950
3
2
1,540
0.12
3199 N Schneider Ave
Fresno, CA 93737
Courtesy of Connie Pritchard, Northstar Properties, Inc. - [email protected] Last modified 5 days ago Fresno MLS last checked for updates 3 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.
