Thanks a lot, @Dustyfeathers for the information/reply. Retaking the SAT was something I considered, I just was not sure how retaking it as a college student would come across to prospective colleges. It is definitely something I will do.
Will also for sure look into/research NYU and Boston U as being in a university near a city is important to me. I’ve read that Vanderbilt can be very generous with aid packages to transfer students, which is why it was close to the top of my list.