Hello @cocotypo. I will add to what Jim has already said. Whatever trainer you go with you will want to use a mat under it.
One of the quietest trainers that we carry is the Wahoo Kickr Core. When set up correctly most of what you hear is your chain/ drivetrain.
Hopefully you can build a set up that allows you to get the riding that you want in and not irritate your neighbors.