Pacific Blue Mechanical & Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348801,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://pacificbluemechanical.ca/",
      "title": "Pacific Blue Mechanical & Plumbing",
      "description": "Pacific Blue Mechanical & Plumbing is a trusted provider of plumbing and HVAC services in Vancouver, British Columbia. With over 15 years of experience, our licensed and certified professionals are dedicated to delivering high-quality solutions for both residential and commercial clients. We offer a comprehensive range of services, including emergency plumbing, commercial plumbing, shower and bathtub repair, tankless water heater services, water heater and hot water tank services, toilet installation and repair, drainage and sewer solutions, HVAC services, heating services, and air conditioning services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99495,
      "approve_dt": "2025-07-09T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "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": 5877,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f645d584-4b50-11f0-a909-b66e99367f32",
      "subdate": "Jun 17, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 33
   },
   "visits": {
      "storefront": 33,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pacific Blue Mechanical is your trusted Plumbing and HVAC partner based in Vancouver, BC, delivering reliable, high-quality services across British Columbia with a commitment to excellence, integrity, and customer satisfaction.\n",
      "service1": "Residential Plumbing",
      "service2": " Commercial Plumbing",
      "service3": " HVAC Installation",
      "service4": " HVAC Maintenance",
      "service5": " Boiler Services",
      "service6": " Emergency Plumbing Repairs",
      "service7": " Drain Cleaning",
      "submit_dt": "2025-06-17 07:59:15"
   },
   "location": {
      "uuid": "f645d584-4b50-11f0-a909-b66e99367f32",
      "link_id": 348801,
      "account_id": 99495,
      "company": "Pacific Blue Mechanical & Plumbing",
      "sid": 76,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "1323",
      "zip": "V6B 4M9",
      "address": "475 W Georgia St #830, Vancouver",
      "phone": "604-652-9468",
      "fax": null,
      "email": "pacificbluemechanicalcan@gmail.com",
      "name": "Pacific Blue Mechanical & Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "49.2812253",
      "lon": "-123.1154844",
      "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": ""
}