Brickell Listings

Features
: In Ground , Community
: Other
: Unfurnished
1
1
Property Description

Beautiful studio in the heart of Brickell. Porcelain floors. Nice views of the city and partial bay view from your balcony. One assigned covered parking place. Building offers pool, gym, social/business rooms, laundry, 24-hour security. NOTE: Landlord will only consider a 12-month lease, renewable. No short term, no subleasing. Thank you.

Condo For Rent at THE CLUB AT BRICKELL BAY,The Club at Brickell

1200 Brickell Bay Dr #1510, Miami, Florida 33131

  • Bathrooms : 1
  • Square Footage: 425 Sqft
$2,400
Listing ID#A11567048
QR Code
Basic Details
Subdivision : 1200 Brickell Bay
Building Name : THE CLUB AT BRICKELL BAY,The Club at Brickell
Property Type : Condo
Listing Type : For Rent
Listing ID : A11567048
Price : $2,400
Original Price : $2,400
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 425 Sqft
Year Built : 2005
Property Sub Type : Condominium
DOM : 5
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