I use the Cateye CS-1000 which has an integrated cyclo-computer with speed, distance, calorie count and power output in watts. Its probably over your budget, but the best I've used. See
here
Rollers are great, but unreasonable in a small apartment.
Focus only on the magnetic trainers, since the wind trainers make too much noise.
I have used Minoura, but have heard very good thing about the Cycleops that Judah recommends. The Tacx look good too, especially their ergotrainer, but $$$. With the Blackburn stands on eBay you should use a geared bike to make easy changes to resistance. Also its a good idea to use a front wheel support to keep your bike level with these types of trainers.
For Gold Sprints and such kind of events it would be great to have some device to give you feedback on your training. Since these races are based on time or distance.
On the cheap you can buy one of the used standalone trainers (Cycleops, Tacx, Minoura or Blackburn) off ebay and buy a cyclo computer like the Cateye Astrale which has a rear wheel sensor to keep a record of your efforts based on speed, cadence, distance and time.
With a trainer ($100-125), front wheel stand ($20-30) and computer with a rear wheel sensor ($30), you are under $200.