SELECT * FROM bir_listings WHERE active='Y' AND city_office_id=3 and area_id = 3 AND price>=200000 AND `type` LIKE '%condo%' AND `water_frontage`='Y' ORDER BY price limit 7515 , 45
Search Results - Browse Waterfront Condos in Miami 168
spanish portuguese english
Miami Real Estate
jennifer-cook-raul-aleman
City
Min Price
Max Price
# Beds
# Baths
Size
Property Type
 

Browse Waterfront Condos in Miami

Sort By
No results found, try another search.