Shining Houndoom has yet to be produced in the US....unless you're talking about a regular holofoil Houndoom...or a reverse holo. Totally different.
A shining Pokemon(cards now defined as having a star by their name) are only released 1 per 3 boxes, or 108 packs. In the grand scheme of card collecting, it is not one of the rarest cards, but it is a rare card.
Shining Rayquaza, depending on the condition, generally goes for $20-$30 on Ebay.