Advanced Drain Cleaning Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347528,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.advanceddrainpro.com",
      "title": "Advanced Drain Cleaning Inc",
      "description": "Advanced Drain Cleaning offers 24/7 services in Chelmsford and nearby areas. From clogged sinks to sewer line issues, we handle it all - hydro jetting, video inspections, grease traps, and more. Fast, reliable, and budget-friendly service you can trust.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98223,
      "approve_dt": "2025-07-21T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 18,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 9927,
      "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": 6647,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e06e95b5-38a8-11f0-a909-b66e99367f32",
      "subdate": "May 24, 2025",
      "subcategory": "Cleaning Supplies",
      "request_types": "",
      "visitcount": 50
   },
   "visits": {
      "storefront": 50,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Advanced Drain Cleaning, Inc. specializes in commercial drain maintenance designed to keep businesses running without interruptions, backups, or costly shutdowns. They focus exclusively on commercial systems that require more attention, quickness, and technological expertise than residential ones, serving hospitals, restaurants, retail stores, schools, and other businesses with proactive maintenance solutions and expert knowledge of local compliance codes.",
      "service1": "commercial drain maintenance",
      "service2": " proactive maintenance plans",
      "service3": " emergency after-hours service",
      "service4": " drain catastrophe prevention",
      "service5": " compliance code expertise",
      "service6": " planned service programs",
      "service7": " commercial system cleaning",
      "submit_dt": "2025-05-24 14:10:41"
   },
   "location": {
      "uuid": "e06e95b5-38a8-11f0-a909-b66e99367f32",
      "link_id": 347528,
      "account_id": 98223,
      "company": "Advanced Drain Cleaning Inc",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "9927",
      "zip": "01824",
      "address": "2 Courthouse Ln",
      "phone": "(978) 437-0125",
      "fax": null,
      "email": "advanceddraincleaning@outlook.com",
      "name": "Advanced Drain Cleaning Inc",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.6240974",
      "lon": "-71.3590567",
      "cityname": "Boston",
      "statename": "Massachusetts"
   },
   "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": ""
}