Despite its stunning architecture and prestigious reputation, this city has been named the least house-proud city in Britain.