24 Hours Plumbing Services | Longview, WA

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348069,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://pilotplumbinganddrain.com/longview/",
      "title": "24 Hours Plumbing Services | Longview, WA",
      "description": "Pilot Plumbing and Drain Services in Longview, WA, specialises in prompt emergency response, expert plumbing repairs, water heater services, and thorough drain and sewer maintenance. Their experienced team is dedicated to resolving any plumbing issue quickly and efficiently, ensuring the comfort and safety of your home with reliable, top-quality service tailored to meet the unique needs of the Longview community.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98764,
      "approve_dt": "2025-07-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23770,
      "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": 5018,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "470b4c90-4061-11f0-a909-b66e99367f32",
      "subdate": "Jun 03, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 47
   },
   "visits": {
      "storefront": 47,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pilot Plumbing and Drain Services in Longview, WA, specialises in prompt emergency response, expert plumbing repairs, water heater services, and thorough drain and sewer maintenance. Their experienced team is dedicated to resolving any plumbing issue quickly and efficiently, ensuring the comfort and safety of your home with reliable, top-quality service tailored to meet the unique needs of the Longview community.",
      "service1": "24 hour emergency plumber service near me",
      "service2": "24 hr emergency plumbing service",
      "service3": "commercial plumbing longview",
      "service4": "emergency plumbing repair longview",
      "service5": "gas line installation longview wa",
      "service6": "honest plumbers near me",
      "service7": "leak detection longview wa",
      "submit_dt": "2025-06-03 09:58:20"
   },
   "location": {
      "uuid": "470b4c90-4061-11f0-a909-b66e99367f32",
      "link_id": 348069,
      "account_id": 98764,
      "company": "Pilot Plumbing and Drain ",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23770",
      "zip": "98632",
      "address": "1339 Commerce Ave Ste 307, Longview, ",
      "phone": "(360) 326-0477",
      "fax": null,
      "email": "pilotplumbinganddrainlongview@gmail.com",
      "name": "Pilot Plumbing and Drain ",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "46.1381033",
      "lon": "-122.9344284",
      "cityname": "Longview",
      "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": ""
}