It's worth buying - that can't be right?

Hey Carbonara disciples, you have to steer me onto the right path again, I must have taken a wrong turn somewhere. I have been investing in the holy grail for several years and until yesterday I was firmly convinced that an apartment/house for personal use was not an investment, but a pure dream hobby. Now my partner and I are unexpectedly looking for a larger apartment earlier and are a bit surprised at the prices. My partner said: "Yes, you can buy it straight away