My post to this question was deleted 'because this resembles an advertisement'. I assure you this is not the case. Previous to some edits I would of understood it being done for the reasons of missing the point or off topic. Having already edited it to make it look less so, and an attempt to more closely answer the question, what recourse can I take to get a deleted-by-moderator post undeleted? Now that it is, comments are closed so there is no option for discussion (to reach the moderator) other than meta questions similar to this one that I've seen.
You should edit it so it doesn't look like an advertisement. Sorry if that sounds flippant but that's basically all you can do. The moderator would only have deleted it because it was flagged as spam by another user. In fact it was flagged by two users as spam - so that's at least three people who saw the post and thought it was spam.
Once you've edited it, flag it with the "other" option and we'll take another look and hopefully we'll be able to undelete it.
On the plus side I saw the original spam flag and declined it - but only after reading and re-reading it a few times, so I'm not surprised that other people also thought it was spam. It took me that long to realise that it wasn't an advert.
Deleting the post was my acknowledgement that this post was very gray, with multiple community members thinking it was spam, but myself and others not believing you were a spammer. There's a -100 reputation hit if your post was actually verified as a spam message, so I tend to use the delete button as a middle ground when things are gray.
Things to do to avoid looking like spam, don't link to or mention specific products. Rather, try to focus on types of products. Links to other other forums also get a little more scrutiny because the spam could be posted in another forum. A post saying "No, don't use what you were thinking of using. Here's product X 5001 with a lifetime warranty, user testimonials, and if you act now there's a special 2 for 1 offer!" come across as a resurrected Billy Mays. As ChrisF suggests, edit the question to remove the links and product recommendation, and instead focus on the type of product you should use instead along with your own reasons for the recommendation, and then flag us to have a look.