@Halcyon24 , I’m not nearly the expert on colleges some of the other responders are. But I’ve spend a lot of time this year investigating a lot of colleges in the mid-atlantic and NE. I’m not sure of the aid for these schools, but it would always be in your interests for you to run the NPC for any school.
The SAT/ACT scores give a good spectrum, and your son’s desires help too. I know that to a kid in the south, saying “NE” doesn’t necessarily mean only Philly-NYC-Boston areas – it often means "somewhere not in my state where I might see snow sometimes and a decent sized city. Ignoring a teen’s ability to change their minds on a dime, here are a few suggestions of schools that caught our eyes.
Hofstra - On first blush, it may not fit the very small-school, academic slant of some of the other suggestions. On the other hand, it’s a long subway ride to Manhattan, and his stats might lead to enough merit aid to make this a good financial option. They don’t use CSS.
Loyola Maryland - They may or may not give enough merit aid to work, but it’s in Baltimore which should give him the city vibe he seeks, it’s not a huge school, and it is an appealing setting.
Drew - Already mentioned here. I like this as an option for his parameters, if not a guaranteed financial fit. No CSS.
Macalester - a bit of a reach for his stats, but if accepted they might help financially. No, it is not in the NE corridor, but the Twin Cities is a large metro area with a lot to do for a college student.
UNC Charlotte - Large city, modern campus, but maybe a little larger than he wants. Not the NE corridor, but not Florida. Might be just affordable enough. He might qualify for Honors which might give him the smaller school setting he seeks. A lot of “mights” I know, but … No CSS.
Rhodes College - Not the NE corridor, but Memphis isn’t exactly a tiny city. And it’s not Florida which I assume might be more important to your son than specifically being in the NEC. The school is smallish and has good academic standards. Try the NPC.
I like several of the options already provided. I hoped to provide a few more that might be options. It’s going to be tricky to find that perfect fit that is a guaranteed financial fit as well.
One strategy to consider might be to look at schools that fit from a size and location aspect, but may not be considered to be the exact sort of academic setting you prefer for him. For instance, a school like Manhattan College may not have the academic prestige you seek for him, but his stats might allow significant merit aid to make it affordable.
Good luck. Please let us know where he ends up.