Ecowater Systems

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335475,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://lindsayecowater.com/",
      "title": "Ecowater Systems",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86220,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 23,
      "city_id": 11309,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "31a38c48-74cf-11ef-ab46-b66e99367f32",
      "subdate": "Sep 17, 2024",
      "subcategory": "Water Filter System",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We provide and service water treatment equipment manufactured right here in Minnesota! We help local Minnesota, North Dakota, and The Lakes Region families get great tasting, healthy, soft water so they can worry less&enjoy life more. Our solutions include under-sink drinking water systems, whole-home filtration, water softening, and well water treatment " all backed by local, reliable service. Contact us today to learn more!",
      "service1": "Whole House Water Filters",
      "service2": "Well Water Testing",
      "service3": "Reverse Osmosis Drinking Water Systems",
      "service4": "Water Softeners",
      "service5": "Water Softener Salt Delivery",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-17 08:31:11"
   },
   "location": {
      "uuid": "31a38c48-74cf-11ef-ab46-b66e99367f32",
      "link_id": 335475,
      "account_id": 86220,
      "company": "Ecowater Systems",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11309",
      "zip": "56560-2223",
      "address": "107 14th Street North",
      "phone": "(218) 228-3460",
      "fax": null,
      "email": "lindsayecowater@brite-email.com",
      "name": "Ecowater Systems",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "46.8762672",
      "lon": "-96.7580501",
      "cityname": "Moorhead",
      "statename": "Minnesota"
   },
   "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": ""
}