• Post Ad
  • Post Event
  • My Account







  •  ClassiFRIEDads.Org Free Local Classified Ads.... Buy Sell Trade, Real Estate, Jobs, Services, Adult Dating, Escorts & Erotic Services..And So Much More!



    Local Places
    (0)
      Events (0)
      Bars/Clubs (0)
      Restaurants (0)
      Salons/Nails/Spas (0)

    Buy/ Sell/ Trade
    (9)
      Antiq.-Collectibles (0)
      Appliances (0)
      Business (6)
      Boats/Motorcycles (0)
      Farm/Garden (0)
      Clothing/Jewelry (1)
      Household Items (0)
      Computer/Electronics (1)
      Free (0)
      Furniture (0)
      Miscellaneous (1)
      Pets/Pet Supplies (0)
      Sports Equip. (0)
      Tickets (0)
      Tools/Materials (0)
      Want-Trade (0)
      Yard/Garage Sales (0)

    Community
    (0)
      Childcare (0)
      Classes/Workshops (0)
      General (0)
      Groups (0)
      Lost+Found (0)
      Rideshare (0)
      Volunteers (0)

    Automotive
    (0)
      Auto/Truck/RV (0)
      Auto Parts (0)
      Services (0)

    Real Estate
    (3)
      Co-ops/Condos (0)
      House/Condo (0)
      Land for Sale (0)
      Commercial (0)
      Miscellaneous (3)
      Wanted (0)

    Jobs
    (2)
      Accounting/Finance (0)
      Admin/Office (0)
      Computer/Technical (0)
      Customer Service (0)
      Domestic (0)
      Driver/Delivery/Courier (0)
      Education (0)
      Focus Group/Studies (0)
      Job Wanted/Resume (0)
      Management/Professional (0)
      Medical/Health (0)
      Miscellaneous (0)
      Part-time Jobs (0)
      Real Estate (0)
      Rest/Retail/Hotel (0)
      Sales/Marketing (2)
      Salon/Spa/Fitness (0)
      Show biz/Audition (0)
      Trades/Labor (0)

    Rentals
    (0)
      Roommates (0)
      Apt/Condo/House (0)
      Sublets (0)
      Commercial (0)
      Vacation (0)
      Miscellaneous (0)
      rentals wanted (0)

    Gigs
    (0)
      Computer (0)
      Creative (0)
      Crew (0)
      Domestic (0)
      Event (0)
      Labor (0)
      Writing (0)
      Talent (0)

    Musician
    (0)
      Available/Wanted (0)
      Equip/Instruments (0)
      Instruction (0)
      Services (0)
      Plug the Band (0)

    Services
    (45)
      Beauty (0)
      Computer (18)
      Creative (2)
      Event (0)
      Financial (6)
      Legal (0)
      Lessons (3)
      Automative (1)
      Household (0)
      Labor/Move (0)
      Skill'd Trade (1)
      Real Estate (1)
      Small Biz Ads (11)
      Therapeutic (0)
      Travel/Vac (2)
      Write/Ed/Tr8 (0)

    Dating
    (0)
      Women > Women (0)
      Women > Men (0)
      Men > Women (0)
      Men > Men (0)

    Erotic
    (5)
      Escort Agency (0)
      Female Escorts (4)
      Male Escorts (0)
      Body Rubs (0)
      Dom & Fetish (0)
      TS (0)
      Adult Jobs (0)
      Strippers & Strip Clubs (0)
      Phone & Websites (1)


      Featured Ads
    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 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_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 ( ct.countryid = 61 OR (a.multicity_countryid = -1 AND a.multicitytill > NOW()) ) GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 5Expression #37 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'class101_classifriedads.p.picfile' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by