Become an affiliate
Location: Lagos, Nigeria
Home » Nigeria » Lagos
See All
Banner Ads
FEATURED
Posted: 23 days ago

This ad can't be found...

Possible Reasons Are:

  • The ad is awaiting manual review
  • The all cities ad has not been paid for yet (it will appear on our classifieds as soon as you submit your payment)
  • The ad has expired
  • The link you followed is incorrect or the address is mistyped
  • The ad has been deleted


 Back to Main
Featured Ads See All Featured Ads
Featured Ads
If you'd like for your ad to be featured here, choose the "feature this ad" option while posting your local or all cities ad. Why should you feature your ad? As a rule, featured ads receive significantly more visits. Here's why:

• Featured ads have the FEATURED sign on them.
• Featured ads appear above the free / regular ads.
• Featured ads appear in the home page slider.
• Featured ads come up first in search results.
• Featured ads cannot be flagged for removal by users.

And... Featured ads do not have to be posted in the right categories. You can post your featured ad in any category you choose.
Close
SELECT a.*, ct.cityname, UNIX_TIMESTAMP(a.createdon) AS timestamp, a.extendedtill AS extended, a.bumptill AS bumpedad, COUNT(*) AS piccount, MIN(p.picfile) AS picfile, scat.subcatname, scat.catid, cat.catname FROM clf_ads a INNER JOIN clf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' AND feat.featuredtill >= NOW() INNER JOIN clf_cities ct ON a.cityid = ct.cityid INNER JOIN clf_subcats scat ON a.subcatid = scat.subcatid INNER JOIN clf_cats cat ON scat.catid = cat.catid LEFT OUTER JOIN clf_adxfields axf ON a.adid = axf.adid LEFT OUTER JOIN clf_adpics p ON a.adid = p.adid AND p.isevent = '0' WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0' AND ( a.cityid = 2008 OR (a.multicity_countryid = -1 AND a.multicitytill > NOW()) ) GROUP BY a.adid ORDER BY RAND() LIMIT 20Server shutdown in progress