Snake ''n'' Rooter Plumbing Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328320,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.snakenrooterplumbing.com/",
      "title": "Snake ''n'' Rooter Plumbing Company",
      "description": "Since 1991, Snake n'' Rooter Plumbing Company has been a family-owned and operated full-service plumbing company. They provide emergency services to both commercial and residential properties 24 hours a day, seven days a week. If you need us in the morning, afternoon, or evening, you can expect flexible pricing that is designed to be affordable, with no extra fees paid for service offered on evenings, weekends, or hidolidays. Visit website today for more information.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79157,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-02-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 13,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 25,
      "city_id": 12563,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8c69bfb9-c72f-11ee-8344-b66e99367f32",
      "subdate": "Feb 09, 2024",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 58
   },
   "visits": {
      "storefront": 58,
      "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": "Since 1991, Snake n' Rooter Plumbing Company has been a family-owned and operated full-service plumbing company. They provide emergency services to both commercial and residential properties 24 hours a day, seven days a week. If you need us in the morning, afternoon, or evening, you can expect flexible pricing that is designed to be affordable, with no extra fees paid for service offered on evenings, weekends, or hidolidays. Visit website today for more information.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-02-09 09:42:32"
   },
   "location": {
      "uuid": "8c69bfb9-c72f-11ee-8344-b66e99367f32",
      "link_id": 328320,
      "account_id": 79157,
      "company": "Snake 'n' Rooter Plumbing Company",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12563",
      "zip": "64064",
      "address": "3370 NE Ralph Powell Rd",
      "phone": "816-554-3337",
      "fax": null,
      "email": "snakenrooterplumbing@outlook.com",
      "name": "Snake ''n'' Rooter Plumbing Company",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.9734724",
      "lon": "-94.3605932",
      "cityname": "Missouri City",
      "statename": "Missouri"
   },
   "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": ""
}