Brickell Listings

Features
: Furnished
0
0
Property Description

Furnished one bedroom unit located in the vibrant heart of South Beach. This unit boast a fresh coat of paint, abundant natural light streaming in, and ample closet space for all your storage needs. Available furnished or unfurnished.

Condo For Rent at 1218 DREXEL CONDO

1218 Drexel Ave #306, Miami Beach, Florida 33139

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 633 Sqft
$1,975
Listing ID#A11566413
QR Code
Basic Details
Subdivision : 1218 Drexel
Building Name : 1218 DREXEL CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11566413
Price : $1,975
Original Price : $2,100
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 633 Sqft
Year Built : 1925
Property Sub Type : Condominium
DOM : 16
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