Pool Service and Repair - Play Water Pools

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309863,
      "site_id": 58,
      "cat_id": 79,
      "priority": 0,
      "url": "http://www.playwaterpools.com",
      "title": "Pool Service and Repair - Play Water Pools",
      "description": "A trustworthy service for residential pools, commercial pools and fountains by fully trained professionals Established in 2010 PlayWater Pools is a family owned and operated local business specializing in pool service and repair.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61099,
      "approve_dt": "2015-07-09T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-07-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1065,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2337,
      "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": 5134,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954a37b1-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 03, 2015",
      "subcategory": "Swimming Pool Repair",
      "request_types": "",
      "visitcount": 1179
   },
   "visits": {
      "storefront": 1179,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are a full service pool maintenance and repair company. We currently serve Pasadena and the surrounding areas. We love what we do and are very proud of the quality of workmanship and the excellent customer service we provide to our customers. We want to thank you for taking the time to visit our website and hope that we will have the opportunity to earn your business.\nPlayWater Pools is a dedicated full service company that specializes in pool repairs, equipment maintenance, chemical and customeroriented services. With experienced specialists at hand, our service is guaranteed no matter the issue. PlayWater Pools offers a year round maintenance service that assesses, analyzes and procedures all the necessary developments at affordable, poolspecific rates. Ranging from residential pools to commercial, our experience explores all options carefully and manages each pool individually and thoroughly. Every technician in mandates efficiency and speed of service; specializing in any form of equipment varying from heaters, pumps, filters and salt systems",
      "service1": "Heater Repair",
      "service2": " Variable Speed Pump Install",
      "service3": " Filter Repair",
      "service4": " New Skimmer Installs",
      "service5": " Underground Plumbing",
      "service6": " Crack Repair",
      "service7": " Leak Detection ",
      "submit_dt": "2015-07-03 06:28:30"
   },
   "location": {
      "uuid": "954a37b1-56da-11ed-b77c-b66e99367f32",
      "link_id": 309863,
      "account_id": 61099,
      "company": "Play Water Pools",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2337",
      "zip": "91107",
      "address": "3579 E. Foothill Blvd #624",
      "phone": "(626) 755-8279",
      "fax": "",
      "email": "mikecrapo12345@gmail.com",
      "name": "A trustworthy service for residential pools, commercial pools and fountains by fully trained professionals",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.1334739",
      "lon": "-117.8928883",
      "cityname": "Pasadena",
      "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": ""
}