Brickell Listings

Features
: Heated , Community
: Pool , Ocean
: Furnished
0
0
Property Description

AMAZINGLY POSH AND COZY STUDIO WITH A FANTASTIC VIEW WHERE LINCOLN ROAD MEETS THE BEACH. THE APARTMENT IS READY TO BE RENTED. IT HAS BEEN TASTEFULLY RENOVATED. BEAUTIFUL VIEW FROM THE BALCONY OF BOTH THE OCEAN AND SWIMMING POOL FROM A HIGH FLOOR, WITH NO EXPOSURE TO THE NORTH WIND. QUEEN SIZE BED WITH NEW MEMORY FOAM MATTRESS. UNIT IS DECORATED WITH CRYSTAL TILE FLOORS AND HAS CENTRAL A/C, PORCELAIN COOKTOP, AND FULLY EQUIPPED KITCHEN, TWO DRAWERS, PLUS CLOSET, AND DESK. ELECTRICITY, WATER, CABLE TV, AND WI-FI ARE INCLUDED, ALONG WITH 24/7 SECURITY, VALET PARKING SERVICE, AND GYM.

Condo For Rent at THE DECOPLAGE CONDO

100 Lincoln Rd #1230, Miami Beach, Florida 33139

  • Bathrooms : 1
  • Square Footage: 550 Sqft
$3,200
Listing ID#A11515799
QR Code
Basic Details
Subdivision : 100 Lincoln
Building Name : THE DECOPLAGE CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11515799
Price : $3,200
Original Price : $3,200
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 550 Sqft
Year Built : 1965
Property Sub Type : Condominium
DOM : 10
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