Welcome to your dream home in a desirable area. This beautiful 4 bed room 2 bathroom well taken care home with open floor and large great room, Once you enter the living room, you'll love the open floor plan whole house have tile floor, ceiling fan in living room and two bedrooms.This well-maintained gem is ready for its new owner to create lasting memories. Call for private showing and start enjoying all the comforts this home has to offer! Sale is contingent on the Sellers finding suitable replacement property. This house have 2 car finished garage. There is plenty of room in the back yard if the new buyer wants to put swimming pool or he can landscape the way of his choice.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2007
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$243
Price Per Acre
$2,484,645
Days On Market
91
Cumulative Days On Market
91
County
Fresno
REO / Bank Owned
No
Cross Street Address
Nelson Ave / Dustin Ave
Directions
From 99 FWY take exit on Merced Ave , go west which turns into Summer Ave, turn right on Sunnyside Ave, turn right on W Dustin Ave and turn left on Carey Ave. House is on the left side.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 422750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 467250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1578 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2078 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` = 1687668 OR `props-main`.`id` = 1674515 OR `props-main`.`id` = 1696878 OR `props-main`.`id` = 1638007 OR `props-main`.`id` = 1683529 OR `props-main`.`id` = 1696622 OR `props-main`.`id` = 1696610 OR `props-main`.`id` = 1691116 OR `props-main`.`id` = 1696626 OR `props-main`.`id` = 1690803 OR `props-main`.`id` = 1694210 OR `props-main`.`id` = 1695082 OR `props-main`.`id` = 1666367 OR `props-main`.`id` = 1691229 OR `props-main`.`id` = 1696125 OR `props-main`.`id` = 1654710 OR `props-main`.`id` = 1684419 OR `props-main`.`id` = 1694237 OR `props-main`.`id` = 1696165 OR `props-main`.`id` = 1684612 OR `props-main`.`id` = 1679530 OR `props-main`.`id` = 1697290 OR `props-main`.`id` = 1665590 OR `props-main`.`id` = 1681207 OR `props-main`.`id` = 1649065)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno629043' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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();
1
Similar Properties
$465,000
4
2
1,828
0.18
1113 Maple Ave
Fowler, CA 92056
Courtesy of Gurnek Nagra, RE/MAX Gold - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 23 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.
