FWIW I’ve been to Middleton several times to perform or speak at Wesleyan, and it’s a great town. Definitely not urban by any reasonable definition, though.
This is my first post - thought I should start making a contribution having gained a lot from this site. We have just been through this process with our DS. Among the schools mentioned here, I don’t think I’ve seen Trinity University, which is in the great urban location of San Antonio and has beautiful athletic facilities.
I second Trinity U in in TX. The gym is brand new and state of the art – including cardio machines with built in Netflix!
Thirded. Trinity in SA is great (and has deeeep pockets).