Superior Water Treatment - Your Authorized Ecowater Dealer

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337438,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://superiorwatertucson.com/",
      "title": "Superior Water Treatment - Your Authorized Ecowater Dealer",
      "description": "\"EcoWater is the largest manufacturer of water treatment systems in the world, and Superior Water Treatment has satisfied many Tucson residents with great tasting, conditioned water. At Superior Water Treatment, our reputation for quality products and service puts us ahead of the competition.\"",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88167,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-29T00: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": 3,
      "city_id": 1070,
      "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": 5891,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "01b1e668-95ca-11ef-ab46-b66e99367f32",
      "subdate": "Oct 29, 2024",
      "subcategory": "Water Filter System",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Tankless Reverse Osmosis Drinking Water Systems",
      "service2": "Well Water Testing",
      "service3": "Whole Home Water Filtration",
      "service4": "Water Heater Replacement",
      "service5": "Water Softener Salt Delivery",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-29 07:47:11"
   },
   "location": {
      "uuid": "01b1e668-95ca-11ef-ab46-b66e99367f32",
      "link_id": 337438,
      "account_id": 88167,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1070",
      "zip": "85711",
      "address": "5401 E 29th St",
      "phone": "(520) 487-5742",
      "fax": null,
      "email": "superiorwatertu@mail-burst.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.0390116",
      "lon": "41.9631954",
      "cityname": "Tucson",
      "statename": "Arizona"
   },
   "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": ""
}