Own a waterfront 2 bedroom, 2 bath condo , in the heart of the Brickell neighborhood (Miami’s Manhattan), home to the posh Delilah’s waterfront restaurant, 2 olympic size pools, poolside bar, gym, and a myriad of convenience stores including other restaurants, a grocery store, beauty salons, and retail stores, located in its vast lobby. Building offers valet parking 24 hours, on site security Unit is in original condition, but very clean and well maintained. Renovate to your heart’s content and enjoy the lifestyle for a fraction of the cost. $37/month additional fee to fund reserves.
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