Arrowhead Pools

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310496,
      "site_id": 68,
      "cat_id": 79,
      "priority": 0,
      "url": "http://arrowheadpools.com/",
      "title": "Arrowhead Pools",
      "description": "Arrowhead Pools is known for it''s superior customer service, innovative design and ingenuity. Chris Spurrier and Tom Sparks have over 32 years in business, as full construction and Swimming Pool Contractors. Arrowhead Pools is a local owned and operated business that prides itself on customer service. We believe great service starts with a relaxed, no pressure sales and design staff, and continues well beyond completion of the project. Arrowhead Pools is well known for its service which has been described as \"superior\" from our clients. Just a simple call will allow you to experience the most unique and creative designs for your family! We don''t just build pools, we build relationships and create a way for you to escape into an oasis of relaxation and fun! Take a vacation in your backyard today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61731,
      "approve_dt": "2015-09-22T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 2119,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 17824,
      "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": 5127,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954da725-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 22, 2015",
      "subcategory": "Swimming Pool Contractor",
      "request_types": "",
      "visitcount": 2549
   },
   "visits": {
      "storefront": 2549,
      "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": "Arrowhead Pools is known for it's superior customer service, innovative design and ingenuity. Chris Spurrier and Tom Sparks have over 32 years in business, as full construction and Swimming Pool Contractors. Arrowhead Pools is a local owned and operated business that prides itself on customer service. We believe great service starts with a relaxed, no pressure sales and design staff, and continues well beyond completion of the project. Arrowhead Pools is well known for its service which has been described as \"superior\" from our clients. Just a simple call will allow you to experience the most unique and creative designs for your family! We don't just build pools, we build relationships and create a way for you to escape into an oasis of relaxation and fun! Take a vacation in your backyard today!\r
",
      "service1": "Swimming Pools",
      "service2": " Swimming Pool Contractor",
      "service3": " custom pool contractor",
      "service4": "New Construction",
      "service5": " Remodels",
      "service6": "Service Repairs",
      "service7": "Fountains Above and In-Ground Pools",
      "submit_dt": "2015-09-22 04:22:08"
   },
   "location": {
      "uuid": "954da725-56da-11ed-b77c-b66e99367f32",
      "link_id": 310496,
      "account_id": 61731,
      "company": "Arrowhead Pools",
      "sid": 68,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "17824",
      "zip": "74014",
      "address": "Tulsa ",
      "phone": "918-955-5720",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "36.060949",
      "lon": "-95.7974526",
      "cityname": "Broken Arrow",
      "statename": "Oklahoma"
   },
   "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": ""
}