A novel visible light response Nd₂Sn₂O₇/Bi₂Sn₂O₇/Ag₃PO₄ (NSO/BSO/APO) composite photocatalyst with double Z-type heterojunction was successfully synthesized by a one-pot hydrothermal-precipitation method. The addition ratios of Nd₂Sn₂O₇(NSO) and Ag₃PO₄(APO) during composite photocatalyst preparation were optimized, and the photocatalytic reaction conditions included tetracycline hydrochloride (TC) concentration, catalyst dosage, and initial pH of the solution were screened. The maximum degradation rate of 15 mg/L TC (pH = 8) reached 97.10% exposed to visible light in 120 min by NSO/BSO/APO-30 photocatalyst (dosage: 0.4 g/L), its kinetic constant is about 9.78 times that pure Bi₂Sn₂O₇ (BSO). The morphology, composition, and optical properties of the catalysts were characterized. The f-f transition of Nd³⁺ in NSO improves the absorption ability of the catalyst to visible light. In addition, h⁺, O₂⁻ and OH participated in the photodegradation of TC in NSO/BSO/APO-30 system. The fitting of the Mott-Schottky curve and Tauc-plot curves confirmed the rationality of the double Z-type electron transfer mechanism. The EIS and PL tests show that the NSO/BSO/APO-30 composite catalyst had the lowest charge transfer resistance and the lowest carrier recombination rate. In addition, three possible degradation pathways of TC during the photodegradation by NSO/BSO/APO-30 were analyzed by High-resolution mass spectrometry (APCI-MS).