It looks like from your other thread you are from GA and can afford something like $25-30k per year.
First, find several GA publics and apply to those. Those will be most likely to work out financially, and you have good choices in GA.
I think the College of Charleston is a great fit. Urban, very good school, right size, beautiful, fun city and campus area, great students, has business. I don’t know about football, but basketball is in the same conference as my school, and is usually good. You’d have to run the Net Price Calculator (NPC). It is expensive, and I don’t really know anything about aid there.
Here’s an interesting one, Virginia Commonwealth University (VCU) in Richmond (RVA). It’s an urban campus. Richmond is now a great city for college students and young professionals. It’s a public university, and I think very underrated in rankings. We’ve known several current and recent students and they’ve ALL had an amazing experience there, and I think that says more than rankings. It has a business school and VCU Arts is one of the top art schools in the country (I saw your previous thread about fashion design, but I can’t say how open Arts classes are to non-majors, you’d have to research that). It has a funky, urban environment. And I saw you like sports–no football but men’s basketball team is good, actually made the Final Four in 2011, though I would not count on that). It’s a public university; you’d be OOS; so you’d have to see if financial aid would be available to you.
A couple of others–St. Louis University, University of Houston, and University of Cincinnati. All very good schools, all have business schools, all urban, all not too cold (well Cincy might be kinda cold). Google maps shows Cincy has a 7-hour drive, St. Louis a 9-hour drive, and Houston farther. You’d have to check the NPC for yourself.
And how about the University of San Francisco. 6500 undergrads. Great city. Business school, with great weather and and far from Silicon Valley. Just putting in the name on Google shows an average cost of $31k per year, although I’m not vouching for that number. Run the NPC for yourself.
Good luck!