Hi.
I was in the same situation than you. In my case, the solution was the Stac Zero trainer. It does zero noise, and provides enough resistance - say, 320 watt / 90 95 rpm on the biggest gear.
If you live in an old apartment with shitty walls, forget any trainer other than this one. Just keep the drivetrain superclean and use some stuff to minimize vibrations.