Brickell Listings

Features
: In Ground
: Bay
: Unfurnished
0
0
Property Description

Great view and location, One bedroom and 1.5 bathroom very spacious condo with 918 sqft on the 14th floor, located in Williams Island nice, private and quiet locations. This Bright and open unit offers a quiet and peaceful water view! Porcelain floors, open kitchen and updated bathrooms, walking closet and extra storage space. Security is a plus, gated community with 24h attended lobby, valet parking, pool, jacuzzi, gym, Tennis court and more. You can enjoy a Walking distance for a coffee, Steps away from Aventura Mall, shops, golf course, parks, and Restaurants. Freshly Painted, impact windows will be installed.

Condo For Rent at THE CLIPPER AT BISC COVE,Biscayne Cove

18151 NE 31st Ct #1405, Aventura, Florida 33160

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 918 Sqft
$2,300
Listing ID#A11571025
QR Code
Basic Details
Subdivision : 18151 NE 31st
Building Name : THE CLIPPER AT BISC COVE,Biscayne Cove
Property Type : Condo
Listing Type : For Rent
Listing ID : A11571025
Price : $2,300
Original Price : $2,300
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 918 Sqft
Year Built : 1981
Property Sub Type : Condominium
DOM : 5
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