Rare opportunity to own your own Luxury Condo in Reedley! High-grade modern upgrades throughout and fully loaded appliances. Stunning features include rain shower heads (multi-functions) separate handheld sprayers, waterfall tub spout, custom niche shelves, black matte hardware, bars, hooks, GORGEOUS custom glass doors, ambient lighting with dimmers, black stainless dishwasher, microwave and fully loaded glass cooktop range with BUILT-IN Air-Fryer and self cleaning function! New flooring, cabinets and counters throughout. This list goes ON & ON with nothing but the best, complete with permits. The unit is setup for an interior stackable washer/dryer (not included). Whether you're a first-time buyer, looking to down-size or seeking an investment opportunity, this condo offers a wonderful package of comfort! (HOA fee include cost of your monthly water trash and sewer bills)
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Condominium
Year Built
1979
Region
Urban
# of Stories
Two
Price Per Square Foot
$225
Price Per Acre
$9,808,612
Days On London
171
Cumulative Days On London
171
County
Fresno
REO / Bank Owned
No
Cross Street Address
Reed
Directions
From the college head south on Reed ave. Make a right (east) on Parlier Ave. 1 block down, this complex is on the left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 194750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 215250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 662 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1162 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` = 1710136 OR `props-main`.`id` = 1736411 OR `props-main`.`id` = 1736426 OR `props-main`.`id` = 1761049 OR `props-main`.`id` = 1763236 OR `props-main`.`id` = 1747885 OR `props-main`.`id` = 1725463 OR `props-main`.`id` = 1718512 OR `props-main`.`id` = 1664620 OR `props-main`.`id` = 1664617 OR `props-main`.`id` = 1724701 OR `props-main`.`id` = 1724627 OR `props-main`.`id` = 1725147 OR `props-main`.`id` = 1725749 OR `props-main`.`id` = 1725120 OR `props-main`.`id` = 1746836 OR `props-main`.`id` = 1750268 OR `props-main`.`id` = 1751583 OR `props-main`.`id` = 1665887 OR `props-main`.`id` = 1713258 OR `props-main`.`id` = 1713277 OR `props-main`.`id` = 1727889 OR `props-main`.`id` = 1750744 OR `props-main`.`id` = 1736361 OR `props-main`.`id` = 1700073 OR `props-main`.`id` = 1704481 OR `props-main`.`id` = 1754589)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644746' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-22' 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
Last modified 2 hours ago Fresno MLS last checked for updates 18 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.
