Sky Blue Pools

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313988,
      "site_id": 68,
      "cat_id": 79,
      "priority": 2,
      "url": "http://skybluepools.net/",
      "title": "Sky Blue Pools",
      "description": "Sky Blue Pools is a family owned and operated pool company offering swimming pool repair, installation, maintenance & more in Long Island, Suffolk County & Nassau County, NY. Call us at 631-586-2135.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65214,
      "approve_dt": "2018-03-30T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-12-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1203,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 14836,
      "ltop": "",
      "facebook": "http://www.facebook.com/pages/Sky-Blue-Pools/686608878084685",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/SkyBlue_Pools",
      "googleplus": "https://plus.google.com/104518057039495836759/posts",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5127,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "955db718-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 12, 2017",
      "subcategory": "Swimming Pool Contractor",
      "request_types": "",
      "visitcount": 1636
   },
   "visits": {
      "storefront": 1636,
      "articles": 0,
      "videos": 0,
      "reviews": 41,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Sky Blue Pools is a leading provider of high quality in ground pools, pool maintenance, pool repairs as well as Heating and Cooling Services in Islip, NY, Long Island, Suffolk County, Nassau County, and other surrounding areas in New York. A swimming pool should be a serene oasis for you and your family members to enjoy. In ground pools not only make your outdoor space look fabulous, they can increase the value of your home as well. Even though most homeowners love their pools, they absolutely hate the maintenance and care that comes along with them. If you need professional pool services you can trust, you have come to the right place. Our technicians at Sky Blue Pools can offer comprehensive maintenance services, equipment, supplies, and everything you will need to keep your pool in pristine condition.",
      "service1": "Repair",
      "service2": " Installation",
      "service3": " Maintenance",
      "service4": " Renovations & Upgrades",
      "service5": " HVAC",
      "service6": "",
      "service7": "",
      "submit_dt": "2017-12-12 08:03:14"
   },
   "location": {
      "uuid": "955db718-56da-11ed-b77c-b66e99367f32",
      "link_id": 313988,
      "account_id": 65214,
      "company": "Sky Blue Pools",
      "sid": 68,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "14836",
      "zip": "11729",
      "address": "94 North Industry Court",
      "phone": "631-586-2135",
      "fax": null,
      "email": "skybluepools80@gmail.com",
      "name": "Sky Blue Pools",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.7667056",
      "lon": "-73.2979045",
      "cityname": "Deer Park",
      "statename": "New York"
   },
   "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": ""
}