Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/644857/5903-E-Butler-Ave/Fresno/Sunnyside/https://www.londonproperties.com/images/props/fresno/full/644857.jpgLondon Properties Fresno Real Estate | 5903 E Butler Ave
This Unique home in Sunnyside is an Estate Sale that has been cleared to sell. This Custom home in the prime Sunnyside area has over 3,000 sq. ft. with a 2 car garage and attached 2,000 sq. ft. finished SHOP with roll up doors!!! The tax records show 2 large bedrooms plus a third room that was used as a bedroom without a closet. The main home was updated with newer heating and cooling, newer steel roof and stucco, updated windows, and the primary bath has been remodeled. The home offers a living room, family room, formal dining, country kitchen, 2 fireplaces, large bedrooms and updated primary bath room. The home is located on a large corner 36,000 sq. ft. + lot with mature landscaping and fruit trees. located across from Sunnyside Country Club makes this home real find especially with the extra Shop and garage.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1956
Region
Urban
Unique Conditions
Estate Sale
# of Stories
Single Story
Price Per Square Foot
$281
Price Per Acre
$1,047,619
Days On London
12
Cumulative Days On London
12
County
Fresno
Reports Available
Prelim Title Report
Special Features
Built In Cabinets
REO / Bank Owned
No
Cross Street Address
E/Clovis
Directions
East of Clovis Ave on Butler to subject property
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heating, Central Cooling
Laundry
Inside, On Lower Level, Electric Hook Up
Roofing
Metal
Foundation
Wood Subfloor
Detached Structures
Other/See Remarks
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Eating Area, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 825550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 912450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2845 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3345 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` = 1713129 OR `props-main`.`id` = 1665721 OR `props-main`.`id` = 1704972 OR `props-main`.`id` = 168045 OR `props-main`.`id` = 1709148 OR `props-main`.`id` = 1719053 OR `props-main`.`id` = 1716780 OR `props-main`.`id` = 1702572 OR `props-main`.`id` = 1711226 OR `props-main`.`id` = 1719675 OR `props-main`.`id` = 1713809 OR `props-main`.`id` = 1712532 OR `props-main`.`id` = 1718569 OR `props-main`.`id` = 1718570 OR `props-main`.`id` = 1695956 OR `props-main`.`id` = 1690285 OR `props-main`.`id` = 1715480 OR `props-main`.`id` = 1694333 OR `props-main`.`id` = 1664666 OR `props-main`.`id` = 1719657 OR `props-main`.`id` = 1667622 OR `props-main`.`id` = 1719840 OR `props-main`.`id` = 1710189 OR `props-main`.`id` = 1703969 OR `props-main`.`id` = 1715576 OR `props-main`.`id` = 1703463 OR `props-main`.`id` = 1713351 OR `props-main`.`id` = 1707115 OR `props-main`.`id` = 1717023 OR `props-main`.`id` = 1717019 OR `props-main`.`id` = 1697805 OR `props-main`.`id` = 1712965 OR `props-main`.`id` = 735701 OR `props-main`.`id` = 1719676 OR `props-main`.`id` = 1719686 OR `props-main`.`id` = 1715922 OR `props-main`.`id` = 1646681 OR `props-main`.`id` = 1719002 OR `props-main`.`id` = 1709869 OR `props-main`.`id` = 1720297 OR `props-main`.`id` = 165776 OR `props-main`.`id` = 1708358 OR `props-main`.`id` = 1710115 OR `props-main`.`id` = 1713569 OR `props-main`.`id` = 1719658 OR `props-main`.`id` = 1696750 OR `props-main`.`id` = 1719715 OR `props-main`.`id` = 1712731 OR `props-main`.`id` = 1718830 OR `props-main`.`id` = 1717710 OR `props-main`.`id` = 1689029 OR `props-main`.`id` = 1711090 OR `props-main`.`id` = 1715966 OR `props-main`.`id` = 1718652 OR `props-main`.`id` = 1716178 OR `props-main`.`id` = 839521 OR `props-main`.`id` = 1719766 OR `props-main`.`id` = 1718846 OR `props-main`.`id` = 1716187 OR `props-main`.`id` = 1695731 OR `props-main`.`id` = 1719747 OR `props-main`.`id` = 1719185 OR `props-main`.`id` = 1703903 OR `props-main`.`id` = 1703920 OR `props-main`.`id` = 1718826 OR `props-main`.`id` = 1705942 OR `props-main`.`id` = 1717782 OR `props-main`.`id` = 1701796 OR `props-main`.`id` = 1704514 OR `props-main`.`id` = 1709931 OR `props-main`.`id` = 1703929 OR `props-main`.`id` = 1717899 OR `props-main`.`id` = 1716618 OR `props-main`.`id` = 1718662 OR `props-main`.`id` = 1703763 OR `props-main`.`id` = 1696453 OR `props-main`.`id` = 1705930 OR `props-main`.`id` = 1702954 OR `props-main`.`id` = 1702982 OR `props-main`.`id` = 1702961 OR `props-main`.`id` = 1688490)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644857' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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 Michael Dennen, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 20 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.
