AquaGuard Injection & Waterproofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 316673,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.aquaguardinjection.com",
      "title": "AquaGuard Injection & Waterproofing",
      "description": "Services\r\n\r\nFoundation crack repair, Basement waterproofing, Interior perimeter drain system installation, Window well and cover installation and replacement, Sump pump installation and replacement, Exterior foundation crack waterproofing, Basement waterproofing and leak repair services\r\n
\r\nService Hours\r\nMonday-Saturday 8:00 am–8:00 pm\r\nSunday 10:00 am–6:00 pm",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 67871,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-02-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 111,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 1328,
      "ltop": "",
      "facebook": "https://www.facebook.com/AquaGuard-Injection-Waterproofing-182387261801052",
      "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": 4250,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956b885c-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 23, 2019",
      "subcategory": "Waterproofing",
      "request_types": "",
      "visitcount": 165
   },
   "visits": {
      "storefront": 165,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "AquaGuard Injection & Waterproofing is a full service basement waterproofing company established in 2002.\r\n\r\nProviding service to Aurora, Newmarket, Richmond Hill and Markham from our Aurora site we are the premier experts in foundation crack repair and base crack sealing. These concrete crack repairs for poured concrete foundations are carried out from inside your basement, these injections are the cheapest basement leak maintenance you can find.\r\n\r\nStressed about being fleeced by contractors? You can rely on us with your basement leak repairs - we are a member of the Better Business Bureau, be sure to review our feedback on Homestars and Google Maps confirming that we are trusted by homeowners all throughout the GTA.",
      "service1": "Basement leak repair",
      "service2": "Foundation crack repair",
      "service3": "Basement waterproofing",
      "service4": "Waterproofing company",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-02-23 05:33:33"
   },
   "location": {
      "uuid": "956b885c-56da-11ed-b77c-b66e99367f32",
      "link_id": 316673,
      "account_id": 67871,
      "company": "AquaGuard Injection & Waterproofing",
      "sid": 58,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "1328",
      "zip": "L4G0R4",
      "address": "Suite 407-16 Industrial Parkway, Aurora",
      "phone": "(905) 713-0222",
      "fax": null,
      "email": "aquaguardinjection@gmail.com",
      "name": "AquaGuard Injection & Waterproofing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "44.0002784",
      "lon": "-79.4568963",
      "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": ""
}