Listing Agent: Mark Rose, Golden Gate Sotheby's Int'l Listing Co-Agent: OUT OF AREA OUT, Home & Land Agency
Fixer opportunity with exceptional scale. This 3,600 square foot two story home offers the kind of size and layout that rarely comes to market at this price point, with 4 bedrooms, 3.5 bathrooms, and a 3 car garage set on an oversized corner lot. The generous proportions and flexible floor plan present a compelling canvas for renovation, inviting investors, contractors, or buyers with vision to reimagine the space and unlock its full potential. Properties of this size offer a rare opportunity to transform the home into something truly distinctive. The property is being sold as is and reflects its current condition. Disclosure package available soon.
Property Sub Type
Single Family Residence
Year Built
1955
Levels
Two
Price Per Square Foot
$153
Days On London
9
Cumulative Days On London
9
County Or Parish
Fresno
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Jensen Ave to Lyon Ave Cross Street: Webster St.
Cooling
Central Air
Roof
Shingle
Construction Materials
See Remarks
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Bathrooms Half
1
Room Kitchen Features
Tile Counters
Appliances Y/N
Yes
Flooring
Wood
Fireplace Y/N
Yes
Fireplace Features
Wood Burning
Pool Private Y/N
No
Patio Y/N
Yes
Parking Total
6.00
Attached Garage Y/N
No
Garage Spaces
3.00
Lot Features
Corner Lot, Back Yard
Lot Size Area
14700.0000
Lot Size Units
Square Feet
Parcel Number
31512301
Subdivision Name
Not Listed
Subdivision Name Other
Not Listed
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 522405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 577395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3352 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3852 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` = 1684982 OR `props-main`.`id` = 1694468 OR `props-main`.`id` = 1684978 OR `props-main`.`id` = 1710272 OR `props-main`.`id` = 1707153 OR `props-main`.`id` = 1636192 OR `props-main`.`id` = 1640777 OR `props-main`.`id` = 63187 OR `props-main`.`id` = 224353 OR `props-main`.`id` = 1713289 OR `props-main`.`id` = 1695150 OR `props-main`.`id` = 1694494 OR `props-main`.`id` = 1695260 OR `props-main`.`id` = 1707907 OR `props-main`.`id` = 1705644 OR `props-main`.`id` = 1695262 OR `props-main`.`id` = 1695261 OR `props-main`.`id` = 1713583 OR `props-main`.`id` = 1710093 OR `props-main`.`id` = 1713220 OR `props-main`.`id` = 1713263 OR `props-main`.`id` = 1698478 OR `props-main`.`id` = 1694694 OR `props-main`.`id` = 1694695 OR `props-main`.`id` = 1694720 OR `props-main`.`id` = 1694721 OR `props-main`.`id` = 1700113 OR `props-main`.`id` = 1700114 OR `props-main`.`id` = 1700116 OR `props-main`.`id` = 1700117 OR `props-main`.`id` = 1701454 OR `props-main`.`id` = 1650401 OR `props-main`.`id` = 1693518 OR `props-main`.`id` = 994639 OR `props-main`.`id` = 1703742 OR `props-main`.`id` = 1688790 OR `props-main`.`id` = 1713858 OR `props-main`.`id` = 1690762 OR `props-main`.`id` = 1705928 OR `props-main`.`id` = 1702895 OR `props-main`.`id` = 1702893 OR `props-main`.`id` = 1685233 OR `props-main`.`id` = 1706097 OR `props-main`.`id` = 1695279 OR `props-main`.`id` = 1712402 OR `props-main`.`id` = 1705690 OR `props-main`.`id` = 1710289 OR `props-main`.`id` = 1713819 OR `props-main`.`id` = 1696648)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41125926' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-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();
0
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.
