Brickell Listings

Features
: Ocean View , Pool Area View
0
0
Property Description

CABANA CU 207 FOR SALE ALEXANDER CONDO HOTEL PROPERTY COMPLETELY REFURBISH
PARKING AVAILABLE BEACH UMBRELLA AVAILABLE UNIT TO USE FROM DAWN TO DUSK NO SLEEPING IN THE UNIT NO KITCHEN

Condo For Sale at the alexander condo

5225 collins #cu 207, Miami Beach, Florida 33140

  • Bedrooms : 1
  • Bathrooms : 1
$160,000
Listing ID#A11512975
QR Code
Basic Details
Subdivision : 5225
Building Name : the alexander condo
Property Type : Condo
Listing Type : For Sale
Listing ID : A11512975
Price : $160,000
Original Price : $160,000
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Year Built : 1962
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 124
DOM : 28
Tax : $1,980
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