Pool Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309849,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://www.watterscleanpoolservice.com",
      "title": "Pool Service",
      "description": "Fully licensed and insured CA#921955\nWe are your in ground pool/spa service and repair specialists. Serving North County San Diego. We offer a variety of service plans along with repairs, and troubleshooting to keep your pool/spa pristine year round.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61085,
      "approve_dt": "2015-08-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-07-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1055,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2470,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5882,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954a25a2-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 02, 2015",
      "subcategory": "Swimming Pool Repair",
      "request_types": "",
      "visitcount": 1329
   },
   "visits": {
      "storefront": 1329,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Fully licensed and insured CA#921955\n\nWe are your in ground pool/spa service and repair specialists. Serving North County San Diego. We offer a variety of service plans along with repairs, and troubleshooting to keep your pool/spa pristine year round.\n\nWith free estimates, and free energy saving consultations there is no risk to contact us for pool service today!\n\nWe troubleshoot, repair, and install equipment and parts for in-ground pool and spa systems..\n\nResidential/Commercial\nPumps\nHeaters\nSalt systems\nLights\nControl panels\nAutomation products\nForeclosure clean ups\nElectrical problems\nPlumbing issues\nAnti-entrapment drain covers\nand more..... \n\nHistory\n\nEstablished in 2006.\n\nI learned the pool business for two years working with a company that has been in business for 20 years. Starting my own company in 2006 with a customer base of around 20, we have more than tripled our clientele size based on customer referrals alone.\n\nBeing family owned and operated allows us to give a personalized touch to our services, which helps to ensure customer service and happy customers.\n\nWe proudly service most areas of North County San Diego.",
      "service1": "Pool Spa Service and Repair",
      "service2": " Weekly Maintenance",
      "service3": " Chemical Service",
      "service4": "  Pump/Motor Service & Repair",
      "service5": " Troubleshooting",
      "service6": " Heater Service & Repair",
      "service7": " Salt System Service and Repair",
      "submit_dt": "2015-07-02 09:14:33"
   },
   "location": {
      "uuid": "954a25a2-56da-11ed-b77c-b66e99367f32",
      "link_id": 309849,
      "account_id": 61085,
      "company": "Pool Service",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2470",
      "zip": "92079",
      "address": "PO Box 8",
      "phone": "760-910-4178",
      "fax": "",
      "email": "lancewatters12345@gmail.com",
      "name": "Pool Service",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.14",
      "lon": "-117.17",
      "cityname": "San Marcos",
      "statename": "California"
   },
   "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": ""
}