Consumer confidence is at its highest in two years despite the majority of householders expecting property prices and rents to rise further in the next year.