Brickell Listings

Features
: In Ground
: Ocean
: Furnished
1
1
Property Description

Amazing Unit in the Heart of Sunny Isles Beach. -First class amenities including Beach Club with all upscale services. Health & Fitness Center and Spa, 4 Restaurants, Bars, Tennis, KidsClub, Hotel Services such as 24 hour room services, etc – you never have to leave!!! One bedroom 1.5 bath, furnished and fully equipped immaculate – Available April 29, 2024 to October 30, 2024.

Condo For Rent at TRUMP ROYALE CONDO

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

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 881 Sqft
$4,000
Listing ID#A11552838
QR Code
Basic Details
Subdivision : 18201 COLLINS
Building Name : TRUMP ROYALE CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11552838
Price : $4,000
Original Price : $4,000
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 881 Sqft
Year Built : 2008
Property Sub Type : Condominium
DOM : 1
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 `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY FIELD(p.zip_name, 33131) DESC, p.price_si ASC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent