A family of five, including three children aged between four and 12, have been found shot dead inside a US apartment.