LUXURY BUILDING ACROSS BRICKELL CITY CENTRE. GREAT LAYOUT 2BED + DEN, 2 FULL BATHS + 1 HALF BATH UNIT. MARBLE MASTER BATH. WOOD LOOKING PORCELAIN FLOORS THROUGHOUT. BUILT IN CLOSETS. WOLF, BOSCH, SUB ZERO APPLIANCES. ITAL-CRAFT CABINETRY. PRIVATE ELEVATOR ENTRY #2. PRIVATE ROOFTOP SKY POOL FOR RESIDENTS. 5 STARS SERVICES INCLUDING ROOM SERVICE. SPA. 24 Hrs CONCIERGE. VALET. ONE ASSIGNED PARKING SPACE. CLOSE TO SHOPS, ENTERTAINMENT AND MUCH MORE. INSTRUCTIONS AT BROKERS REMARKS.
Condo For Rent at 801 SMA RESIDENCES CONDO,SLS LUX CONDO
801 S Miami Ave #1202, Miami, Florida 33130
- Bedrooms : 2
- Bathrooms : 3
- Square Footage: 1,119 Sqft
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
- Prev
- Result of 568
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com
