'A large majority of consumers continue to believe that it’s a bad time to buy a home,' Fannie Mae's Mark Palim said.