Saying did well on psat isn’t giving a lot of guidance. Do you think it will be a 1200 or 1400, etc.
I would start getting in touch with coaches - because you may not get into a school regularly but you may as an athlete. D3 soccer is super competitive getting on board.
Assuming, since you mention Oberlin, that you want an LAC - so schools that come to mind - Trinity, Macalester, Occidental, Connecticut College, Coe, Rhodes - these are D3 and in city like areas.
If you are trying to hit a cost, like everyone you’ll need to look at Arizona, Arizona State, Alabama, Mississippi, Mississippi State, Arkansas, Florida State (will need test score - 31 ACT gets out an OOS waiver but even full pay you can afford), College of Charleston, u of SC…and a host of others. Most of these are rural but the schools themselves are so big they are cities - but in that sense you can eliminate the two MS…or you can add UAH and UAB. At a larger school, he can join the Honors College to shrink the size and then join club soccer.
For $45K, you can definitely find a school. If you want it to be small liberal arts school, there are options. Some, like Hendrix, will match your state flagship’s tuition. A school like Bradley and Hofstra will tell you up front how much merit you will get.
It’s hard to find LACs in “society”.
The other thing is - if your EFC is $45K and you hit the schools that meet need, you’ll likely come within a range of there - but many/most of these are not going to be in the city. Still you can maybe look at a Lafayette, Franklin & Marshall, Union, Kalamazoo…and more in addition to the ones I mentined above.
You might take a list such as this, and school by school - starting at about #30, go and see which are city like vs. rural. Just know, the lower you go, the better chance of decent aid. But again, at the high point on the list, many of those schools will meet need.
Hope that gives you an early guide.
One other thing - set up an email for your child - just for college. Like first namehighschoolname@gmail or something like that. Request info from schools - i.e. get on their email lists. You’ll learn more, demonstrate interest which is what they want, and get app fee waivers. We started with like 100 - obviously didn’t apply to that many - only 21 (yes, that’s a lot but I actually don’t think so).
It’s a great way to organize and narrow down because at some point, the soccer will come in focus - will it work or not. And school size and greek life and all that stuff too.
Good luck