Blue Haven Pools & Spas

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309490,
      "site_id": 68,
      "cat_id": 79,
      "priority": 0,
      "url": "http://www.poolsbybluehaven.com/",
      "title": "Blue Haven Pools & Spas",
      "description": "Depend on one of the best pool companies in San Antonio, Blue Haven Pools & Spas, to provide more than you ever imagined for your swimming pool. In addition to an affordable, customized in-ground pool with value, you will enjoy the certainty that comes from choosing the most trusted name in backyard swimming pools—the acknowledged industry leader, backed by enduring warranties. Blue Haven Pools &",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60726,
      "approve_dt": "2015-05-17T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-05-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 1030,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22482,
      "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": 5119,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "954840ec-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 14, 2015",
      "subcategory": "Swimming Pools And Spas",
      "request_types": "",
      "visitcount": 1187
   },
   "visits": {
      "storefront": 1187,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Depend on one of the best pool companies in San Antonio, Blue Haven Pools & Spas, to provide more than you ever imagined for your swimming pool. In addition to an affordable, customized in-ground pool with value, you will enjoy the certainty that comes from choosing the most trusted name in backyard swimming pools—the acknowledged industry leader, backed by enduring warranties. Blue Haven Pools & Spas is a name tens of thousands of U.S. homeowners trust.\n\nYou will receive dependable service from an experienced local Blue Haven Pools & Spa’s team. Every office is bonded and insured, as well as fully licensed by the state of Texas as a contractor. We have expertise in local building conditions and the latest swimming pool-construction methods, and will provide you with a written contract that identifies the project’s phases, as well as outlining your payment arrangements.\n\nOur high-tech SmartFeatures™, designed and manufactured for by leading pool-equipment manufacturers, will assure that your ownership of a Blue Haven luxury pool is the untroubled, affordable experience that it should be.",
      "service1": "Commercial Pools",
      "service2": " Inground Pools",
      "service3": " Spa & Pool Combinations",
      "service4": " Pool Lighting",
      "service5": " Water Features",
      "service6": " Pool Remodeling",
      "service7": " Pool Builders",
      "submit_dt": "2015-05-17 13:52:26"
   },
   "location": {
      "uuid": "954840ec-56da-11ed-b77c-b66e99367f32",
      "link_id": 309490,
      "account_id": 60726,
      "company": "Blue Haven Pools",
      "sid": 68,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22482",
      "zip": "",
      "address": "",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "San Antonio",
      "statename": "Texas"
   },
   "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": ""
}