Brickell Listings

Features
: Heated , Auto Pool Clean , Community
: Restrictions Or Possible Restrictions
: Unfurnished
0
0
Property Description

GREAT 1 BEDROOM/1 BATH CONDO AT CENTRO DOWNTOWN MIAMI, GREAT MODERN CONCEPT STYLE.THE AMENITIES CLUDE, TWO LEVEL CLUB ROOM, GYM,SPA, ROOFTOP POOL WITH 360 VIEW, THW STORY PH RECREATION AREA,TWO LEVEL CLUB ROOM, SKYLINE LOUNGE, ETC. BASIC INTERNET AND WATER ARE INCLUDED, PARKING IS NOT INCLUDED, THE TENANT CAN USE VALET PARKING OR SELF PARKING AT MIAMI TOWER GARAGE PAYING AN ADDITIONAL MONTHLY FEE.

Condo For Rent at

151 SE 1ST #1503, Miami, Florida 33131

  • Bedrooms : 1
  • Bathrooms : 1
$2,450
Listing ID#A11563129
QR Code
Basic Details
Subdivision : 151 SE
Property Type : Condo
Listing Type : For Rent
Listing ID : A11563129
Price : $2,450
Original Price : $2,450
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Property Sub Type : Condominium
DOM : 20
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