I think you were on the right track.
Bionaire Twin Reversible Airflow Window Fan with Remote Control
https://www.amazon.com/dp/B000065DKJ/ref=asc_df_B000065DKJ5266964/?tag=hyprod-20&creative=394997&creativeASIN=B000065DKJ&linkCode=df0&hvadid=167146990738&hvpos=1o3&hvnetw=g&hvrand=4906811742098891053&hvpone=&hvptwo=&hvqmt=&hvdev=c&hvdvcmdl=&hvlocint=&hvlocphy=9016422&hvtargid=pla-275832104833With a remote control for convenient adjustment, this double window fan draws in fresh, cool air from the outside or exhausts stale, hot air from inside.
It can also do both simultaneously, because each of the two fans can be set independently to draw in or exhaust out, allowing the unit to exchange inside and outside air.
If you investigate a little further, I'm sure you can find one cheaper, but that is what I'd be looking for.
Problem solved, till it gets really hot outside. You can set one fan to blow in and one fan to blow out. Will turn the room into a freezer....