Brickell Listings

Features
: No
: Furnished
1
1
Property Description

Enjoy city views from this 17th floor corner unit at The Ivy Condo. Furniture apartment. It has 1bed / 1bath and 1/2 bath, washer/dryer in unit, porcelain floors. … walk to Brickell City Centre for shopping, restaurants, and entertainment, or walk to work to the Brickell Financial district, or Downtown Miami areas; short drive to MIA Airport. Amenities include two pools, spa, fitness center, game room with pool table, BBQ area, business center, recreational room, kids playground, and convenience store. Internet, cable, and water included. Gated and secure full-service resort style building with 24 hour security, valet parking, 1 PARKING SPACE

Condo For Rent at IVY CONDO

90 SW 3rd St #1704, Miami, Florida 33130

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 1,274 Sqft
$3,200
Listing ID#A11200140
QR Code
Basic Details
Subdivision : THE IVY
Building Name : IVY CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11200140
Price : $3,200
Original Price : $3,200
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,274 Sqft
Year Built : 2008
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