Affordable Water Solution.com

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349594,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "https://www.affordablewatersolution.com/",
      "title": "Affordable Water Solution.com",
      "description": "Affordable Water Solutions is a local family-owned business started in 1997 by Larry Gastley, my father. Over the next 25 years, with the slogan, “We clean your water, not your wallet,” he grew the business based 100% on word-of-mouth advertising and client referrals. Since then, we have proudly served thousands of clients across Pasco, Citrus, and Hernando Counties.\n\nWe understand that every water source is unique, and that’s why we prioritize a personalized approach. Our skilled technicians will assess your specific water requirements and recommend the most suitable and cost-effective solutions for your property. We believe that clean and safe water shouldn’t come at a hefty price tag, so we strive to provide affordable options without compromising on the quality of our services.\n\nWith Affordable Water Solutions, you can have peace of mind knowing that your water treatment needs are being handled by professionals who are committed to your satisfaction. Don’t let water issues disrupt your daily life or business operations. Trust Affordable Water Solutions to provide you with reliable, efficient, and affordable water treatment services that will transform the quality of your water supply.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100289,
      "approve_dt": "2025-07-27T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3596,
      "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": 4290,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a8e2f5d1-6ac1-11f0-a909-b66e99367f32",
      "subdate": "Jul 27, 2025",
      "subcategory": "Water Purification",
      "request_types": "",
      "visitcount": 46
   },
   "visits": {
      "storefront": 46,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Affordable Water Solutions specializes in resolving common water quality problems including metallic taste, sulfur odors, staining, and cloudiness. They provide comprehensive water treatment systems to ensure homeowners have access to clean, safe water while helping them save money on plumbing repairs, appliance maintenance, and bottled water purchases.",
      "service1": "Water Purification System",
      "service2": "Reverse Osmosis System",
      "service3": "Well Water Chemical Injection System",
      "service4": "Well Water Treatment",
      "service5": "Well Water Testing",
      "service6": "Water Conditioning",
      "service7": "Water Treatment",
      "submit_dt": "2025-07-27 08:14:04"
   },
   "location": {
      "uuid": "a8e2f5d1-6ac1-11f0-a909-b66e99367f32",
      "link_id": 349594,
      "account_id": 100289,
      "company": "Affordable Water Solutions",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3596",
      "zip": "34453",
      "address": "3485 E. Lake Nina Dr.",
      "phone": "",
      "fax": null,
      "email": "affordablewaterinverness@gmail.com",
      "name": "affordablewatersolution.com",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Inverness",
      "statename": "Florida"
   },
   "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": ""
}