Brickell Listings

Features
: Ocean View , Pool Area View , Direct Ocean
: Restrictions Or Possible Restrictions
0
0
Property Description

NO RESTRICTIONS, FULLY FURNISHED UNID CAN BE RENTED ON DAILY BASIS DAYS ON YOU OWN GREAT AMENITIES UTILITIES INCLUDED, MAINTENANCE FEE CABLE,INTERNET,ELECTRICITY,WATER,TRASH REMOVAL,LAUNDRY FACILITIES,ETC OCEAN BEACH ACESS POOL CLOSE TO THE SHOPPING,RESTAURANTS,CAN BE RENTING (AIRBNB, BOOKING.COM ETC)
VALET PARKING 24/7, OWNER MOTIVED

Condo For Sale at THE CASABLANCA CONDO

6345 Collins Ave #605, Miami Beach, Florida 33141

  • Bathrooms : 1
  • Square Footage: 330 Sqft
$415,500
Listing ID#A11475953
QR Code
Basic Details
Subdivision : 6345 Collins
Building Name : THE CASABLANCA CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11475953
Price : $415,500
Original Price : $425,000
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 330 Sqft
Year Built : 1948
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 690
DOM : 173
Tax : $2,431
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