Exceptional 2/1, corner unit in the renovated Flagler First Condominiums located in the heart of Downtown Miami. Great unit with opportunity for Investment! Walking distances from all major shops and markets as well as entertainment venues. Just steps away from a convenient parking garage, WholeFoods, Restaurants, Brickell, Bayfront Park and many attractions that the soon to be upgraded Flagler Street has to offer. This unit features, an open floor plan, impact windows, new stainless steel appliances and washer and dryer in the unit. Tenant Occupied Until February 14th 2024.
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
brickellmania@gmail.com
Yanai Nassar / Sergio Cervantes
Brickellmania, LLC