rent control and automatic bank draft rent payments allow places to languish for seeming ever. There are more such stories about dowagers living for a pittance for many decades in exclusive, posh apartments and villas in Paris.
The Paris I saw was very similar to SF and NYC.
Impossible to find anything remotely affordable.