Can/should I take a second loan on my primary residence to pay off my investment property loan?

You can, but compare the two interest rates first; that's where this decision is won or lost. The loan on your investment property is non-owner-occupied financing, and if it was placed when rates were lower, it may already carry a lower rate than a new second mortgage on your primary would today. In that case, borrowing against your home to pay off the rental saves you nothing. You'd own the rental free and clear, your total interest cost could go up, and you'd have moved the debt onto your primary residence. There are situations where it works. We've helped clients nearing retirement with several appreciated rentals consolidate debt this way to boost monthly cash flow, but that math worked because the new borrowing was cheaper than what it replaced. Put the numbers side by side: the rate and remaining interest on the current investment loan versus the rate, interest, and closing costs on the proposed second mortgage. If the new loan is genuinely cheaper, it can be worth doing. If it isn't, you're paying extra to feel debt-free on the rental, and that's rarely a good trade. If you'd like, we'll run that comparison with you in the free Roadmap conversation, about 20 minutes with your real numbers.