Brickell Listings

Features
: Community
: Bay
: Dogs Ok
: Furnished
1
1
Property Description

Amazing and impeccable furnished apartment located in the most prestigious area of Brickell. Beautiful water views from the balcony, luxury amenities, 24 hour concierge attendant, 24 hour security and valet parking.

Condo For Rent at THE PLAZA 851 BRICKELL CO,THE PLAZA

950 Brickell Bay Dr #3006, Miami, Florida 33131

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 986 Sqft
$4,500
Listing ID#A11552993
QR Code
Basic Details
Subdivision : 950 Brickell Bay
Building Name : THE PLAZA 851 BRICKELL CO,THE PLAZA
Property Type : Condo
Listing Type : For Rent
Listing ID : A11552993
Price : $4,500
Original Price : $4,680
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 986 Sqft
Year Built : 2008
Property Sub Type : Condominium
DOM : 30
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