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/641237/5626-W-Carmen-Ave/Fresno/https://www.londonproperties.com/images/props/fresno/full/641237.jpgLondon Properties Fresno Real Estate | 5626 W Carmen Ave
Here is a 2005 Home located on a cul-de-sac in the Central Unified School District, featuring many upgrades such as the impressive floors just recently done, it will surely grab your attention for easy cleaning, maintenance and elegance. the nice fireplace in the living room will keep you warm in the winter on an open floor plan set up. Don't miss out on this opportunity to own this home, call your Realtor for a private show today we only need about three hours notice, very easy to show.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$254
Price Per Acre
$2,317,141
Days On London
125
Cumulative Days On London
125
County
Fresno
REO / Bank Owned
No
Cross Street Address
Mckinley Ave
Directions
Go west from Polk and McKinley to left on Carnegie Ave and left on Carmen Ave to property on the left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 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) >= 1382 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1882 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` = 1675273 OR `props-main`.`id` = 1708001 OR `props-main`.`id` = 187712 OR `props-main`.`id` = 1724037 OR `props-main`.`id` = 1697222 OR `props-main`.`id` = 1718147 OR `props-main`.`id` = 1724045 OR `props-main`.`id` = 1723159 OR `props-main`.`id` = 1716472 OR `props-main`.`id` = 1705341 OR `props-main`.`id` = 1718782 OR `props-main`.`id` = 1725941 OR `props-main`.`id` = 1718790 OR `props-main`.`id` = 1725366 OR `props-main`.`id` = 1703904 OR `props-main`.`id` = 1703868 OR `props-main`.`id` = 1720112 OR `props-main`.`id` = 1726020 OR `props-main`.`id` = 1725984 OR `props-main`.`id` = 1726905 OR `props-main`.`id` = 1718678 OR `props-main`.`id` = 1723796 OR `props-main`.`id` = 804394 OR `props-main`.`id` = 1691526 OR `props-main`.`id` = 1691547 OR `props-main`.`id` = 1724623 OR `props-main`.`id` = 187713 OR `props-main`.`id` = 1718779 OR `props-main`.`id` = 1725617 OR `props-main`.`id` = 1722939 OR `props-main`.`id` = 1724013 OR `props-main`.`id` = 1728581 OR `props-main`.`id` = 1725106 OR `props-main`.`id` = 1717665 OR `props-main`.`id` = 1719166 OR `props-main`.`id` = 1725503 OR `props-main`.`id` = 160601 OR `props-main`.`id` = 1709206 OR `props-main`.`id` = 1702615 OR `props-main`.`id` = 1717390 OR `props-main`.`id` = 1721281 OR `props-main`.`id` = 1713026 OR `props-main`.`id` = 1718848 OR `props-main`.`id` = 1713605 OR `props-main`.`id` = 1665977 OR `props-main`.`id` = 1720499 OR `props-main`.`id` = 1727667 OR `props-main`.`id` = 1726964 OR `props-main`.`id` = 1729519 OR `props-main`.`id` = 1727003 OR `props-main`.`id` = 1726206 OR `props-main`.`id` = 1728053 OR `props-main`.`id` = 1722484 OR `props-main`.`id` = 985326 OR `props-main`.`id` = 1724724 OR `props-main`.`id` = 249079 OR `props-main`.`id` = 1711243 OR `props-main`.`id` = 1726399 OR `props-main`.`id` = 1726103 OR `props-main`.`id` = 1708197 OR `props-main`.`id` = 1725418 OR `props-main`.`id` = 1722404)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641237' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-29' 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();
7
Similar Properties
$435,000
4
2
1,833
0.15
3770 W Princeton Ave
Fresno, CA 93722
$429,500
4
2
1,800
0.16
2150 N Rosendo Ave
Fresno, CA 93722
$419,963
4
2
1,778
0.14
3383 N Forestiere Ave
Fresno, CA 93722
$395,000
3
2
1,667
0.14
4068 W Weldon Ave
Fresno, CA 93722
Courtesy of Rosalio Avila, Diversity Real Estate - [email protected] Last modified 2 weeks ago Fresno MLS last checked for updates 5 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.
