Kate Mulcahy, 37, was sadly found dead inside the home in Middleton