Spectrum Reptiles

Spectrum Reptiles ONLINE

 

Latest Classifieds

noimage
Trade Htc Pure for Tortoise or turtles
( / Trades)
Tuesday, 31 August 2010
Albino western hognose snake
Albino western hognose snake
(Snakes / Other Snakes)
Saturday, 24 July 2010

Member Login

*NOTE!! If you do not receive an email for activation, please check your spam or junk box for email as it may have been sent there



SELECT DISTINCT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid, u.name as user FROM #__adsmanager_ads as a LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE a.id=336 and c.published LIMIT 1
Ads arrow

$row->ad_headline

$row->ad_text
Price: $ $row->ad_price
Contact:
>>> Log in to view all contact details <<<
nopic
Back

Who's Online?

We have 2 guests online
Email us your 150x30 button to advertise in this block.
Banner
Banner
Banner
Visit our sponsors to keep this site FREE! Tell them you found them from Spectrum-Reptiles.com!

Search Classifieds


American Cricket Ranch Link
Banner