Pool Deck Refurbishing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318303,
      "site_id": 68,
      "cat_id": 79,
      "priority": 2,
      "url": "https://www.pooldeckriverside.com/",
      "title": "Pool Deck Refurbishing",
      "description": "It goes without saying that your pool was a major investment. The last thing you want is to see signs of cracks and fading. As Riverside’s top experts in pool decks and pool deck resurfacing, allow us to show you the options you have readily available when your pool deck starts to age.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69496,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-01-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 135,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2415,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5169,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95748642-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jan 12, 2020",
      "subcategory": "Swimming Pool Deck",
      "request_types": "",
      "visitcount": 190
   },
   "visits": {
      "storefront": 190,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are a professional concrete resurfacing company that focuses on pool deck resurfacing. If your pool deck is old or damaged, then donu2019t hesitate to give us a call today!",
      "service1": "STAMPED CONCRETE POOL DECK",
      "service2": "CONCRETE RESURFACING",
      "service3": "POOL DECK PAVERS",
      "service4": "POOL DECK REPAIR",
      "service5": "POOL DECK RESURFACING",
      "service6": "POOL DECK COATING",
      "service7": "DECKING",
      "submit_dt": "2020-01-12 16:01:48"
   },
   "location": {
      "uuid": "95748642-56da-11ed-b77c-b66e99367f32",
      "link_id": 318303,
      "account_id": 69496,
      "company": "Pool Deck Refurbishing",
      "sid": 68,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2415",
      "zip": "",
      "address": "",
      "phone": "",
      "fax": null,
      "email": "stephaniewilson171115@gmail.com",
      "name": "Pool Deck Refurbishing",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Riverside",
      "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": ""
}