Brickell Listings

Features
: Above Ground
: Intracoastal View , Other
: Yes , No
: Furnished
1
1
Property Description

LARGE ONE BED, 1.5 BATH, FURNISHED AND UDATED, CERAMIC FLOORS, BALCONY, FULL SERVICE OCEANFRONT BUILDING, POOL, GYM, SAUNA, 24 HRS SECURITY, COVER PARKING, EASY TO SHOW!! EXCELLENT LOCATION IN MIAMI BEACH!! EASY TO SHOW

Condo For Rent at THE PAVILION CONDO

5601 Collins Ave #523, Miami Beach, Florida 33140

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 930 Sqft
$2,600
Listing ID#A11520058
QR Code
Basic Details
Subdivision : 5601 Collins
Building Name : THE PAVILION CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11520058
Price : $2,600
Original Price : $2,800
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 930 Sqft
Year Built : 1968
Property Sub Type : Condominium
DOM : 75
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