What Airbnb really does to a neighbourhood

Millions of people use Airbnb when travelling but its popularity sometimes puts it at odds with locals. So, how do short-term holiday lets really affect a neighbourhood?