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=339 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 10 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