ExpressRooter Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330914,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://expressrooter.ca/",
      "title": "ExpressRooter Plumbing",
      "description": "ExpressRooter is your best option in Mississauga and the Greater Toronto Area for all your plumbing needs. Our expertise lies in drain cleaning, plumbing repairs and other plumbing related services, making us highly acclaimed as one of the best rated plumbers. Whether you find yourself in need of emergency or immediate plumbing assistance our skilled team is always prepared to lend a hand. As a plumbing company ExpressRooter is committed to delivering dependable and top-notch services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81717,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 24,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 1328,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "cf0e6118-1411-11ef-8344-b66e99367f32",
      "subdate": "May 17, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 62
   },
   "visits": {
      "storefront": 62,
      "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": "ExpressRooter is your best option in Mississauga and the Greater Toronto Area for all your plumbing needs. Our expertise lies in drain cleaning, plumbing repairs and other plumbing related services, making us highly acclaimed as one of the best rated plumbers. Whether you find yourself in need of emergency or immediate plumbing assistance our skilled team is always prepared to lend a hand. As a plumbing company ExpressRooter is committed to delivering dependable and top-notch services.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-17 05:53:39"
   },
   "location": {
      "uuid": "cf0e6118-1411-11ef-8344-b66e99367f32",
      "link_id": 330914,
      "account_id": 81717,
      "company": "ExpressRooter Plumbing",
      "sid": 66,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "1328",
      "zip": "L5E1E8",
      "address": "1093 Lakeshore Rd E, Mississauga",
      "phone": "(416) 233-2660",
      "fax": null,
      "email": "expressrooter@brite-email.com",
      "name": "ExpressRooter Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "43.5785139",
      "lon": "-79.5574354",
      "cityname": "Ontario",
      "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": ""
}