Brickell Listings

Features
: Bay
: Restrictions Or Possible Restrictions
: Furnished
1
1
Property Description

This exceptional 2-bedroom, 2-bathroom condo is a true coastal paradise, offering breathtaking Intracoastal views that will leave you in awe. The spacious patio is the perfect place to soak in the scenic beauty and entertain guests while savoring the coastal breeze. What sets this property apart is its unique feature – Airbnb and short-term rental allowance, making it an ideal investment opportunity. Enjoy the luxury of modern living, complete with contemporary amenities and the convenience of a prime location. Don’t miss your chance to own this dream condo with both comfort and profit potential!

Condo For Sale at MARINA BAY CLUB CONDO HOT

18100 N Bay Rd #302, Sunny Isles Beach, Florida 33160

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,255 Sqft
$800,000
Listing ID#A11476365
QR Code
Basic Details
Building Name : MARINA BAY CLUB CONDO HOT
Property Type : Condo
Listing Type : Sold
Listing ID : A11476365
Price : $850,000
Original Price : $850,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,255 Sqft
Year Built : 2002
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 591
DOM : 13
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