Brickell Listings

Features
: Ocean View , Direct Ocean , Skyline
: Restrictions Or Possible Restrictions
0
0
Property Description

Luxury living at the Trump Royale in this completely & newly renovated 2 bed 2.5 bath with no expense spared.?Enjoy breathtaking direct ocean views and spectacular city & intercostal views from every room. The balcony is very large and offers plenty of space for outdoor dining and lounging.?Italian design kitchen w/new appliances, marble island counter top, new floors and new bathrooms. Building offers 5 star amenities two floor health spa, private resident pool and beach services. Residents get free full access to the Trump Resort next door and all their amenities including 3 restaurants, beach bar, spa, gym, 2 swimming pools & hot-tubs, live entertainment, water sports, salon, tennis, basketball, concierge service and more. Walking distance to shopping and house of worship. Act fast!

Condo For Sale at TRUMP ROYALE CONDO

18201 Collins Ave #1102, Sunny Isles Beach, Florida 33160

  • Bedrooms : 2
  • Bathrooms : 3
  • Square Footage: 1,499 Sqft
$1,589,000
Listing ID#A11564415
QR Code
Basic Details
Subdivision : 18201 COLLINS
Building Name : TRUMP ROYALE CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11564415
Price : $1,589,000
Original Price : $1,589,000
Bedrooms : 2
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,499 Sqft
Year Built : 2008
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 1584
DOM : 22
Tax : $13,288
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