Finken Water Treatment, Plumbing, Heating & Cooling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 342174,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://finkens.com",
      "title": "Finken Water Treatment, Plumbing, Heating & Cooling",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 92868,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-02-10T00: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": 11466,
      "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": "f495907a-e78c-11ef-a909-b66e99367f32",
      "subdate": "Feb 10, 2025",
      "subcategory": "Water Filter System",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "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": "Finken Water Treatment, Plumbing, Heating & Cooling in St. Cloud, MN offers comprehensive solutions for home and commercial water quality, plumbing, and HVAC needs. Specializing in advanced water treatment systems, expert plumbing services, and efficient heating and cooling solutions, Finken ensures optimal comfort and safety for your environment. Trusted in Minnesota, Finken combines quality service with technical excellence.",
      "service1": "Free Water Testing",
      "service2": "Aqua Systems",
      "service3": "Bryant Factory Authorized Dealer",
      "service4": "IBC",
      "service5": "Reznor",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-02-10 08:56:45"
   },
   "location": {
      "uuid": "f495907a-e78c-11ef-a909-b66e99367f32",
      "link_id": 342174,
      "account_id": 92868,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11466",
      "zip": "56301",
      "address": "3423 County Road 74",
      "phone": "+1 320-258-2005",
      "fax": null,
      "email": "finkens@brite-mail.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.5119598",
      "lon": "-94.2201968",
      "cityname": "St. Cloud",
      "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": ""
}