Brickell Listings

Features
: Community
: Restrictions Or Possible Restrictions
: Unfurnished
0
0
Property Description

This stunning 2BD/2BA unit in the Brickell neighborhood includes water and light in the price. Centrally situated in the heart of Brickell, close to Downtown Miami, the building boasts amenities such as two Olympic-sized swimming pools, an outdoor spa, jacuzzi, restaurants, a beauty salon, a poolside bar, a grocery store, a lobby café/bakery, a marina, valet parking, and 24-hour security.

Condo For Rent at FOUR AMBASSADORS CONDO PH

801 Brickell Bay Dr #1567, Miami, Florida 33131

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 990 Sqft
$3,000
Listing ID#A11560214
QR Code
Basic Details
Subdivision : 801 Brickell Bay
Building Name : FOUR AMBASSADORS CONDO PH
Property Type : Condo
Listing Type : For Rent
Listing ID : A11560214
Price : $3,000
Original Price : $3,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 990 Sqft
Year Built : 1968
Property Sub Type : Condominium
DOM : 12
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