This is all the usual advice, which works for a few days, but during a period of over a week of high temperatures, there's nothing you can do.
The sun will eventually heat up every part of the house and turn it into a radiator.
Even when night time temperatures drop to 17c, I have my have windows open at 10pm with a decent cross-wind, my bedroom temperature may drop from 26c to 24c after 2-3 hours, but if I close the windows, it jumps to 25c in ~30 minutes...
The streets probably don't help either - no trees, just asphalt, front yards with paving slabs etc