American Rooter

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332269,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://americanrooterpa.com/",
      "title": "American Rooter",
      "description": "American Rooter - Expert Trenchless Pipe Lining & Excavation Services. With a decade of professional experience, our licensed team specializes in advanced plumbing solutions for both residential and commercial sectors. From meticulous repairs and installations to efficient drain cleaning and water heater services, we also excel in trenchless pipe lining and precision excavation work. Expect exceptional craftsmanship, rapid service, and unwavering commitment to customer satisfaction.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83058,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 10,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19192,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d62d3b33-345f-11ef-8344-b66e99367f32",
      "subdate": "Jun 27, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 33
   },
   "visits": {
      "storefront": 33,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "American Rooter - Expert Trenchless Pipe Lining&Excavation Services. With a decade of professional experience, our licensed team specializes in advanced plumbing solutions for both residential and commercial sectors. From meticulous repairs and installations to efficient drain cleaning and water heater services, we also excel in trenchless pipe lining and precision excavation work. Expect exceptional craftsmanship, rapid service, and unwavering commitment to customer satisfaction.",
      "service1": "Drain Cleaning",
      "service2": "Hydro Jetting",
      "service3": "Pipe Repair",
      "service4": "Trenchless Pipe lining",
      "service5": "Excavation",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-27 08:32:49"
   },
   "location": {
      "uuid": "d62d3b33-345f-11ef-8344-b66e99367f32",
      "link_id": 332269,
      "account_id": 83058,
      "company": "American Rooter",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19192",
      "zip": "18224",
      "address": "1934 State Route 940",
      "phone": "570-672-4813",
      "fax": null,
      "email": "americanrooterpa@brite-post.com",
      "name": "American Rooter",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.9915212",
      "lon": "-75.9109779",
      "cityname": "Freeland",
      "statename": "Pennsylvania"
   },
   "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": ""
}