Brickell Listings

Features
: Other View
1
1
Property Description

GREAT INVESTMENT OPPORTUNITY IN MARCO POLO IN SUNNY ISLES ON THE BEACH. THIS STUDIO CAN BE RENTED DAILY FOR SHORT TERM RENTALS AND AIRBNB NOW ON THE HOTEL PROGRAM. UTILITIES ARE INCLUDED IN THE MAINTENANCE SUCH AS WATER, CABLE, INTERNET, VALET PARKING AND ELECTRICITY. AMENITIES INCLUDE BEACH SERVICE, GYM, POOL, BAR, RESTAURANTS, SHOPS AND MORE.NOT IN THE HOTEL PROGRAM MOTIVATED SELLER

Condo For Sale at THE AVENTURA BEACH CLUB C

19201 Collins Ave #330, Sunny Isles Beach, Florida 33160

  • Bathrooms : 1
  • Square Footage: 410 Sqft
$213,990
Listing ID#A11491110
QR Code
Basic Details
Subdivision : 19201 Collins
Building Name : THE AVENTURA BEACH CLUB C
Property Type : Condo
Listing Type : For Sale
Listing ID : A11491110
Price : $213,990
Original Price : $218,000
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 410 Sqft
Year Built : 1966
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 1335
DOM : 158
Tax : $1,711
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