Check out a Sony SA-WX700
Dual 10" woofers in a push-pull design. 250 watt digital amp (power rating seems true to me, have pushed this sub hard) Can buy for about $230.00 shipped online.
Not the build quality you'll find in more expensive subs. Very clever design. Loud, low, and believe it or not musical. (nothing like the boomy subs Sony generally makes)
Think you can actually go hear one at Circuit City. Might be surprised . Love mine and think it would be hard to beat for under $500.00