Real estate affordability sours Californians

But residents may be gaining ground in housing struggle