Hines Pool and Spa | Pool Service - Pool cleaning, repair and remodeling.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309589,
      "site_id": 68,
      "cat_id": 79,
      "priority": 0,
      "url": "http://www.hinespool.com",
      "title": "Hines Pool and Spa | Pool Service - Pool cleaning, repair and remodeling.",
      "description": "Hines Pool & Spa has been cleaning, repairing, renovating, and maintaining pools and spas in Central Texas since 1986. Our pool service is the best in Texas. What makes Hines Pool & Spa stand out from the competition is our promise – complete satisfaction to all of our customers. \r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60825,
      "approve_dt": "2015-05-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-05-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 797,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21346,
      "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": 1794,
      "subcat_id": 5141,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9548c2cf-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 27, 2015",
      "subcategory": "Swimming Pool Cleaning Service",
      "request_types": "",
      "visitcount": 945
   },
   "visits": {
      "storefront": 945,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Hines Pool and Spa, the pros at our company are pool & spa experts! Weu2019re insured, certified, experienced and licensed (TICL #274).   We are proud to be Central Texasu2019s largest pool services company, and we are locally owned! The variety and depth we offer in pool services and pool products is unbeatable. We are known as the education pool company.",
      "service1": "Pool cleaning",
      "service2": " Pool repair",
      "service3": " pool renovating",
      "service4": " pool resurfacing",
      "service5": " pool tile and coping",
      "service6": " commercial pool cleaning",
      "service7": " pool classes",
      "submit_dt": "2015-05-28 01:35:48"
   },
   "location": {
      "uuid": "9548c2cf-56da-11ed-b77c-b66e99367f32",
      "link_id": 309589,
      "account_id": 60825,
      "company": "Hines Pool and Spa | Pool Service",
      "sid": 68,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21346",
      "zip": "78758",
      "address": "900 McPhaul Street",
      "phone": "",
      "fax": "",
      "email": "hinespoolaustin@gmail.com",
      "name": "Hines Pool and Spa | Pool Service - Pool cleaning, repair and remodeling.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "30.376339",
      "lon": "-97.6915202",
      "cityname": "Austin",
      "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": ""
}