If you want quiet, then a fluid trainer like the Cyclops Fluid trainer is pretty quiet. I use a Preformance adjustable fluid trainer that is not as quiet as the Cyclops but at about 1/2 the price. If you will be using a multi geared bike the adjustable feature of the trainer is not really needed as you can change gears to make it harder or easier. The mag style trainers I've seen produce more nosie than the fluid trainers.

I also ride rollers and use the Preformance model that usually is on sale for $129 using which ever discount is available that day. Last winter I put skate board wheels on the trainer and utilize bungee cords to enable the trainer to move forwards and back. The movement allows me to be more aggressive on the rollers.

No matter what trainer type you use, a tire with traction bars will scream.

Here is a clip of the roller system in use that shows how it moves when I'm out of the saddle, and at the end, how the guide wheel on the front will keep the bike on the rollers.

http://i489.photobucket.com/albums/r...5/MVI_2805.mp4