I don’t know that it’s possible to intrinsically make real estate non appreciable per se, but you can shift it to be more commodity like and stop treating it special and pass regulations that encourage selling and discourages holding, which as a land value tax, would be a good start. Removing the mortgage interest deduction would be another
Removal of sub class zoning for housing would also be beneficial. Its one thing to zone an area for industrial vs housing but it should not be permitted that when land is zoned for housing they can zone specifically for single occupancy homes for example.
No, housing is a cost, not an productive investment.
What we actually want, as a society, is for housing prices to go down so people can live places.