Will properties ever have a cut-off limit?

I'm not saying in the next 50 years, but say 100, will prices still be increasing e.g. 6mil for a shipping container home?

And then when is the limit where a home becomes affordable?

Is it just based off how much you can borrow from a bank?