College bike = used bike worth $500 max, preferably <$300. Shit gets stolen so often you don't want anything nice.
I used a 10 year old rigid Stumpjumper hardtail built with some mid-level components and it was perfect for the various college uses you described. I still have it and mostly use it to tow the Burley trailer around now, but it's such a solid multipurpose bike.