Rubbish Waste

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313231,
      "site_id": 6,
      "cat_id": 53,
      "priority": 2,
      "url": "http://www.rubbishwaste.co.uk/bounds-green-N22/",
      "title": "Rubbish Waste",
      "description": "We make sure your domestic or commercial waste goes to the right place without harming the environment. Our workforce consists of well-trained waste experts who are ready to help you clear out your property in no time. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 64460,
      "approve_dt": "2017-06-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-04-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1758,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 476,
      "ltop": "",
      "facebook": "https://www.facebook.com/Rubbish-Waste-Ltd-476467052502126/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/rubbishwaste_",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "https://www.youtube.com/watch?v=dRsss01J8AI&feature=youtu.be",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/RubbishWasteLtd/",
      "yelp": "https://www.yelp.co.uk/biz/rubbish-waste-london-2",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 4214,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "955a0903-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 20, 2017",
      "subcategory": "Cleaning Services",
      "request_types": "",
      "visitcount": 2314
   },
   "visits": {
      "storefront": 2314,
      "articles": 0,
      "videos": 0,
      "reviews": 29,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Rubbish removal has never been a challenge to us but with recent waste reports, we witness increasing and alarming amounts of household and commercial waste being released into the environment. \nRubbish Waste have been part of the waste management industry for a long time and continue to provide a variety of clearance services in and around London.  We’ll tend to all flat clearance or domestic clearance, and don’t worry if you’ve got a top floor flat, we can still haul out old kitchen cabinet, green waste, old ovens! Our domestic waste clearance specialists will make your property the cleanest space in the neighbourhood. We even handle disused printer‎s clearance, broken bathroom cabinets recycle, old dishwasher disposal.",
      "service1": "Commercial rubbish clearance",
      "service2": " Garden waste removal",
      "service3": " House clearance",
      "service4": " Domestic Rubbish Clearance",
      "service5": " Rubbish removal",
      "service6": " Waste collection",
      "service7": " Builders Waste Removal",
      "submit_dt": "2017-04-20 08:46:28"
   },
   "location": {
      "uuid": "955a0903-56da-11ed-b77c-b66e99367f32",
      "link_id": 313231,
      "account_id": 64460,
      "company": "Rubbish Waste",
      "sid": 6,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "476",
      "zip": "N1 6DR",
      "address": "24 Corsham Street",
      "phone": "",
      "fax": null,
      "email": "webmaster@rubbishwaste.co.uk",
      "name": "Rubbish Waste",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "51.5278095",
      "lon": "-0.0865408",
      "cityname": "London",
      "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": ""
}