'Trendy' London borough named most affordable to buy a home