International Free Classifieds Expats Ad Expatriates Classified Free Ad Posts
ExpatAds Bookmark and Share Free Classifieds

Free Classifieds     USA     Saudi Arabia     UAE     Canada     UK

    FREE INTERNATIONAL CLASSIFIEDS BY COUNTRY
    Browse expats or local community ad postings from a country of your choice
 
 
 USA         UK/England    Netherlands      Saudi Arabia    UAE              Canada    France
   China       India              Pakistan            Germany          Hong Kong   Bahrain    Kuwait
   Russia      Singapore     South Africa       Malaysia          Australia       Qatar       Philippines
 
 Portugal   Japan            Oman                 Brazil       
 

 

 

 
   FREE INTERNATIONAL CLASSIFIED ADS BY CATEGORY
    Browse different categories for thousands of ads by expatriates & locals in Free Classifieds


Business Opportunities (8407)
  Business Offers (6537)
  Business Wanted (1870)

Property & Real Estate (3905)
  For Sale: Plots, Buildings (1771)
  For Lease / Rent: Commerical & Residential (1401)
  Property Wanted (733)

Cars / Automobiles (244)
  Buy Cars & Automobiles (31)
  Sell Cars & Automobiles (213)

Jobs & Employment (6613)
  Jobs Wanted (2168)
  Jobs Available (4445)

Education & Career (3048)
  Tuition, Courses, Training, Seminars (3048)

Computers & IT (667)
  Computers & Laptops (226)
  IT Products (441)

Innovations & Ideas (29)
  Looking for an Idea (10)
  Share your Idea or Innovation (19)

Websites and Blogs (374)
  Advertise your website(s) (352)
  Advertise your blog(s) (22)

Fitness & Health Care (124)
  Health Care Products (62)
  Food & Dietary Supplements (12)
  Fitness & Gym (22)
  Beauty and Skin Care (23)
  Bio, Organic & Herbal Products (5)

Housing & Accommodation (5053)
  AVAILABLE: Flats Houses Villas Rooms (1854)
  WANTED: Flats Houses Villas Rooms (1097)
  AVAILABLE Short Stay: Flats Villas Rooms (1078)
  WANTED Short Stay: Flats Houses Villas Rooms (1024)

Items, Gadgets, Households (4165)
  Sell: Household Items & Gadgets (2135)
  Buy: Household Items & Gadgets (2030)

Trade, Imports & Exports (270)
  Trade Inquiries, Offers & Qoutation (104)
  Import Export Offers/Inquiries (166)

Pets & Animals (2317)
  Pets Adoption (1838)
  Pets Veterinary & Disease Cure (8)
  Buy, Sell or Exchange Pets (391)
  Pets & Animals Food and Diets (80)

Event Announcements (132)
  Post & View All Events (132)

Sports & Hobbies (27)
  Soccer (9)
  Football (5)
  Baseball (1)
  BasketBall (0)
  Cricket (4)
  Ice Hockey (1)
  Hockey (0)
  Tennis (0)
  Squash (1)
  Badminton (0)
  Golf (6)

Travel, Airlines & Ticketing (200)
  Travel Destinations (82)
  Hotels & Lodging (38)
  Tour Packages (64)
  Cheap Airline Tickets (16)

Marriage & Matrimonials (101)
  Marriage/Wedding Management (82)
  Looking for Groom (11)
  Looking for Bride (8)

Corporate Services (119)
  Accounting & Bookkeeping (21)
  Lawyers, Attorneys & Legal Services (98)


  Featured Ads
  Related Countries/region - look for more local classified ads
  Latest Adverts Free Classifieds fresh RSS Feed advert 
SELECT a.*, ct.cityname, UNIX_TIMESTAMP(a.createdon) AS timestamp, feat.adid AS isfeat, COUNT(*) AS piccount, p.picfile AS picfile, scat.subcatname, scat.catid, cat.catname FROM xzclf_ads a INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid INNER JOIN xzclf_subcats scat ON a.subcatid = scat.subcatid INNER JOIN xzclf_cats cat ON scat.catid = cat.catid LEFT OUTER JOIN xzclf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' AND feat.featuredtill >= NOW() LEFT OUTER JOIN xzclf_adpics p ON a.adid = p.adid AND p.isevent = '0' WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND ct.countryid = 4 GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 20Server shutdown in progress