Brickell Listings

Features
: In Ground
: Other
: More Than 20 Lbs
: Unfurnished
1
1
Property Description

Beautiful condo in Downtown. Great location close to Whole Foods, Brickell Ave., Bayfront park and Metro Mover. High Ceiling unit with Italian Kitchen and Stone countertops. Common areas designed by Ives Behar with a raw Industrial Design. Roof top pool with 360 degree views, skyline lounge, health club and recreational area.

Condo For Rent at CENTRO CONDO

151 SE 1st St #503, Miami, Florida 33131

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 533 Sqft
$2,500
Listing ID#A11575431
QR Code
Basic Details
Subdivision : 151 SE 1st
Building Name : CENTRO CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11575431
Price : $2,500
Original Price : $2,500
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 533 Sqft
Year Built : 2016
Property Sub Type : Condominium
DOM : 0
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