@percyk You will need to have it paid off before pursuing a mortgage.
Once your credit bureau shows it is paid and your credit is at least 630, you're good to go, but wait until you score is at least 720 to get better rates.
The debt collectors can not remove it from the bureaus, only show it...