If you really want to be close to the east coast, but not in NYC, try Penn (or UVA). If you just pick your grades up a little, you probably have a chance of getting in to one of them.
EDIT: Too late for this guy, but Columbia takes a lot of transfers.... something like 60 people.