2/2 CORNER UNIT IN ONE OF THE BEST LUXURY BUILDINGS IN BRICKELL, INCOME PRODUCING PROPERTY. GREAT INVESTMENT. NO RENTAL RESTRICTIONS, SHORT TERM LEASE ALLOWED INCLUDING AIRBNB. UNIT OFFERS HIGH QUALITY AND EFFICIENCY APPLIANCES, FULLY FURNISHED, WHITE PORCELAIN FLOORS. LOCATED IN THE HEART OF BRICKELL AVE, CLOSE TO DOWNTOWN, RESTAURANTS, SHOPS AND BRICKELL CITY CENTRE.
Condo Sold at ICON BRICKELL CONDO NO 3
485 Brickell Ave #3608, Miami, Florida 33131
- Bedrooms : 2
- Bathrooms : 2
- Square Footage: 1,459 Sqft
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 1' at line 1]SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `listing` = '9' AND `property_type` = '36' AND ( MATCH( `textsearch` ) AGAINST ( '(+"LOC-33131") "Listing ID 33131"' IN BOOLEAN MODE ) ) AND `show_address`='1' AND `f_140`='1' AND (`f_140_options` LIKE '%,1,%' OR `f_140_options` LIKE '%,3,%' OR `f_140_options` LIKE '%,4,%' OR `f_140_options` LIKE '%,5,%' OR `f_140_options` LIKE '%,6,%' OR `f_140_options` LIKE '%,7,%' OR `f_140_options` LIKE '%,8,%' OR `f_140_options` LIKE '%,9,%' OR `f_140_options` LIKE '%,10,%') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si DESC , p.id ASC LIMIT , 1
- Prev
- Result of 575
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com