Brickell Listings

Features
: In Ground , Community
: Furnished
1
1
Property Description

Seasonal Rental Property. Delightful 2 bedrooms and 2 bathrooms unit, with amazing ocean views, completely renovated, new kitchen with stainless steel appliances and butcher block countertop, new bathrooms with quartz countertops. Beautiful ocean view!!! Ready for occupancy, Tastefully furnished. Condo offers Beach Service, Direct Access to the Beach and Miami Beach sidewalk, Pool beach lounge chairs, umbrellas & towel service, Restaurant, 24 hours Concierge & Valet, Beauty Salon, Gym, Sauna, Games room, Cinema room, Library, and BBQ area.

Condo For Rent at ARLEN BEACH CONDO

5701 Collins Ave #412, Miami Beach, Florida 33140

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,031 Sqft
$4,500
Listing ID#A11530949
QR Code
Basic Details
Subdivision : 5701 Collins
Building Name : ARLEN BEACH CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11530949
Price : $4,500
Original Price : $4,500
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,031 Sqft
Year Built : 1969
Property Sub Type : Condominium
DOM : 0
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