Rubbish Removal Hampstead

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 308731,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "http://www.mrrubbishremovalhampstead.co.uk",
      "title": "Rubbish Removal Hampstead",
      "description": "Our Hampstead NW3 house clearance team have been fully vetted before entering our service, and they''re completely insured, too. They''re the best at what they do and have been trained to the highest standards and equipped with top of the range loading and safety equipment. That all adds up to one dependable and secure service for house clearing!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 59962,
      "approve_dt": "2015-02-23T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-02-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1011,
      "referrals": null,
      "country": 265,
      "countrycode": "UK",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 476,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 4214,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95441610-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 17, 2015",
      "subcategory": "Cleaning Services",
      "request_types": "",
      "visitcount": 1248
   },
   "visits": {
      "storefront": 1248,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We Offer Rapid Rubbish Removal in Hampstead NW3\nThere's no better choice for rubbish clearance than MR Rubbish Removal Hampstead. You'll be able to fully customise any of our services to fit your junk removal requirements. Whether you need a big one off warehouse clearance, or you're looking for ongoing cover from a dependable regular junk collection service, we'll be able to provide a convenient and affordable waste collection that will meet and exceed your specific requirements.",
      "service1": "Carpet Cleaning",
      "service2": "End of Tenancy Cleaning",
      "service3": "Hard Floor Cleaning",
      "service4": "Upholstery Cleaning",
      "service5": "Window Cleaning",
      "service6": "Domestic Cleaning",
      "service7": "",
      "submit_dt": "2015-02-18 07:43:14"
   },
   "location": {
      "uuid": "95441610-56da-11ed-b77c-b66e99367f32",
      "link_id": 308731,
      "account_id": 59962,
      "company": "Rubbish Removal Hampstead",
      "sid": 58,
      "country": 265,
      "countrycode": "UK",
      "state": 0,
      "city": "476",
      "zip": "",
      "address": "",
      "phone": "",
      "fax": "",
      "email": "mrrubbishremovalhampstead@abv.bg",
      "name": "Rubbish Removal Hampstead",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "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": ""
}