Free State Well & Pump

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346127,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.freestatewell.com/",
      "title": "Free State Well & Pump",
      "description": "Free State Well is a dedicated team of water well professionals committed to being the leading and most trusted provider of high-quality water well services, focusing on delivering clean, reliable water access through environmentally safe practices, exceptional customer service, and integrity-driven solutions that nourish life and build thriving communities.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96822,
      "approve_dt": "2025-08-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 16,
      "city_id": 8546,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a343cc52-2564-11f0-a909-b66e99367f32",
      "subdate": "Apr 30, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 30
   },
   "visits": {
      "storefront": 30,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Free State Well & Pump, we specialize in providing top-quality drilling, repair, inspections, maintenance and treatment services for residential and commercial well projects. With a focus on precision, efficiency, and reliability, we utilize the latest technology to handle all types of drilling needs, from water well drilling to specialized projects requiring unique equipment and techniques. We are committed to delivering exceptional results while ensuring minimal disruption to your property.",
      "service1": "Water well drilling",
      "service2": " Well pump installation and repair",
      "service3": " Water treatment systems",
      "service4": " Solar water systems",
      "service5": " Well maintenance and servicing",
      "service6": " Water quality testing",
      "service7": " Environmental water solutions",
      "submit_dt": "2025-04-30 01:44:21"
   },
   "location": {
      "uuid": "a343cc52-2564-11f0-a909-b66e99367f32",
      "link_id": 346127,
      "account_id": 96822,
      "company": "Free State Well & Pump",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 16,
      "city": "8546",
      "zip": "67204",
      "address": "Service Area",
      "phone": "316-202-4007",
      "fax": null,
      "email": "freestatewellks@brite-post.com",
      "name": "Free State Well & Pump",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.7803142",
      "lon": "-97.3624598",
      "cityname": "Wichita",
      "statename": "Kansas"
   },
   "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": ""
}