Abstract: Various embodiments of an end-of-faucet filter assembly connectable with a faucet on a standard sink and having a plurality of outlets corresponding with selectable modes of operation are disclosed herein. One mode of operation provides unfiltered, aerated water dispensed from the filter assembly. A second mode of operation provides a pulsing jet spray, while a third mode of operation provides filtered water. One embodiment of the present invention also includes a connection assembly between the end-of-faucet filter and the faucet that utilizes a water-tight radial seal that allows the end-of-faucet filter to swing or rotate back and forth relative to the faucet without impairing the integrity of the seal. Other embodiments of the present invention also include a filter cartridge assembly configured to provide a user with an easy method of removing and installing the cartridge.