The real estate bull market is making housing hot again. But investing in what is hot is not the way to succeed financially.