Deals expert announces record results and says Yorkshire market set to improve again