Waterworks Irrigation

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 320138,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://waterworksirrigation.ca/",
      "title": "Waterworks Irrigation",
      "description": "From maintenance, repair, and emergency services to custom work and landscaping, Waterworks Irrigation is the best that Victoria has to offer residential and commercial clients.  Our professionals provide unmatched customer service, and at waterworksirrigation.ca, you can get your free quote within 48 hours. Contact Waterworks today.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71330,
      "approve_dt": "2021-03-09T00:00:00.000Z",
      "source": null,
      "submit_dt": "2020-11-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 438,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 1323,
      "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": 5190,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957dd50d-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 10, 2020",
      "subcategory": "Landscape Contractors",
      "request_types": "",
      "visitcount": 537
   },
   "visits": {
      "storefront": 537,
      "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": "Waterworks believes in delivering a quality product with quality workmanship.\nWith our 3 year warranty, and certified irrigation technician staff installing to the IIABC standards you will be satisfied with your project for years to come. Whether it be a pond, irrigation system, landscape lighting or landscapes, Waterworks staff have multiple certifications and combined years of experience, and would be happy to help create the outdoor living space you desire.",
      "service1": "Irrigation",
      "service2": " Landscape Lighting",
      "service3": " Landscaping",
      "service4": " Water Features",
      "service5": " Custom Feature Construction",
      "service6": " Drone Services",
      "service7": "",
      "submit_dt": "2020-11-10 14:01:15"
   },
   "location": {
      "uuid": "957dd50d-56da-11ed-b77c-b66e99367f32",
      "link_id": 320138,
      "account_id": 71330,
      "company": "Waterworks Irrigation",
      "sid": 69,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "1323",
      "zip": "V8Z 2C5",
      "address": null,
      "phone": "(778) 269-3900",
      "fax": null,
      "email": "waterworkbc@offilive.com",
      "name": "Waterworks Irrigation",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "British Columbia",
      "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": ""
}