Brickell Listings

Features
: Community
: Bay , Intracoastal View , Water
: Furnished
1
1
Property Description

Corner Furnished Unit. 2/2 plus den. Upgraded finished ,imported Italian doors, Wood Floor. Top of line appliances.
Philippe Starck designed common area.Lot of amenities Fantastic view. Over size pool. Tenant is required to apply to the condo association. One covered parking space

Condo For Rent at ICON BRICKELL NO TWO

495 Brickell Ave #4502, Miami, Florida 33131

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,654 Sqft
$7,000
Listing ID#A11484279
QR Code
Basic Details
Subdivision : 495 Brickell
Building Name : ICON BRICKELL NO TWO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11484279
Price : $7,000
Original Price : $7,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,654 Sqft
Year Built : 2009
Property Sub Type : Condominium
DOM : 154
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