A 44-stone housebound man, who can no longer climb the stairs in his tiny flat, has made an emotional appeal for a new home.