New York and San Francisco are some of the hottest markets for renters, but a tiny Northeastern city beat them both