Real estate sold for debt shall be redeemable at any time within two (2) years after such sale:
(1) Where it is sold under execution;
(2) Where it is sold under any decree, judgment, or order of a court of chancery, whether founded upon a foreclosure of a mortgage, or deed of trust, or otherwise, unless, upon application of the complainant, the court orders that the property be sold on a credit of not less than six (6) months, nor more than two (2) years; and that, upon confirmation thereof by the court, no right of redemption or repurchase shall exist in the debtor or the debtor's creditor, but that the title of the purchaser shall be absolute; and
(3) Where it is sold under a deed of trust or mortgage without a judicial sentence, unless the right of redemption is expressly waived by the deed or mortgage; and a waiver of the “equity of redemption,” or a waiver using words of similar import, shall be sufficient to waive the right of redemption afforded by this section in all deeds of trust and mortgages, whether heretofore or hereafter existing.