Brickell Listings

Features
: Heated , Hot Tub , In Ground , Community
: Ocean
: Unfurnished
1
1
Property Description

Super bright condo in the desired Mirador 1200 WITH ASSIGNED PARKING in the covered garage. Lots of light and storage space. Mirador 1200 is a full amenity building, with a large swimming pool, Jacuzzi, BBQ area, conference room, recreation room, and breathtaking views of Biscayne Bay – not to mention unforgettable sunsets! Conveniently situated within walking distance of trendy restaurants, Whole Foods, Trader Joe’s, Lincoln Road, shops, and more. It’s all about the LOCATION!

Condo For Rent at MIRADOR 1200 CONDO,Mirador 1200

1200 West Ave #1414, Miami Beach, Florida 33139

  • Bathrooms : 1
  • Square Footage: 680 Sqft
$2,400
Listing ID#A11570188
QR Code
Basic Details
Subdivision : 1200 West
Building Name : MIRADOR 1200 CONDO,Mirador 1200
Property Type : Condo
Listing Type : For Rent
Listing ID : A11570188
Price : $2,400
Original Price : $2,400
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 680 Sqft
Year Built : 1965
Property Sub Type : Condominium
DOM : 0
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