Rarely available, 26-line corner unit at Mirador North. Magnificent 5th floor views of downtown, Biscayne Bay, & port of Miami right from your balcony. Features open kitchen layout & breakfast nook. Building offers a newly renovated gym, resort-style pool deck, marina/boat dock for lease, full-service convenience store, onsite contractor services, club/party room, & secured lobby w/ 24-hour
concierge & valet service. One of the most desirable buildings on West Ave, short distance to beach & South Pointe, steps from Whole Foods & Lincoln Rd. Valet only parking, $85/month.
Condo For Sale at MIRADOR 1200 CONDO
1200 West Ave #526, Miami Beach, Florida 33139
- Bedrooms : 2
- Bathrooms : 2
- Square Footage: 1,226 Sqft
WordPress database error: [Unknown column 'http' in 'order clause']SELECT x.position FROM (SELECT p.id, @rownum := @rownum + 1 AS position FROM `wp_wpl_properties` AS p JOIN (SELECT @rownum := 0) r WHERE 1 AND `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC ) AS x WHERE x.`id`='571380'
WordPress database error: [Unknown column 'http' in 'order clause']SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC LIMIT 0, 1
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 `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC LIMIT , 1
- Result of 2440
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com