The tragic news comes after police were called to a property in the early hours of Sunday morning