London Drainage Facilities Ltd

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348055,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.london-drainage.com/",
      "title": "London Drainage Facilities Ltd",
      "description": "London Drainage Facilities Ltd has been a leading drainage and plumbing service provider since 2006, serving London and the entire Southeast of England. Conveniently located near the M25, our expert teams provide rapid emergency response 24/7/365, backed by significant expansion and a strong reputation for reliable service.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98750,
      "approve_dt": "2025-07-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 476,
      "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": 5877,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e63d959f-404a-11f0-a909-b66e99367f32",
      "subdate": "Jun 03, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 58
   },
   "visits": {
      "storefront": 58,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 17,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Since 2006, London Drainage Facilities Ltd has built a strong reputation as one of the leading drainage and plumbing service providers in London and beyond.\n
\n
Over the past three years, our company has experienced significant expansion, enabling us to serve clients across the entire Southeast of England. Conveniently located near the M25, our expert teams are on standby to respond swiftly to any drainage emergency, ensuring rapid assistance 24 hours a day, 7 days a week, 365 days a year.",
      "service1": "Emergency Drainage Services",
      "service2": " Plumbing Repairs and Installation",
      "service3": " 24/7 Emergency Response",
      "service4": " Drainage System Maintenance",
      "service5": " Commercial Drainage Solutions",
      "service6": " Residential Plumbing Services",
      "service7": " Southeast England Coverage",
      "submit_dt": "2025-06-03 07:18:08"
   },
   "location": {
      "uuid": "e63d959f-404a-11f0-a909-b66e99367f32",
      "link_id": 348055,
      "account_id": 98750,
      "company": "London Drainage Facilities Ltd",
      "sid": 76,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "476",
      "zip": "EC1V 4PY",
      "address": "145-157 Saint John Street",
      "phone": "+44 800 612 2179",
      "fax": null,
      "email": "londondrainage@brite-post.com",
      "name": "London Drainage Facilities Ltd",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "51.5267316",
      "lon": "-0.1000575",
      "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": ""
}