Brickell Listings

Features
: Private
: Direct Ocean , Pool , Ocean
: Restrictions Or Possible Restrictions
: Furnished
0
0
Property Description

Ocean! Ocean! Ocean! Cozy studio with direct ocean view in an ocean front resort building, high floor, ceramic floors, small full kitchen with wood cabinets. All utilities included from building (electricity, water, hot water, basic Cable-TV and Wi-Fi), laundry room on every floor, large pool, gym, valet parking, 24-Hour attended lobby, cafeteria and mini-market in the premises. Walking distance to gas station, Publix Supermarket, Walgreen Pharmacy, liquors stores, convenience stores, Pizza Hut, a variety of restaurants, recreational parks and direct access to the 8 miles boardwalk along the beach, easy access to highways. Ready to move in.

Condo For Rent at THE CASABLANCA CONDO

6345 Collins Ave #906, Miami Beach, Florida 33141

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