BEAUTIFUL 1BD/1BA LARGEST UNIT AT ICON BRICKELL TOWER 1 WITH MIAMI SKYLINE AND RIVER VIEWS. OPEN FLOOR PLAN WITH BIG BEDROOM, WALKING CLOSET, MARBLE BATHROOM AND ITALIAN KITCHEN WITH TOP OF THE LINE APPLIANCES, BOSCH AND SUB-ZERO AND FLOOR TO CEILING WINDOWS. ENJOY LIVING IN THE HEART OF BRICKELL, STATE OF THE ART AMENITIES AND WORLD CLASS RESTAURANTS ON SITE. UNIT IS VACANT, EASY TO SHOW.
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