SELECT `BUILDING_ID`, `STREET_NAME` FROM `CONDOIDEAS_MLS_LISTING`
WHERE `STREET_NUMBER` = '900'
AND `STREET_NAME` LIKE '%Biscayne%'
AND `ZIP_CODE` = '33132'
AND `BUILDING_ID` != ''
GROUP BY `BUILDING_ID`Miami FL Real Estate - Your Source for Miami Beach Condominiums, Miami Preconstruction and all Condos for Sale
SELECT `BUILDING_ID`, `STREET_NAME` FROM `CONDOIDEAS_MLS_LISTING`
WHERE `STREET_NUMBER` = '900'
AND `STREET_NAME` LIKE '%Biscayne%'
AND `ZIP_CODE` = '33132'
AND `BUILDING_ID` != ''
GROUP BY `BUILDING_ID`