I remember visiting relatives in Gary, IN when I was a kid. The water was so malodorous (sulfur) it made me sick. What a foul stench — you had to hold your nose to get it down. Amazing I still remember that after about 53 years. I don’t think there’s a filter on the market that could make that stuff palatable.
I have a similar memory...only it was about 30 miles south of Seattle....my Girl Scout Leader’s house....they kept the water in a pitcher in the fridge to make it palatable.
Not being sarcastic, Schuylkill River water is treated by reverse osmosis to provide Philadelpia's drinking water.
Makes one wonder ---
That foul odor is actually caused by a harmless (iron oxidizing) bacteria that lives in sandstone and produces that sulfur smell (sulfur dioxide I believe) as a biproduct.
We have it here in Southern Illinois too and a simple inline carbon filter takes care of the problem nicely.