Brickell Listings

Features
: Ocean View , Bay , Intracoastal View
: Restrictions Or Possible Restrictions
1
1
Property Description

THE ELSER RESIDENCES ONLY NEW CONSTRUCTION IN DOWNTOWN MIAMI!!.FULLY FURNISHED STUDIO,BALCONY,WATERFRONT,CITY SKYLINE,EXCELLENT LOCATION.EASY ACCESS TO WELL APPOINTED AMENITIES AND DIRECT PROXIMITY BAYSIDE MARKETPLACE,PORT OF MIAMI,WALKING DISTANCE TO BRIGHTLINE HEADQUARTERS.

Condo For Sale at THE ELSER RESIDENCES

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

  • Bathrooms : 1
  • Square Footage: 341 Sqft
$628,000
Listing ID#A11526245
QR Code
Basic Details
Subdivision : 398 NE 5th
Building Name : THE ELSER RESIDENCES
Property Type : Condo
Listing Type : For Sale
Listing ID : A11526245
Price : $628,000
Original Price : $639,000
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 341 Sqft
Year Built : 2022
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 416
DOM : 87
Tax : $9,867
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