You just buy a house the usual ways and live in it. With cash or a mortgage.
If you live in it, it's not called "property investing".
"Property investing" refers to buying property to benefit from price speculation and use as a store of value, without actually using the property as a home. The property may sit there empty most or all of the time, or it may be rented out, with a combination of rent and price speculation being the owner's business plan. "Flipping" may be involved.
Sure, they're an investment too, but properties bought primarily to live in, with investment as a handy side effect, do not have the same effect on housing availability and affordability. Each such purchase reduces supply by 1, but also reduces demand by 1, and gives someone relative stability.
So purchasing to live in is not what "property investment" refers to in this context. It has a narrower meaning than "anything you could conceivably think of as an investment".
Aside, houses do in fact wear out, need regular repair, and eventually most get demolished because regular repair isn't good enough.
That's true up to a point, but many houses decay beyond profitable repair eventually.
It depends how they are constructed and maintained.
In some cultures, houses are not expected to last a long time. Japanese houses famously depreciate with time and lose all their value after about 20 to 30 years.
In other cultures, houses that could last a long time don't get maintained if the people living in them are too poor to do so. Depending on the materials, and construction aspects like breathability, the house could still last a long time, or the materials could decay, crumble, become mouldy etc to the point that the only economical thing to do is tear the house down and rebuild.
Old houses (especially mansions) that are particularly historically interesting or very old may have preservation orders on them, limiting how you are permitted repair and rebuild. Sometimes this means repair will cost so much that only a rich person could afford to do it, and the repaired result would be worth less than the cost of that repair, so the transaction value of the property drops to a nominally low value (it's really negative value), but it's only available to someone who can afford to repair it. These properties tend to be inherited, and then the new owner can't afford to look after them.