Brickell Listings

Features
: Bay
: Unfurnished
1
1
Property Description

BEAUTIFUL BAY VIEW APARTMENT FOR RENT IN DESIRABLE EDGEWATER AREA OF MIAMI! Two-bedroom apartment for long-term rent ONLY in gorgeous 1800 Club. The building offers a variety of amenities for its residents, including a state-of-the-art fitness center, co-ed sauna and steam room, massage room, heated swimming pool, hot tub, party room, 24-hour concierge, 24-hour security, and 24-hour valet parking. 1800 Club is located directly across the street from Margaret Pace Park which has tennis courts, a basketball court, a children’s playground, a volleyball court, and tons of open green space. AVAILABLE JUNE 1st. Unfurnished.

Condo For Rent at 1800 CLUB CONDO

1800 N Bayshore Dr #2114, Miami, Florida 33132

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,307 Sqft
$4,200
Listing ID#A11542501
QR Code
Basic Details
Subdivision : 1800 N Bayshore
Building Name : 1800 CLUB CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11542501
Price : $4,200
Original Price : $4,200
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,307 Sqft
Year Built : 2007
Property Sub Type : Condominium
DOM : 40
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