How to best clean foggy windows?

Judy....Try Windex with lemon or vinegar and wipe with newspapers. It works well for me!

Vinegar & water

Have you tried automobile glass cleaner? I would give it a try. https://amzn.to/2JZUzxG

This is the best glass cleaner I have found. Awesome stuff. It's a foam and leaves a streak free finish. I discovered it when a professional glass man used it replacing a shower door in my home. It's less than $3/can and can be found at most grocery stores, Target, Home Depot, Lowes... One you try it, you'll never buy liquid glass cleaner again. Hope this is helpful. :)

I use a vinegar rinse, it gets rid of the residue from other cleaners.

Here's a post that might help https://chascrazycreations.com/eco-friendly-window-and-mirror-cleaning/