What is the origin of the idiom "money pit" and when to use it?

The idiom "money pit" comes from the world of real estate and construction. This phrase is used to describe a situation or investment that consistently drains a large amount of money without providing significant returns or improvements.