Brickell Listings

Features
: Other
: Yes , No
: Furnished
3
2
Property Description

Cozy, beautiful, fully furnished apartment available for rent for a period of up to 6 months, available immediately. It features a large one bedroom and one and a half baths. Parking and all utilities included. The building has 24-hr security, valet, concierge, gym and is conveniently located close to all shopping, places of worship, and other amenities. For more information or to inquire about renting the apartment, please review the broker’s remarks for contact details.

Condo For Rent at *TURNBERRY TOWERS CONDO,TURNBERRY TOWERS

19355 TURNBERRY WAY #2C, Sunny Isles Beach, Florida 33180

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 1,077 Sqft
$3,250
Listing ID#A11526513
QR Code
Basic Details
Subdivision : 19355 Turnberry
Building Name : *TURNBERRY TOWERS CONDO,TURNBERRY TOWERS
Property Type : Condo
Listing Type : For Rent
Listing ID : A11526513
Price : $3,250
Original Price : $3,250
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,077 Sqft
Year Built : 1981
Property Sub Type : Condominium
DOM : 49
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