Yelm Plumbing and Pumps

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318322,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.yelmplumbingandpumps.com/",
      "title": "Yelm Plumbing and Pumps",
      "description": "Yelm Plumbing and Pumps is full service plumbing company, we are fully equipped to meet your needs whenever you need it. We are committed to meeting every need of our clients, which means being available around the clock for you and your household. Whether you are experiencing a leak that needs immediate service or your bathroom is overflowing, we will respond as soon as possible to assess and repair the problem. our plumbing technicians are prepared to tackle whatever problem you’re facing. We are pleased to offer same day service to our customers because we understand that most plumbing problems can’t wait to be fixed in a few weeks. At Yelm Plumbing and Pumps, we offer service you can rely on! Don’t wait to call us for the help you deserve. You can contact us by calling 360-292-1811.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69515,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-01-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 148,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23741,
      "ltop": "",
      "facebook": "https://www.facebook.com/yelmplumbingandpumps",
      "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": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95749ec7-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jan 15, 2020",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 195
   },
   "visits": {
      "storefront": 195,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Yelm Plumbing and Pumps is full service plumbing company, we are fully equipped to meet your needs whenever you need it. We are committed to meeting every need of our clients, which means being available around the clock for you and your household. Whether you are experiencing a leak that needs immediate service or your bathroom is overflowing, we will respond as soon as possible to assess and repair the problem. our plumbing technicians are prepared to tackle whatever problem youu2019re facing. We are pleased to offer same day service to our customers because we understand that most plumbing problems canu2019t wait to be fixed in a few weeks. At Yelm Plumbing and Pumps, we offer service you can rely on! Donu2019t wait to call us for the help you deserve. You can contact us by calling 360-292-1811.\r\n",
      "service1": "Plumbers",
      "service2": "Well Pump Services",
      "service3": "Drain Cleaning",
      "service4": "Water Heater Repair",
      "service5": "Plumbing Services",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-01-16 04:38:03"
   },
   "location": {
      "uuid": "95749ec7-56da-11ed-b77c-b66e99367f32",
      "link_id": 318322,
      "account_id": 69515,
      "company": "Yelm Plumbing and Pumps",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23741",
      "zip": "98503",
      "address": "7225 Pacific Ave SE",
      "phone": "360-292-1811",
      "fax": null,
      "email": "yelmplumbingandpumps@hotmail.com",
      "name": "Yelm Plumbing and Pumps",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.041705",
      "lon": "-122.7846062",
      "cityname": "Lacey",
      "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": ""
}