Penn State and Pitt come to mind for Northeastern State schools that carry a huge alumni following and for many programs are considered "one of the best" in the Northeast.
Of course, I like to think Penn State alumni are also some of the most annoying college grads on the planet, but that's just because I went to Pitt.
The VP and one of the directors of my department have degrees from Ivy League colleges (Harvard and Yale). I don't feel like it carries that much weight, particularly not in my field.
Now that I'm in the midwest, University of Michigan and University of Illinois carry a lot of weight around here.