Brickell Listings

Features
: Bay
: Restrictions Or Possible Restrictions
0
0
Property Description

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
$1,200,000
Listing ID#A11471045
QR Code
Basic Details
Subdivision : 1200 West
Building Name : MIRADOR 1200 CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11471045
Price : $1,200,000
Original Price : $1,050,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,226 Sqft
Year Built : 1965
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 0
DOM : 178
Tax : $13,054
Search Results

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

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent