New survey finds strong buyer appetite, but financial barriers and green priorities shape the road ahead