Brickell Listings

Features
: Above Ground
: Bay
: Restrictions Or Possible Restrictions , No
: Furnished
1
1
Property Description

Stunning bay views from this 1 Bed/1.5 Bath with wraparound balcony furnished corner unit in Brickell Key. Most desirable line 05 with no neighbors. Recently remodeled closet, bathrooms. Floor to ceiling windows. Marble flooring throughout. Large master bedroom with walk in closet. Live within the private community of Brickell key with restaurants, shops, and more. 1 Assigned Parking Space.

Condo For Rent at ONE TEQUESTA POINT CONDO

888 Brickell Key Dr #2605, Miami, Florida 33131

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 780 Sqft
$3,500
Listing ID#A11473317
QR Code
Basic Details
Subdivision : 888 Brickell Key
Building Name : ONE TEQUESTA POINT CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11473317
Price : $3,500
Original Price : $3,900
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 780 Sqft
Year Built : 1995
Property Sub Type : Condominium
DOM : 163
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