Scot MacDermid, 42, was reportedly last seen with his children, George and Lesley at Manning Town Centre (155 Avenue and 37 Street) on Aug. 28