The Netherlands' Amsterdam will no longer allow new hotel buildings to be built as part of its fight against mass tourism, the local government said on Wednesday. A new hotel in Amsterdam can only be built if another hotel closes, if the number of sleeping places doesn't increase, and if the new hotel will be better, for example more sustainable.
That’s basically impossible because there’s also legitimate good coming out of short-term rentals if done correctly so courts won’t let a total ban stand.
I think Berlin does it right: You can rent out your apartment while you’re away for a maximum of 90 days a year, unlimited if you live there with the guest, otherwise you need a hotel license which you won’t get for a residential apartment if there’s a housing shortage (and there is). In either case you’ll need to register with the city and display that register number in your listing on airbnb or elsewhere so any offering that doesn’t include one can get roflstomped by the authorities.