What is the effect of denying certiorari by the U.S. Supreme Court?

If the U.S. Supreme Court denies certiorari, that means that the decision of the Court of Appeals is final. It doesn't necessarily mean that the U.S. Supreme Court agree or disagreed with the Court of Appeals, but it does mean that the Court will not hear your case.