Manchester City and England star Phil Foden's property in Cheshire has been on the market for more than six months, but the mansion has now been sold, subject to contract