The best pipe to have in your house depends on various factors, including the specific plumbing needs and budget. However, popular choices for residential plumbing include copper pipes for their durability and long lifespan, PEX pipes for their flexibility and ease of installation, and CPVC pipes for their high-temperature tolerance.