Whenever the Secretary or a contract mortgagee (pursuant to its contract with the Secretary) forecloses on a Secretary-held single family mortgage in any Federal or State court or pursuant to a power of sale in a mortgage, the purchaser at the foreclosure sale shall be entitled to receive a conveyance of title to, and possession of, the property, subject to the interests senior to the interests of the Secretary or the contract mortgagee, as the case may be. Notwithstanding any State law to the contrary, there shall be no right of redemption (including in all instances any right to possession based upon any right of redemption) in the mortgagor or any other person subsequent to the foreclosure sale in connection with a Secretary-held single family mortgage. The appropriate State official or the trustee, as the case may be, shall execute and deliver a deed or other appropriate instrument conveying title to the purchaser at the foreclosure sale, consistent with applicable procedures in the jurisdiction and without regard to any such right of redemption.