Are you still looking for an in-wall/in-ceiling subwoofer? The CSW200 is a kick@$$ sub. I got to play with the prototype before the actual product was shipping and it was awesome. It made some pretty sick base.
You mentioned that you wanted an in-wall sub, the CSW200 is an in-ceiling/in-floor sub as it is verly deep. I don't remember the exact dimensions but I know it is atleast 8-10". If you need an true in-wall them go with the CSW155. It is only 3 1/2" deep. Also keep in mind that all the CSW sub are non-powered so you will need a seperate amp to drive them.
If you are interested in a CSW200 then let me know as i have one that i have never opened that i am looking to get rid of. I got it for my personal use and then decided that i would wait for the CSW155 as it would work better for my application. I'll treat you well on price if you are intested.