JPW PLUMBING CO.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347157,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://jpw-plumbing.com/",
      "title": "JPW PLUMBING CO.",
      "description": "JPW Plumbing is a licensed and insured Glenview plumbing company serving North Side Chicagoland since 2014. Founded by Jerry, we deliver the highest standards of professionalism and reliability with $2 million insurance coverage, free consultations, and a 1-year labor warranty, ensuring customer satisfaction through our commitment to excellence and personal service.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97852,
      "approve_dt": "2025-07-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-19T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 13,
      "city_id": 5521,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "72236613-349d-11f0-a909-b66e99367f32",
      "subdate": "May 19, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 12
   },
   "visits": {
      "storefront": 12,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Established in 2014, JPW Plumbing stands as a testament to unwavering dedication, a commitment to excellence, and the personal touch of our founder, Jerry. With a wealth of experience in the plumbing industry, Jerry's leadership shines through in aspect of our company, ensuring that we deliver the highest standards of professionalism, reliability, and customer satisfaction. JPW Plumbing offers expert plumbing services for both residential and commercial needs. Their services include plumbing repairs, sump pump installation, sewer line replacement, drain rodding, and re-piping. They specialize in providing the best water heaters and ensuring your plumbing systems run efficiently. They ensure high-quality solutions for every issue.",
      "service1": "Residential Plumbing",
      "service2": "Commercial vehicle insurance",
      "service3": "Plumbing Installation",
      "service4": "Plumbing Repair",
      "service5": "New Construction Plumbing",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-05-19 10:38:48"
   },
   "location": {
      "uuid": "72236613-349d-11f0-a909-b66e99367f32",
      "link_id": 347157,
      "account_id": 97852,
      "company": "JPW PLUMBING CO.",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 13,
      "city": "5521",
      "zip": "60026",
      "address": "2228 Strawberry Lane",
      "phone": "+1 773-962-1022",
      "fax": null,
      "email": "jpwplumbing@brite-post.com",
      "name": "JPW PLUMBING CO.",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.095743",
      "lon": "-87.8415476",
      "cityname": "Glenview",
      "statename": "Illinois"
   },
   "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": ""
}