All Star Rooter

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349893,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "https://www.allstar-rooter.com/",
      "title": "All Star Rooter",
      "description": "All Star Rooter provides top-rated drain and sewer cleaning services for residential and commercial customers in Norwalk, CT, and nearby areas, including Stamford, Westport, Wilton, and New Canaan. Our experienced technicians use cutting-edge technology to deliver fast, reliable solutions for clogged drains, sewer line cleaning, hydro jetting, video inspections, tub and toilet drain cleaning, rust removal, and pipe thawing. We also provide 24/7 emergency plumbing services, ensuring your home's plumbing runs smoothly. From routine drain maintenance to urgent sewer backups, we’re your trusted partner for exceptional service. Choose All Star Rooter for affordable, efficient plumbing solutions that get the job done right the first time!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100588,
      "approve_dt": "2025-09-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 7,
      "city_id": 3118,
      "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": 4197,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f0c52dd7-8550-11f0-bb42-b66e99367f32",
      "subdate": "Aug 30, 2025",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 61
   },
   "visits": {
      "storefront": 61,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 30,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "All Star Rooter provides top-rated drain and sewer cleaning services for residential and commercial customers in Norwalk, CT, and nearby areas, including Stamford, Westport, Wilton, and New Canaan. Our experienced technicians use cutting-edge technology to deliver fast, reliable solutions for clogged drains, sewer line cleaning, hydro jetting, video inspections, tub and toilet drain cleaning, rust removal, and pipe thawing. We also provide 24/7 emergency plumbing services, ensuring your home's plumbing runs smoothly. From routine drain maintenance to urgent sewer backups, we’re your trusted partner for exceptional service. Choose All Star Rooter for affordable, efficient plumbing solutions that get the job done right the first time!",
      "service1": "water jetting",
      "service2": "water drain inspection",
      "service3": "pipe thawing",
      "service4": "drain cleaning",
      "service5": "plumbers",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-08-30 03:25:13"
   },
   "location": {
      "uuid": "f0c52dd7-8550-11f0-bb42-b66e99367f32",
      "link_id": 349893,
      "account_id": 100588,
      "company": "All Star Rooter",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "3118",
      "zip": "06851",
      "address": "9 Shadow Ln",
      "phone": "(203)-286-4498",
      "fax": null,
      "email": "marketingallstarrooter@gmail.com",
      "name": "All Star Rooter",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Norwalk",
      "statename": "Connecticut"
   },
   "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": ""
}