MZR Commercial & Domestic Drainage Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331926,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://blockeddrainsbirmingham.co.uk/",
      "title": "MZR Commercial & Domestic Drainage Services",
      "description": "MZR Drainage offers a 24/7 drain unblocking service in Birmingham and the West Midlands. From small to more server drainage issues, we have the experience and know how to deal with all types of situations. If you have a blocked drain in Birmingham and need emergency support then we can typically be out to you within an hour. We also provide CCTV surveys to help identify what is causing the blockage as well as giving the customer complete peace of mind.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82715,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 17,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 464,
      "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": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3bfe018f-2d3d-11ef-8344-b66e99367f32",
      "subdate": "Jun 18, 2024",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 40
   },
   "visits": {
      "storefront": 40,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "MZR Drainage offers a 24/7 drain unblocking service in Birmingham and the West Midlands. From small to more server drainage issues, we have the experience and know how to deal with all types of situations. If you have a blocked drain in Birmingham and need emergency support then we can typically be out to you within an hour. We also provide CCTV surveys to help identify what is causing the blockage as well as giving the customer complete peace of mind.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-18 06:37:29"
   },
   "location": {
      "uuid": "3bfe018f-2d3d-11ef-8344-b66e99367f32",
      "link_id": 331926,
      "account_id": 82715,
      "company": "MZR Commercial & Domestic Drainage Services",
      "sid": 66,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "464",
      "zip": "B36 0ET",
      "address": "287 Chester Rd, 2nd floor Rudgeway House",
      "phone": "0121 663 1060",
      "fax": null,
      "email": "blockeddrawd@burst-email.com",
      "name": "MZR Commercial & Domestic Drainage Services",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "52.5014435",
      "lon": "-1.7641825",
      "cityname": "Birmingham",
      "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": ""
}