A good place to visit, but a ...
A good place to visit, but a poor place to stay.