The obvious thing that jumps into my mind is any of the various campuses of SUNY. Unfortunately I do not know the difference between the various campuses but others on this site do.
In terms of other universities in the northeast U.Mass Amherst is not urban. I do not think of UNH as urban either although both of these schools have attractive campuses. UVM (this is an abbreviation for the Latin for “university of the green mountains” and refers to the University of Vermont) would be well over budget without aid, but does give merit aid and their Net Price Calculator does predict merit aid (correctly in our case). UVM has an attractive campus in Burlington VT which is quite an attractive smallish city (with real winters).