You might look at College of Charleston, VCU, and UMN too - although not in your areas.
Pitt, mentioned earlier, is fairly urban.
I wonder if you should seek a writing major vs literature, but you are right, there will be less and less writers already today, so many short and long form magazine writers are contract.
you are venturing into an important butt slowly dying major so you may want to look at cost because the ROI financially is probably not strong although you may break that rule.
Anyway, these are three different urban colleges - varying size.