Brickell Listings

Features
: Heated , Above Ground
: Ocean
: Maximum 20 Lbs
: Furnished
1
1
Property Description

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
$2,500
Listing ID#A11468574
QR Code
Basic Details
Building Name : THE AVENTURA BEACH CLUB C
Property Type : Condo
Listing Type : For Rent
Listing ID : A11468574
Price : $2,500
Original Price : $2,500
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 360 Sqft
Year Built : 1966
Property Sub Type : Condominium
DOM : 2
Search Results

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

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent