Aqualistic Water Products

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319139,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://aqualistic.com/",
      "title": "Aqualistic Water Products",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70334,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-06-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 143,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2095,
      "ltop": "",
      "facebook": "https://www.facebook.com/AqualisticWater/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957906bc-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 03, 2020",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 176
   },
   "visits": {
      "storefront": 176,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Aqualistic provides customers with peace of mind knowing that they are drinking and bathing in the best possible home water filtration systems available today. Our whole house water filters provide crystal clear alkaline mineral drinking water and chlorine-free water for your shower and bathtub. Our whole house water softener systems prolong appliance life and remove the hard minerals that destroy fixtures. Your clothes, hair, and skin will be softer and you will use less soap. Providing Los Angeles, Orange, Riverside, and San Bernardino county customers with whole house and point of use water purification and filtration systems. Over 30 years of plumbing experience to ensure your system will provide many years of trouble-free service. ",
      "service1": "water purification and filtration systems",
      "service2": "home water filtration systems",
      "service3": "orange county whole house water filters",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-06-03 11:38:15"
   },
   "location": {
      "uuid": "957906bc-56da-11ed-b77c-b66e99367f32",
      "link_id": 319139,
      "account_id": 70334,
      "company": "Aqualistic Water Products",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2095",
      "zip": "90631",
      "address": "1121 Woodcrest Ave",
      "phone": "(562) 697-2070",
      "fax": null,
      "email": "aqualisticca@outlook.com",
      "name": "Aqualistic Water Products",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.9452462",
      "lon": "-117.933573",
      "cityname": "La Habra",
      "statename": "California"
   },
   "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": ""
}