Brickell Listings

Features
: In Ground
: Unfurnished
0
0
Property Description

Charming two-bedroom apartment, conveniently situated just minutes away from Miami International Airport and downtown Miami, offers the perfect blend of comfort and convenience. Located right off of 88 Ave and Flagler Street, this centrally located gem boasts 900 square feet of living space, providing ample room for you to create your ideal living environment.

Condo For Rent at THE GREENS CONDO

8841 W Flagler St #202, Miami, Florida 33174

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 900 Sqft
$2,300
Listing ID#A11555425
QR Code
Basic Details
Subdivision : 8841 W Flagler
Building Name : THE GREENS CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11555425
Price : $2,300
Original Price : $2,400
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 900 Sqft
Year Built : 1972
Property Sub Type : Condominium
DOM : 31
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