Tragic details emerge as couple found dead together at home