I never said the melodramatic "What nobody knows is when that will happen, or what happens next", so consider yourself spared.
As for whether they're helpless or not... that depends largely on whether the rising sea level infiltrates the aquifer to the point where it becomes brackish rather than fresh water. And even then, the problem can be dealt with, by turning to desalination (probably of straight seawater).
For "Who is Zillow?", they're the #1 real estate website. Property values are their business, and they have lots of data (and a corporate perspective, rather than a scientific one, for better or worse). What options does Miami have? Spend more money on protecting the aquifer from mining and contamination, and maybe invest in desalination. Is Miami an outlier? Kinda. Most coastal cities are also on river mouths, and thus have better fresh water resources. But overstretching the fresh water supply is often a problem, even if that fresh water isn't itself endangered - see Los Angeles, for example.
As for whether they're helpless or not... that depends largely on whether the rising sea level infiltrates the aquifer to the point where it becomes brackish rather than fresh water. And even then, the problem can be dealt with, by turning to desalination (probably of straight seawater).
For "Who is Zillow?", they're the #1 real estate website. Property values are their business, and they have lots of data (and a corporate perspective, rather than a scientific one, for better or worse). What options does Miami have? Spend more money on protecting the aquifer from mining and contamination, and maybe invest in desalination. Is Miami an outlier? Kinda. Most coastal cities are also on river mouths, and thus have better fresh water resources. But overstretching the fresh water supply is often a problem, even if that fresh water isn't itself endangered - see Los Angeles, for example.