If you are restricting your search to just your local area, I think you know the outcome - none of those colleges meet your requirements of meet full need, no language requirement, and local.
You are going to have to do some thinking and prioritizing. Which of the requirements are you willing to shift on?
The only more renown colleges which meet full need that I can think of that have no language requirement are Amherst and Brown. If you are a female, add in Smith. Double check about Rice.
Otherwise you will need to go through that list of colleges that meet full need checking for language requirements.
Good scholarships for transfer students are hard to find. Colleges focus most of their scholarships on the incoming freshmen class.