SELECT `BUILDING_ID`, `STREET_NAME` FROM `CONDOIDEAS_MLS_LISTING`
WHERE `STREET_NUMBER` = '229'
AND `STREET_NAME` LIKE '%SW%'
AND `ZIP_CODE` = '33130'
AND `BUILDING_ID` != ''
GROUP BY `BUILDING_ID`Buy a condo at The Smart Brickell condo - View all Condos for Sale in Miami
SELECT `BUILDING_ID`, `STREET_NAME` FROM `CONDOIDEAS_MLS_LISTING`
WHERE `STREET_NUMBER` = '229'
AND `STREET_NAME` LIKE '%SW%'
AND `ZIP_CODE` = '33130'
AND `BUILDING_ID` != ''
GROUP BY `BUILDING_ID`
The smart condo-hotel project that you will want to invest in Brickell
The Smart Brickell condo is a certified Leadership in Energy and Environmental Design (LEED) condo-hotel project located in Brickell. Developed by the Habitat Group, the project emphasizes its inclusion of technologies such as Nest thermostats, Lifx Wi-Fi enabled LED smart bulbs, Samsung's digital home appliances and many more.
The Smart Brickell condo will span over three towers and 25 stories high. The units that will be delivered will range from 508 to 1057 square feet with a price tag starting from $318,000 to more than $400,000. The project is estimated to be completed at the beginning of 2020 with 170 units available for sale.
The Smart Brickell condo offers great rental deals for its owners. Investors are able to participate in the hotel's leaseback program or have their own individual rental activity. All condos inside this project are 100% approved for sub-leases on Airbnb's platform.
The Smart Brickell condo also offers top-notch amenities to its residents. Owners and hotel guests can take advantage of swimming in 2 pools on the 8th floor or they can even pamper themselves for a spa or have quality time in the party room that is located on the same floor. The Smart Brickell condo will also have electric parking stations, sky bars, and restaurants as well as a gym located on different floors. There will be a separate residence and hotel lobbies to protects the owner's privacy.
All units will also be delivered fully finished and furnished by the renowned interior design firm Arquitectonica.