Where does the appeal go after the case has been heard by the US Supreme Court?

Nowhere. The US Supreme Court's decision is final.