Brickell Listings

Features
: Garden View
0
0
Property Description

Price to sell. Beautifully renovated 1 bedroom/1 bathroom. Enclosed gate around entire building. Very quiet neighborhood, walking distance to beaches, restaurants, boardwalks, Whole Foods, parks, and so much more. This unit includes laminated wood floors, stainless steel appliances, and hurricane impact windows with an on-site laundry! INCLUDES ONE PARKING SPACE. Cash only

Condo For Sale at 551/557 MICHIGAN CONDO

557 Michigan Ave #114, Miami Beach, Florida 33139

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 504 Sqft
$249,000
Listing ID#A11466595
QR Code
Basic Details
Subdivision : 557 Michigan
Building Name : 551/557 MICHIGAN CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11466595
Price : $249,000
Original Price : $300,000
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 504 Sqft
Year Built : 1945
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 439
DOM : 169
Tax : $3,206
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