Brickell Listings

Features
: In Ground
: Intracoastal View , Ocean , Water
: Unfurnished
1
1
Property Description

1/1.5 PENTHOUSE UNIT ON THE 15TH FLOOR WITH VIEWS OF THE BAY AND DOWNTOWN SKYLINE. OPEN KITCHEN WITH GRANITE COUNTER TOP, LARGE LIVING AND DINING ROOM, GUEST BATHROOM AND LOTS OF CLOSETS. LIVING ROOM AND BEDROOM EXIT TO A SHARE LARGE BALCONY. AMENITIES INCLUDE GYM, POOL, JACUZZI, BBQ, PARTY ROOM, PRIVATE MARINA, 24HR CONCIERGE AND MORE. SHUTTERS.
****POOL IS UNDER RENOVATIONS AND IS CURRENTLY CLOSED*****

Condo For Rent at BRICKELL BISCAYNE CONDO,BRICKELL BISCAYNE CO

150 SE 25 RD #15E, Miami, Florida 33129

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 799 Sqft
$2,590
Listing ID#A11564070
QR Code
Basic Details
Subdivision : 150 SE 25
Building Name : BRICKELL BISCAYNE CONDO,BRICKELL BISCAYNE CO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11564070
Price : $2,590
Original Price : $2,590
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 799 Sqft
Year Built : 1969
Property Sub Type : Condominium
DOM : 25
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