Brickell Listings

Features
: Heated , In Ground , Community
: Ocean
: Restrictions Or Possible Restrictions , No
: Furnished
1
1
Property Description

VERY NICE STUDIO W/BALCONY AND OCEAN VIEW. FULLY FURNISHED AND EQUIPPED , HEATED POOL , GYM, 1 FREE VALET PARKING. BEST LOCATION OF SOUTH BEACH!. SHORT TERM RENTAL ONLY. 14% TAX MUST BE ADDED AS REQUIRED BY LAW.rnrnCHECK WITH AGENT FOR AVAILABILITY AND RATES. UNIT NOT AVAILABLE UNTIL MAY 1, 2024

Condo For Rent at THE DECOPLAGE CONDO

100 LINCOLN RD #1236, Miami Beach, Florida 33139

  • Bathrooms : 1
  • Square Footage: 535 Sqft
$3,500
Listing ID#A10491315
QR Code
Basic Details
Building Name : THE DECOPLAGE CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A10491315
Price : $3,500
Original Price : $2,400
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 535 Sqft
Year Built : 1965
Property Sub Type : Condominium
DOM : 1944
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