Brickell Listings

Features
: In Ground
: Garden
: Maximum 20 Lbs
: Furnished
1
1
Property Description

Beautiful renovated apt with white porcelanato floors, open floor plan with open kitchen and spacious living room with balcony facing the golf course.
King size bed in master bedroom with walk in closet.
Second bedroom with two full size beds and third bedroom with a sofa bed.
Open for the season starting January 10, 2024.
Call listing agent to schedule appointments.

Condo For Rent at THE YACHT CLUB AT AVENTUR

19901 E Country Club Dr #2401, Aventura, Florida 33180

  • Bedrooms : 3
  • Bathrooms : 4
  • Square Footage: 1,330 Sqft
$5,500
Listing ID#A11474967
QR Code
Basic Details
Subdivision : 19901 E Country Club
Building Name : THE YACHT CLUB AT AVENTUR
Property Type : Condo
Listing Type : For Rent
Listing ID : A11474967
Price : $5,500
Original Price : $5,500
Bedrooms : 3
Bathrooms : 4
Half Bathrooms : 2
Square Footage : 1,330 Sqft
Year Built : 1994
Property Sub Type : Condominium
DOM : 212
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