Please provide the following information and Jasmin Quintana will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.quintanahomes.com/agent/19708/jasmin-quintana/property/link/fresno/650938/5583-W-Floradora-Ave/Fresno/https://www.quintanahomes.com/images/props/fresno/full/650938.jpgLondon Properties Fresno Real Estate | 5583 W Floradora Ave
Courtesy of Myesha Frazier-Taylor, Stark Complete Real Estate Services - mfrazierteam@aol.com
Beautiful 3-bedroom 2 bath home. OWNED SOLAR, NEW ROOF, NEW WINDOWS INSTALLED throughout home, specious bedrooms, tankless water heater, tandem garage, practical layout, low maintenance yards, large backyard, full bath in primary bedroom. Owner kept property in phenomenal condition. This property is a must see it will not last!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2003
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$232
Price Per Acre
$2,868,555
Days On London
3
Cumulative Days On London
3
County
Fresno
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
West Olive & North Polk
Directions
From Cross Streets, Head North on Polk, West on Floradora
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414750 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) >= 1455 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1955 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` = 1724744 OR `props-main`.`id` = 1744029 OR `props-main`.`id` = 1675273 OR `props-main`.`id` = 1708001 OR `props-main`.`id` = 187712 OR `props-main`.`id` = 1737060 OR `props-main`.`id` = 1730594 OR `props-main`.`id` = 1742571 OR `props-main`.`id` = 1697222 OR `props-main`.`id` = 1718147 OR `props-main`.`id` = 1724045 OR `props-main`.`id` = 1745143 OR `props-main`.`id` = 1739705 OR `props-main`.`id` = 1705341 OR `props-main`.`id` = 1718782 OR `props-main`.`id` = 1725941 OR `props-main`.`id` = 1718790 OR `props-main`.`id` = 1740308 OR `props-main`.`id` = 1703904 OR `props-main`.`id` = 1703868 OR `props-main`.`id` = 1720112 OR `props-main`.`id` = 1725984 OR `props-main`.`id` = 1726905 OR `props-main`.`id` = 804394 OR `props-main`.`id` = 1691526 OR `props-main`.`id` = 1691547 OR `props-main`.`id` = 187713 OR `props-main`.`id` = 1730654 OR `props-main`.`id` = 1718779 OR `props-main`.`id` = 1722939 OR `props-main`.`id` = 1724013 OR `props-main`.`id` = 1745307 OR `props-main`.`id` = 1743925 OR `props-main`.`id` = 1728581 OR `props-main`.`id` = 1725106 OR `props-main`.`id` = 1717665 OR `props-main`.`id` = 1739277 OR `props-main`.`id` = 160601 OR `props-main`.`id` = 1745747 OR `props-main`.`id` = 1702615 OR `props-main`.`id` = 1743902 OR `props-main`.`id` = 1718848 OR `props-main`.`id` = 1744668 OR `props-main`.`id` = 1665977 OR `props-main`.`id` = 1720499 OR `props-main`.`id` = 1742773 OR `props-main`.`id` = 1743255 OR `props-main`.`id` = 1729519 OR `props-main`.`id` = 1727003 OR `props-main`.`id` = 1726206 OR `props-main`.`id` = 1743847 OR `props-main`.`id` = 1728053 OR `props-main`.`id` = 1744866 OR `props-main`.`id` = 985326 OR `props-main`.`id` = 249079 OR `props-main`.`id` = 1726399)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650938' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-05' 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
$399,000
4
2
1,609
0.18
4033 W Providence Ave
Fresno, CA 93722
$389,999
4
2
1,736
0.15
2469 N Bendel
Fresno, CA 93722
$380,000
3
2
1,497
0.14
3043 N Brunswick Ave
Fresno, CA 93722
$378,000
3
2
1,497
0.13
4272 W Cortland Ave
Fresno, CA 93722
Last modified 9 hours ago Fresno MLS last checked for updates 49 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.
