Should I choose the disrespect college with atmosphere or the respected one without it?

It sounds a little dumb, but its a really hard and stressful decision.

I plan on going to college for 2 years and then transferring to a college in NYC or at least with in an hour or two of it.

I want to Major in Arts Administration/Management or Music Business, but I also want an artsy environment with actors, singers, and dancers, you know, I wanna be with people with performance talent, I also want a very urban environment.

So I was looking at Rider University in New Jersey, and it has my major and the perfect minor (Popular Music Culture Studies), I was going to change my minor based on the college so it most likely would have been music theatre. Its in Lawrenceville, and its way too suburban. The buildings are too short, too far apart and they're old, and suburban areas make uncomfortable anyway because they're lonely.

I also looked at Columbia College Chicago, and I really liked it, and it had my major and popular music studies too, but its not well respected, other colleges and universities look at it like a joke, and so I'm gonna have a hard time trying to transfer out of there especially to New York.

Which would be the wiser choice??? Rider fits academically but not physically, I hate the thought of just being there in a town all the time. Columbia College Chicago fits great physically, but is of lower quality academically, and I keep getting mixed reviews.

If you know of any other schools in urban areas with an arts(entertainment) administration/management majors, will you please share?