THE PREFERRED PLUMBING COMPANY

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310494,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://www.perkspreferredplumbingllc.com/",
      "title": "THE PREFERRED PLUMBING COMPANY",
      "description": "Perks Preferred Plumbing company is a full-service company specializing in all aspects of plumbing for commercial, residential and multi-family housing. We are a family- owned and operated company with over 26 years of experience in the Plumbing industry. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61729,
      "approve_dt": "2015-09-22T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1040,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23732,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5877,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954da3ac-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 21, 2015",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 1300
   },
   "visits": {
      "storefront": 1300,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Perks Preferred Plumbing company is a full-service company specializing in all aspects of plumbing for commercial, residential and multi-family housing.\n\nWe are a family- owned and operated company with over 26 years of experience in the Plumbing industry. Over the years we have progressed in our success with professionalism, integrity, honesty and our dedication to taking pride in our workmanship. With dedication and confidence, we guarantee our workmanship and materials. \nWhen you're dealing with Perks Preferred Plumbing LLC, you're in the best of hands. Our operation is critical and want to keep it running as smoothly as your pipes will after we come clean them. Washington State Contractors Registration Number: PERKSPP864M9\n",
      "service1": "Residential",
      "service2": " Commercial",
      "service3": " Repairs",
      "service4": " Replacement",
      "service5": " Water Piping Upgrades",
      "service6": " Seismic Gas Valves",
      "service7": " Circulating Pump Repairs and Replacements",
      "submit_dt": "2015-09-22 01:17:56"
   },
   "location": {
      "uuid": "954da3ac-56da-11ed-b77c-b66e99367f32",
      "link_id": 310494,
      "account_id": 61729,
      "company": "Perks Preferred Plumbing LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23732",
      "zip": "98030",
      "address": "12916 south east 247th place",
      "phone": "(253) 797-0971",
      "fax": "",
      "email": "jamesperkins12345@gmail.com",
      "name": "THE PREFERRED PLUMBING COMPANY",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.380347",
      "lon": "-122.168751",
      "cityname": "Kent",
      "statename": "Washington"
   },
   "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": ""
}