Mr. Clean

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 316112,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.mrclean.ch",
      "title": "Mr. Clean",
      "description": "Mr. Clean is a specialized building cleaning company when it comes to clean premises. The building cleaning includes work like surface cleaning and protective treatments.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 67315,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-11-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 118,
      "referrals": null,
      "country": 246,
      "countrycode": "CH",
      "loc_id": 246,
      "state_id": 0,
      "city_id": 0,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9568a3e7-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 14, 2018",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 143
   },
   "visits": {
      "storefront": 143,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mr. Clean is the professional cleaning company in Switzerland. The company provides all kinds of cleaning services like house cleaning, building cleaning, and moving cleaning. If you are looking for any of these services then Mr. Clean is the right place for you.",
      "service1": "moving cleaning",
      "service2": "",
      "service3": "house cleaning",
      "service4": "",
      "service5": "Building cleaning",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-11-14 08:46:14"
   },
   "location": {
      "uuid": "9568a3e7-56da-11ed-b77c-b66e99367f32",
      "link_id": 316112,
      "account_id": 67315,
      "company": "Mr. Clean",
      "sid": 6,
      "country": 246,
      "countrycode": "CH",
      "state": 0,
      "city": "0",
      "zip": "8004",
      "address": "Zweierstrasse 45 8004 Zu00fcrich - Schweiz",
      "phone": "+41 44 241 40 40",
      "fax": null,
      "email": "web@perfectshape.ch",
      "name": "Mr. Clean",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.3726023",
      "lon": "8.5251233",
      "statename": ""
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}