Windsor Plumbing and Heating

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 352916,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://www.windsorplumbingandheatingltd.ca/",
      "title": "Windsor Plumbing and Heating",
      "description": "Windsor Plumbing and Heating is a trusted plumbing and heating contractor with over 17 years of experience, providing expert service, renovations, gasfitting, and residential and small commercial solutions. Our team is committed to quality workmanship, reliable service, and long-lasting results. Proudly serving Nanaimo, Duncan, and surrounding areas, Windsor Plumbing and Heating handles everything from routine maintenance to complex plumbing and heating projects, ensuring your home or business stays safe, comfortable, and efficient.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 103677,
      "approve_dt": "2026-04-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-04-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": null,
      "countrycode": null,
      "loc_id": null,
      "state_id": null,
      "city_id": null,
      "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": 5877,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4918d6f0-4306-11f1-bb42-b66e99367f32",
      "subdate": "Apr 28, 2026",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 2
   },
   "visits": {
      "storefront": 2,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Windsor Plumbing and Heating is a trusted plumbing and heating contractor with over 17 years of experience, providing expert service, renovations, gasfitting, and residential and small commercial solutions. Our team is committed to quality workmanship, reliable service, and long-lasting results. Proudly serving Nanaimo, Duncan, and surrounding areas, Windsor Plumbing and Heating handles everything from routine maintenance to complex plumbing and heating projects, ensuring your home or business stays safe, comfortable, and efficient.",
      "service1": "Emergency Repair",
      "service2": "Gas Fitting",
      "service3": "Gas Water Heater Installation",
      "service4": "Gas Boiler Installation",
      "service5": "Furnace Repair",
      "service6": "Commercial Plumbing",
      "service7": "Residential Plumbing",
      "submit_dt": "2026-04-28 13:29:30"
   },
   "location": {
      "uuid": "4918d6f0-4306-11f1-bb42-b66e99367f32",
      "link_id": 352916,
      "account_id": 103677,
      "company": "Blair Windsor",
      "sid": 76,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "0",
      "zip": "V9N 3C2",
      "address": "10806 Chemainus Road",
      "phone": "(250) 533-9862",
      "fax": null,
      "email": "citations+WPAH@pagepros.io",
      "name": "Windsor Plumbing and Heating",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "statename": ""
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}