If you want to stay close to new haven, there are a few apartment / condo complexes in Hamden that all look really good. Anything along Whitney Ave will be a great neighborhood and Whitney is a straight drive into the heart of new haven.