Karen Elia nailed it: no such thing as a hot neighborhood in the foreseeable future.
Find a neighborhood you love and a place you love. Forget about appreciation for the next 5 years, at least.
How much space do you need? What do you consider a reasonable price for that space? What factors are important to you in choosing a community?