AVAIL OCT 15 FOR A SHORT AND LONG TERM RENT. A lovely studio in the oceanfront building in Sunny Isles Beach. Side ocean view. Walking distance to the plazas, shops, restaurants, and cafeterias. A nice park with entertainments for kids across the street. Aventura Mall is in walking distance across the bridge. Bus station near the building to reach Saw Grass Mall. Cafeterias, pizzeria, and mini-shops inside the building create additional convenience. Electricity, Internet, cable TV included.
Condo For Rent at THE AVENTURA BEACH CLUB C
19201 Collins Ave #717, Sunny Isles Beach, Florida 33160
- Bathrooms : 1
- Square Footage: 360 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 574
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com