Schaefers Soft Water

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317542,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://schaeferssoftwater.com/",
      "title": "Schaefers Soft Water",
      "description": "At Schaefer’s Soft Water, we carry water softner systems that are approved for the state of Wisconsin and calibrated to deliver the freshest possible drinking water into your home. We manufacture and distribute the most complete line of products and components for residential, commercial and industrial water conditioning equipment in the industry. Get in touch with Schaefer’s Soft Water today.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68740,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-08-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 146,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 49,
      "city_id": 24904,
      "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": 6503,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95704ec8-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 06, 2019",
      "subcategory": "Warehouse Equipment",
      "request_types": "",
      "visitcount": 196
   },
   "visits": {
      "storefront": 196,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Water Softener Installation",
      "service2": "Water Heaters Systems",
      "service3": "Water Softeners",
      "service4": "Water Heater",
      "service5": "Water Softening Equipment",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-08-06 04:57:54"
   },
   "location": {
      "uuid": "95704ec8-56da-11ed-b77c-b66e99367f32",
      "link_id": 317542,
      "account_id": 68740,
      "company": "Schaefers Soft Water",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 49,
      "city": "24904",
      "zip": "53098",
      "address": "824 N. Church Street",
      "phone": "920-261-3908",
      "fax": null,
      "email": "schaeferssoftwater4@gmail.com",
      "name": "Schaefers Soft Water",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "43.2081917",
      "lon": "-88.7360095",
      "cityname": "Watertown",
      "statename": "Wisconsin"
   },
   "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": ""
}