Brickell Listings

Features
: Bay , Other View
: Restrictions Or Possible Restrictions
: Furnished
0
0
Property Description

Location! Beautiful and modern 2022 building approved for vacation rental! totally furnished included in the price, Lavis suites, stunning ocean view, amazing amenities, design for enjoyment, elegant lobby, security 24/7, valet parking, incredible rooftop pools, cocktail bar, luxury hotel-condo, multi-level fitness complex with panoramic views, in the heart of Brickell downtown, dinning and nightlife walking distance, waterfront views, art, entertainment, ready to live, to enjoy, and/or to rent… it is a gem with so much potential….

Condo For Sale at The Elser Hotel And Resid

398 NE 5th St #4412, Miami, Florida 33132

  • Bathrooms : 1
  • Square Footage: 341 Sqft
$679,900
Listing ID#A11523112
QR Code
Basic Details
Subdivision : 398 NE 5th
Building Name : The Elser Hotel And Resid
Property Type : Condo
Listing Type : For Sale
Listing ID : A11523112
Price : $679,900
Original Price : $699,900
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 341 Sqft
Year Built : 2022
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 375
DOM : 24
Tax : $10,365
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