Beautiful 4 story waterfront townhouse at Aqua at Allison Island, deeded boat dock. 5 bedrooms plus den, wet bar, 5 full and 2 half bath, 2 car garage, this beautiful town house offered fully furnished by a designer. Spacious roof top terrace with panoramic Intracoastal and city view, large balconies, amenities include 2 swimming pools, hot tub, exercise room, spa, children’s play room, concierge, mini market, management office on site, 24 hour security at the gate.
Condo For Sale at AQUA AT ALLISON ISLAND
215 Water Way #215, Miami Beach, Florida 33141
- Bedrooms : 5
- Bathrooms : 7
- Square Footage: 4,391 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
