Brickell Listings

Features
: Heated , Hot Tub , Community
: Furnished
1
1
Property Description

This Miami hotel room is the ideal size for a group of six and is located in the city center, providing easy access to all amenities. The building boasts an elevated deck with a pool, jacuzzi, and bar, as well as a game room, private meeting room with co-working space, gym, restaurant, and 24-hour security. The hotel is conveniently located just a 7-minute walk from the Miami Observation Wheel and is surrounded by numerous restaurants, coffee shops, stores, and other essential services all within walking distance.

Condo For Rent at

227 NE 2nd str #2306, Miami, Florida 33132

  • Bedrooms : 2
  • Bathrooms : 2
$4,450
Listing ID#A11464131
QR Code
Basic Details
Subdivision : 227 NE 2nd
Property Type : Condo
Listing Type : For Rent
Listing ID : A11464131
Price : $4,450
Original Price : $5,500
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Property Sub Type : Condominium
DOM : 200
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