Brickell Listings

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

Stay in the legendary and gorgeous Seacoast Condominium designed by iconic architect Morris Lapidus. Expansive beach area with chair and umbrella service. Beautiful unit with all the comforts of home. Low floor provides easy access by elevator or stairs. Available for rentals of 185 days or less.

Condo For Rent at SEACOAST 5151 CONDO

5161 Collins Ave #308, Miami Beach, Florida 33140

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,030 Sqft
$4,000
Listing ID#A11549352
QR Code
Basic Details
Subdivision : 5161 Collins
Building Name : SEACOAST 5151 CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11549352
Price : $4,000
Original Price : $5,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,030 Sqft
Year Built : 1966
Property Sub Type : Condominium
DOM : 7
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