Did you prep for the SAT the first time? With an score that uneven, it could be worth prepping for the math and trying a retake if you’re doing transfer apps this year. There’s a lot of room to bring up that 500, particularly if that was a no-prep attempt. Have you been taking math classes at community college?
Another option is to try the ACT. The ACT math is just one of four sections (English, Writing, Math, and Science) - the Science section is focused on scientific reasoning. Try taking an ACT practice test and see whether you think it might be a more advantageous test for you. (The downside of the ACT math is that it’s fast-paced and some students find it hard to finish. So the question is whether your challenges with the SAT math were in working fast enough, or in the content of the problems. Either way, the good news is that math scores can almost always be improved with prep - both practicing the types of problems, and learning strategies for pacing, knowing when to guess, and so on.)
Do you think you’d qualify financially for Berea? Could be a really good option for you if so.
You might look at Syracuse - they accept a lot of transfer students (more than 400 students a year transfer in, and the acceptance rate is over 50%). While it’s not a full-need-met school, the average percentage need met is over 90% and there’s also merit available for transfers, so it might add up - run the NPC and see how it looks. (The recent turmoil there is unfortunate and worth weighing, but it might also deter some applicants and improve your chances of acceptance/merit.) Trinity U in San Antonio is another with >90% need met, possible transfer merit, and >50% transfer admit rate (albeit in smaller numbers than Syracuse).
Sewanee in TN is transitioning to full-need-met aid (not sure if it’s guaranteed for transfers yet, but worth looking into). Their transfer admit rate isn’t bad (>30%) and it’s a terrific school for English/writing (Tennessee Williams left his estate to the college, to support the creative writing program). Your high school stats would have made it a low-reach, not entirely out of range.
So, this fall is your second cc semester? And 9 credit hours is a full load? (I’m used to a full load for a semester being at least 12… maybe this is a different system.) Did you work for a while and start cc last spring?
Anyway, hopefully that gives you a bunch to look into.