LIMITED PARTNER INTEREST PURCHASE AGREEMENT by and among HHC KINGWOOD INVESTMENT, LLC as Purchaser, SIGNET HEALTH CORPORATION as Seller and SHC-KPH, LP Dated as of January 17, 2006