Police have confirmed a woman, 40, was shot dead on her doorstep in what is feared to have been an "execution" that may have been a case of mistaken identity.