[support] Display Node with Template

[Fred Jones]

I have a site with a custom content type called Class. We have a file
in the theme called node-class.tpl.php.

Now the challenge is that we have need a URL like /featured_class
which will search based on a boolean CCK and randomly select any class
node which is marked as "Featured" and then display that.

I can do this with SQL and then redirect to the class node, but then
the URL changes to that of the node. They want the URL to stay the
same, ie. featured_class.

I can't wrap my head around this. I somehow need to get the
node-class.tpl.php in there b/c there's a lot of code in there for
displaying classes. The only solution I have thus far (that someone
else gave me) is to use template_preprocess_page() to select that node
template, based on the URL, and then use a custom function to find and
load the node in question. I'm not sure it will work, but before I
try, is there any other (better) way to do this?

Thanks!