Ummm....really?
Do what I did a few years ago: buy books, do research, start out small, and don't try to make Hollywood-quality special effects in your first video because you'll be sorely disappointed.
However, you might have luck with asking a relative if they have a truck you can blow up, and hope to God that it does the flip you need. Other than that, you're pretty much out of luck unless you're good at modeling in 3D, texturing, and animating.
EDIT:
After re-reading your post, you're definitely going to have to opt for 3D modeling and animation. You definitely can't make a house look like it got blow'd up, unless you somehow have the power to get permission to blow one up. It seems you're getting way ahead of yourself here. You definitely need to start out smaller and not attempt to make Hollywood-quality effects. Sorry, but it's the truth.
Buy books, do research, join forums dedicated to this sort of thing, and perhaps take a course in video stuff at your school and don't be afraid to ask the teacher questions. Chances are they'll be more than happy to help out in any way they can.