Brickell Listings

Features
: Heated , In Ground , Community
: Canal , Other
: Maximum 20 Lbs
: Unfurnished
1
1
Property Description

Nice an bright 1/1.5 unit with Bay views from balcony. Great location. King Cole Condominium has great amenities including pool, renovated gym, marina, party room and more. Great location minutes away from beach, stores and restaurantes. Maintenance includes electricity. Unit has new impact windows. Easy to show

Condo For Rent at KING COLE CONDO

900 Bay Dr #907, Miami Beach, Florida 33141

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 920 Sqft
$2,550
Listing ID#A11431743
QR Code
Basic Details
Building Name : KING COLE CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11431743
Price : $2,550
Original Price : $2,800
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 920 Sqft
Year Built : 1963
Property Sub Type : Condominium
DOM : 136
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