The present invention is directed to a ligated metal-organic framework (MOF) for use in removing both anionic and cationic species from a liquid or liquid stream. The present invention also provides methods for placing the MOF on a substrate to form a MOF-containing product that can be used in the removal of certain species from a given fluid. The MOF may be a Zr-based MOF, such as NU-1000, for removal of certain anions, such as oxy-anions, or having an attached thiosulfonyl-thiol (—SO2—S—R2—SH, where R2 is an alkyl group) ligand for complexation with certain cationic species in addition to the anions. The substrate may be any substrate to which a given MOF may be attached, including inert polypropylene polymer resin beads, a macroscopic fabric such as a mesh material or mesh filter, and a molecular fabric.