Walz Plumbing & Heating

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310582,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://www.walzplumbing.com/",
      "title": "Walz Plumbing & Heating",
      "description": "Walz Plumbing & Heating is a 4th generation plumbing company, servicing Binghamton, New York and surrounding areas. We have the experience and knowledge to do high quality work the right way. With 20 years experience, we are confident in taking care of any high end plumbing or Air Conditioning Services. If you are remodeling your home or building a custom house, we are the plumbing contractor for you! Along with our quality of work, we also focus on doing the right thing for our customers. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61817,
      "approve_dt": "2015-09-30T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1717,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 0,
      "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": 5006,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954e238c-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 30, 2015",
      "subcategory": "Commercial Plumbing",
      "request_types": "",
      "visitcount": 2109
   },
   "visits": {
      "storefront": 2109,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Walz Plumbing & Heating is a 4th generation plumbing company, servicing Binghamton, New York and surrounding areas. We have the experience and knowledge to do high quality work the right way. With 20 years experience, we are confident in taking care of any high end plumbing or Air Conditioning Services. If you are remodeling your home or building a custom house, we are the plumbing contractor for you! Along with our quality of work, we also focus on doing the right thing for our customers. We educate our customers and will always recommend a repair if a replacement is not necessary. Call us today for all of your plumbing and air conditioning needs! \nWe educate our customers and will always recommend a repair if a replacement is not necessary. Call us today for all of your plumbing and air conditioning needs!\n",
      "service1": "plumbing service",
      "service2": " plumbing contractor",
      "service3": " affordable plumbing",
      "service4": " drain repair",
      "service5": " remodeling plumber",
      "service6": " AC repair",
      "service7": " Air Conditioning installation",
      "submit_dt": "2015-09-30 10:42:51"
   },
   "location": {
      "uuid": "954e238c-56da-11ed-b77c-b66e99367f32",
      "link_id": 310582,
      "account_id": 61817,
      "company": "Walz Plumbing & Heating",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "0",
      "zip": "13901",
      "address": "656 1/2 State Street",
      "phone": "(607) 651-8612",
      "fax": "",
      "email": "lukewalz12345@gmail.com",
      "name": "Walz Plumbing & Heating",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.123067",
      "lon": "-75.895172",
      "cityname": "",
      "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": ""
}