Brickell Listings

Features
: In Ground
: Intracoastal View , Ocean , Golf Course
: Unfurnished
0
0
Property Description

MOVE IN READY!!! This 2 bedroom 2 bath is located on Turnberry Golf Course with beautiful views of golf, ocean and city skyline to the North. Newly painted, new kitchen lighting and new berber carpeting throughout. Excellent amenities include pool, jacuzzi, tennis courts, game room, party room, fitness center, 24 hour security, 24 hour manned front gate, 24 hour front desk attendant, valet and more! Association requires a 650 credit score, 75K income per and a minimum 2 year lease as per association.

Condo For Rent at DELVISTA TOWERS CONDO

20355 NE 34th Ct #1521, Aventura, Florida 33180

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,180 Sqft
$2,700
Listing ID#A11498186
QR Code
Basic Details
Subdivision : 20355 NE 34th
Building Name : DELVISTA TOWERS CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11498186
Price : $2,700
Original Price : $2,850
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,180 Sqft
Year Built : 1982
Property Sub Type : Condominium
DOM : 134
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