Brickell Listings

Features
: Intracoastal View , Direct Ocean , Lagoon
: Restrictions Or Possible Restrictions
: Furnished
144
1
1
Property Description

AMAZING OCEAN WITH RARE INTRACOASTAL UNOBSTRUCTIVE VIEWS FROM EVERY ROOM. IMMACULATE PENTHOUSE UNIT HAS PLENTY OF NATURAL LIGHT FROM UNIT, HIGH CEILINGS AND LONG BALCONY. THIS HOME HAS LARGE BEDROOMS & WALK-IN CLOSETS, STONE AND WOOD FLOORS, EAT-IN KITCHEN & OPEN CONCEPT FORMAL DINING/LIVING AND DEN AREA. THE BUILDING THAT HAS JUST BEEN UPDATED W/MARBLE FLOORS & CONTEMPORARY LOBBY. WELL EQUIPPED GYM, POOLS, HOT TUBS, PICKLEBALL, TENNIS COURTS & VALET. WALK ALONG THE MARINA TO RESTAURANTS & SHOPS. FREE SHUTTLE BUS TO AVENTURA MALL & POINTS OF INTEREST. SEE VIDEO UNDER OFFICE REMARKS

Condo For Sale at HARBOR TWS AT THE WATERWA,PORTSVIEW AT THE WAT

3598 Yacht Club Dr #PH-4, Aventura, Florida 33180

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,460 Sqft
$674,818
Listing ID#A11561898
QR Code
Basic Details
Subdivision : 3598 Yacht Club
Building Name : HARBOR TWS AT THE WATERWA,PORTSVIEW AT THE WAT
Property Type : Condo
Listing Type : For Sale
Listing ID : A11561898
Price : $674,818
Original Price : $674,818
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,460 Sqft
Year Built : 1993
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 1652
DOM : 30
Tax : $6,600
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