Brickell Listings

Features
: Above Ground
: Ocean
: More Than 20 Lbs
: Furnished
1
1
Property Description

Location, Location, The CASABLANCA Building. Ocean View at the beach !!! Beautiful studio!!! Fully Furnished ready to live. Large windows!! Poll service, gym all access to the amenities. Beautiful view.

Condo For Rent at THE CASABLANCA CONDO

6345 Collins Ave #636, Miami Beach, Florida 33141

  • Bathrooms : 1
  • Square Footage: 440 Sqft
$2,000
Listing ID#A11438119
QR Code
Basic Details
Building Name : THE CASABLANCA CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11438119
Price : $2,000
Original Price : $2,000
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 440 Sqft
Year Built : 1948
Property Sub Type : Condominium
DOM : 1
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