Can I have two house loans both are primary residence?

I live in a house now. And Just bought another house thinking for investment.

The thing is now the investment property loan interest rate too high.

And I was told that I still can apply the primary residence for the second house stating will live there, but at the end will rent it out.

Is it workable?

Thanks in advance.