Depends on how long you plan to own the property... and it applies differently between LANDED and CONDO/APARTMENT.

On average people would own a property up to
30 years - Landed
20 years - Condo/Apartment

Now think of it as being trade down from 99 > 69 (nice) > 39 > 9.

Depending whichever time period you purchase the house. If you're the 2nd or 3rd buyer the house would still holds its value as people could only stay up to the max period of 30 years.

Thus, theoretically, if the house has a lease period of 30 years remaining... you should be aware of it and could be harder to sell it off and usually it would be the last owner who owns the remaining 30 years.