The discovery of two bodies at a semi-detached house on a quiet Cardiff street is being treated by police as a murder and suicide investigation, according to neighbours.