Brickell Listings

Features
: In Ground
: Restrictions Or Possible Restrictions
: Furnished
1
1
Property Description

1 Bedroom, 1 Bath condo available for rent in one of the most desirable areas of Miami Beach.
Unit has impact windows, and the building has been remodeled in 2023.
Building has heated Pool, Gym, Playground for Children, Basketball courts, Cafeteria and many more amenities. Direct access to the Beach.

Available May 8, 2024

Condo For Rent at MIMOSA CONDO

4747 Collins Ave #303, Miami Beach, Florida 33140

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 790 Sqft
$2,400
Listing ID#A11501129
QR Code
Basic Details
Subdivision : 4747 Collins
Building Name : MIMOSA CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11501129
Price : $2,400
Original Price : $2,400
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 790 Sqft
Year Built : 1962
Property Sub Type : Condominium
DOM : 56
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