Brickell Listings

Features
: Heated
: Lake
: Restrictions Or Possible Restrictions , No
: Unfurnished
1
1
Property Description

Open floor plans, panoramic window, and spacious balconies assure that residents will enjoy spectacular view of lagoon and city skyline. Blue Lagoon Condominiums provide a tropical resort-style escape in the heart of Miami. It has spectacular amenities that include: business center, heated pool, jacuzzi, fitness center, grocery, spa/sauna, beauty salon, 7 BBQ in front of the lagoon, mini golf, kids play area, area for parties. Conveniently located in Central Miami, close to Miami international airport and highway access to downtown and beaches in minutes

Condo For Rent at BLUE LAGOON CONDO

5077 NW 7th St #1209, Miami, Florida 33126

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 685 Sqft
$2,200
Listing ID#A11566504
QR Code
Basic Details
Subdivision : 5077 NW 7th
Building Name : BLUE LAGOON CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11566504
Price : $2,200
Original Price : $2,200
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 685 Sqft
Year Built : 2003
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