Brickell Listings

Features
: No
: Unfurnished
0
0
Property Description

Beautiful townhome in the heart of downtown. The property is located 3 minutes away from Brickel City Center. Townhouse has tile flooring on the first floor, and laminate flooring in the second floor. Freshly painted. The oven range is brand new.

Condo For Rent at RIO GARDENS CONDO

452 SW 2nd St #12, Miami, Florida 33130

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,200 Sqft
$3,200
Listing ID#A11513558
QR Code
Basic Details
Building Name : RIO GARDENS CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11513558
Price : $3,200
Original Price : $3,200
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,200 Sqft
Year Built : 1995
Property Sub Type : Townhouse
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