Brickell Listings

Features
: In Ground
: Intracoastal View , Ocean , Water
: Furnished
0
0
Property Description

RARE FIND IN THE HEART OF AVENTURA. The fully furnished unit has been COMPLETELY RENOVATED. Luxurious 2 bed, 2 bath residence with a spectacular 180-degree ocean & Intracoastal views. Remodeled kitchen features quartz countertops, glossy lacquer cabinets, tons of storage space, & stainless steel appliances It is a two-bedroom two bath unit that is ready to move in. The unit will impress you. Wash and Dryer connections. Close to the beach restaurants, malls, and the highway. Wonderful view of the ocean and the Intracoastal. WILL NOT LAST

Condo For Rent at WATERVIEW CONDO

20505 E Country Club Dr #1031, Aventura, Florida 33180

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,038 Sqft
$3,500
Listing ID#A11431499
QR Code
Basic Details
Subdivision : 20505 E Country Club
Building Name : WATERVIEW CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11431499
Price : $3,500
Original Price : $3,800
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,038 Sqft
Year Built : 1981
Property Sub Type : Condominium
DOM : 178
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