Pharmaceutical active compounds (PhACs) are some of the most recalcitrant water pollutants causing undesired environmental and human effects. In absence of adapted decontamination technologies, there is an urgent need to develop efficient and sustainable alternatives for water remediation. Metal–organic frameworks (MOFs) have recently emerged as promising candidates for adsorbing contaminants as well as providing photoactive sites, as they possess exceptional porosity and chemical versatility. To date, the reported studies using MOFs in water remediation have been mainly focused on the removal of a single type of PhACs and rarely on the combined elimination of PhACs mixtures. Herein, the eco-friendly bismuth-based MOF, SU-101, has been originally proposed as an efficient adsorbent-photocatalyst for the elimination of a mixture of three challenging persistent PhACs, frequently detected in wastewater and surface water in ng L⁻¹ to mg·L⁻¹ concentrations: the antibiotic sulfamethazine (SMT), the anti-inflammatory diclofenac (DCF), and the antihypertensive atenolol (At). Adsorption experiments of the mixture revealed that SU-101 exhibited a great adsorption capacity towards At, resulting in an almost complete removal (94.1 ± 0.8% for combined adsorption) in only 5 h. Also, SU-101 demonstrated a remarkable photocatalytic activity under visible light to simultaneously degrade DCF and SMT (99.6 ± 0.4% and 89.2 ± 1.4%, respectively). In addition, MOF-contaminant interactions, the photocatalytic mechanism and degradation pathways were investigated, also assessing the toxicity of the resulting degradation products. Even further, recycling and regeneration studies were performed, demonstrating its efficient reuse for 4 consecutive cycles without further treatment, and its subsequent successful regeneration by simply washing the material with a NaCl solution.