HQ Water Solutions

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346415,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.hqwatersolutions.com/",
      "title": "HQ Water Solutions",
      "description": "HQ Water Solutions is a family-owned water treatment company dedicated to providing pure, clean water solutions for residential customers. With a focus on improving water quality for homes and families, the company offers comprehensive water conditioning services tailored to meet individual household needs. Their commitment to excellence ensures customers receive reliable, effective water treatment systems that deliver the highest quality water for daily use.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97110,
      "approve_dt": "2025-08-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19369,
      "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": 288,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "aaeeb6aa-29c7-11f0-a909-b66e99367f32",
      "subdate": "May 05, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 26
   },
   "visits": {
      "storefront": 26,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Our mission at HQ Water Solutions is to help each customer achieve high-quality water. Our services include the professional installation, maintenance, and repair of various home water treatment systems, including water softener systems and home water filtration systems.",
      "service1": "Whole House Water Softeners",
      "service2": "Iron Filters and Filtration Systems",
      "service3": "Certified PFOA & PFAS Water Filter Systems",
      "service4": "Reverse Osmosis Systems",
      "service5": "Water Softener Salt Delivery",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-05-05 15:43:19"
   },
   "location": {
      "uuid": "aaeeb6aa-29c7-11f0-a909-b66e99367f32",
      "link_id": 346415,
      "account_id": 97110,
      "company": "HQ Water Solutions",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19369",
      "zip": "17602",
      "address": "307 S. Lime St.",
      "phone": "(717) 926-0435",
      "fax": null,
      "email": "hqwatersolutpa@brite-mail.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.0366918",
      "lon": "-76.300524",
      "cityname": "Lancaster",
      "statename": "Pennsylvania"
   },
   "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": ""
}