Brickell Listings

Features
: Automatic Chlorination
: Direct Ocean
: Maximum 20 Lbs
: Furnished
1
1
Property Description

OCEANFRONT STUDIO IN AVENTURA BEACH CLUB. TILE FLOORS, KITCHEN WITH FRIDGE, MICROWAVE AND STOVE. THE UNIT HAS OCEANFRONT VIEW, NO BALCONY. ENJOY THE VIEW FROM THIS AFFORDABLE OCEANFRONT STUDIO. MINIMUM RENT 1 MONTH, AND MAX 6 MONTHS. CLOSE TO AIRPORTS, SHOPPING, RESTAURANTS, AND PARKS. THE TENANT IS RESPONSIBLE FOR TAX 13 PERCENT PAID TO HOTEL, PARKING $500 PER MONTH, CLEANING FEE $150. AVAILABLE 02/11/2024. APPLICATION FEE IS $250

Condo For Rent at THE AVENTURA BEACH CLUB C

19201 Collins Ave #248, Sunny Isles Beach, Florida 33160

  • Bathrooms : 1
  • Square Footage: 410 Sqft
$2,400
Listing ID#A11062187
QR Code
Basic Details
Subdivision : 19201 Collins
Building Name : THE AVENTURA BEACH CLUB C
Property Type : Condo
Listing Type : For Rent
Listing ID : A11062187
Price : $2,400
Original Price : $2,000
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 410 Sqft
Year Built : 1966
Property Sub Type : Condominium
DOM : 1018
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