>No amount of "zoning" is going to make the commingling of apartments and hotels attractive to full-time residents, nor will any change in "zoning" make flophouses less profitable.

In most old cities, hotels, bed and breakfasts, hostels etc all exist in residential areas. And boarding houses used to be common in these same areas too.