The video I posted shows my girlfriend trying out the trainer for the first time. It does seem quite loud, however it should be known that my home is a large open space with concrete floors (what is typical of loft apartments), so expect the unit to be slightly quieter in smaller apartments or ones with carpeting.
My girlfriend was using the trainer and even though I could hear the buzzing, it wasn't obnoxiously loud. She was able to enjoy watching her Netflix on her iPad while I surfed the web nearby. I asked if she though it was loud, and her response was "it could be quieter".
If you must have a SUPER quiet trainer, then this one isn't it. Otherwise this is a really good bargain, it works well, easy to set up and feels very smooth.
There are two ways to increase resistance on this trainer. The easy way is to just change gears. Magnetic resistance increases with wheel spin. Keep in mind the faster you go, the louder your bike and the trainer will get. The other alternative is to increase the pressure of the roller against the tire on the resistance unit, which is just a turn or two on the big knob. This way you can keep the speed low and still get a good workout.
Anyway, for less than $100 you are getting a trainer that will give you as good a workout as any other trainer that costs 3 or even 4 times as much. Honestly, I don't see why anyone would want to spend more on something like this. Use that extra money you save on a juicer or something to supplement your training program.
Anyway I hope the video gives you a good idea of what this trainer sounds like. Good luck!