Brickell Listings

Features
: Ocean View
: Restrictions Or Possible Restrictions
: Furnished , Turn Key Furnished
1
1
Property Description

DELUXE CONDO-HOTEL STUDIO AT TRUMP INTERNATIONAL BEACH RESORT IN THE HEART OF SUNNY ISLES BEACH. UNIT HAS DIRECT OCEAN VIEWS, IS FULLY FURNISHED AND CURRENTLY ENROLLED IN THE HOTEL PROGRAM. BUILDING HAS PRIVATE BEACH ACCESS, CONCIERGE SERVICE AND LUXURIOUS AMENITIES SUCH AS STATE OF THE ART SPA, TOP OF THE LINE FITNESS CENTER, RESTAURANTS, BAR, TWO LUSH POOLS, CHILDREN PLAY AREA, AND MANY MORE. CLOSE TO AVENTURA MALL AND BAL HARBOUR SHOPS. GREAT INVESTMENT OPPORTUNITY!

Condo For Sale at TRUMP INTERNATIONAL SONES

18001 Collins Ave #2706, Sunny Isles Beach, Florida 33160

  • Bathrooms : 1
  • Square Footage: 551 Sqft
$415,000
Listing ID#A11514639
QR Code
Basic Details
Building Name : TRUMP INTERNATIONAL SONES
Property Type : Condo
Listing Type : For Sale
Listing ID : A11514639
Price : $415,000
Original Price : $415,000
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 551 Sqft
Year Built : 2003
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 1733
DOM : 3
Tax : $4,623
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