Had a friend who went to Queens college and is in pretty heavy debt from it.
A general rule of thumb is that public schools (anything like University of _______ or ________ State University) offer full funding while private schools usually do not, but will sometimes offer smaller scholarships from 10K-50% of tuition. Full funding is often part of a T.A. or G.A. position which means you will also be teaching classes and working for the department, which can put a considerable strain on ones time. Many state schools run three year programs for that reason.
Places I know have full-funding: U. Texas Austin, Montclair State University (just outside NYC in Montclair NJ, a cool town on a direct train line), U Mass Amherst, Indiana U. Bloomington, Virginia Commonwealth University, U. Penn, Rutgers U., U of Arizona, U of Michigan Ann Arbor. There are others Im sure...