Brickell Listings

Features
: Garden View , Intracoastal View
: Restrictions Or Possible Restrictions
: Furnished
1
0
Property Description

Fully furnished 2 Bedrooms 2 Bathrooms apt with direct water view located on the first floor. INVESTORS WELCOME!!! Short term rental allowed special for AIRBNB, minimum period 7 days, up to 52 rentals a year. Inside laundry, plenty of parking space, management on site, pool, tennis court, playground, exercise room, club house, gated community, pets allowed. Close to Aventura mall and beaches. Tenant occupied until April 6th, 2024. AS IS

Condo For Sale at THE YACHT CLUB AT AVENTUR

19655 E Country Club Dr #6108, Aventura, Florida 33180

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,100 Sqft
$549,999
Listing ID#A11516327
QR Code
Basic Details
Building Name : THE YACHT CLUB AT AVENTUR
Property Type : Condo
Listing Type : For Sale
Listing ID : A11516327
Price : $549,999
Original Price : $549,999
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,100 Sqft
Year Built : 1994
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 734
DOM : 0
Tax : $6,132
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