Brickell Listings

Features
: Community
: Other , Water
: Restrictions Or Possible Restrictions , No
: Furnished
1
1
Property Description

Centrally located, bright, spacious and tastefully furnished 2 bed 2 bath unit, large balcony with amazing water and city views in building with resort style amenities: two large heated pools, jacuzzi, BBQ area, gym, 24 hours concierge and more. Walking distance to malls and several restaurants and shops.

Condo For Rent at THE PLAZA 851 BRICKELL CO

950 Brickell Bay Dr #2607, Miami, Florida 33131

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 986 Sqft
$5,400
Listing ID#A11568379
QR Code
Basic Details
Subdivision : 950 Brickell Bay
Building Name : THE PLAZA 851 BRICKELL CO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11568379
Price : $5,400
Original Price : $5,400
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 986 Sqft
Year Built : 2008
Property Sub Type : Condominium
DOM : 0
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 `googlemap_lt` >= 25.771104706667764 AND `googlemap_lt` <= 25.79559143545923 AND `googlemap_ln` >= -80.21488014147577 AND `googlemap_ln` <= -80.16061225852424 AND `price_si` <= '999999999999' AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY FIELD(p.zip_name, 33131) DESC, p.price_si ASC , p.id ASC LIMIT , 1

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