Except for UConn…this is a very top heavy list of places to gain admission as a transfer student. “Connections” at Columbia? Like what? This school is looking for strong students, not students who know someone who knows someone.
If you go to a UConn branch campus, you will find that students do move to the main campus in Storrs to complete their degrees. This isn’t uncommon.
To maximize your transfer prospects…you will need to have a perfect GPA in college…perfect. And some great letters of reference.