Premier Concrete Coatings

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318766,
      "site_id": 23,
      "cat_id": 40,
      "priority": 2,
      "url": "https://www.pccofcolumbus.com/",
      "title": "Premier Concrete Coatings ",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69960,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-03-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 150,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 16903,
      "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": 1382,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95771bc1-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 20, 2020",
      "subcategory": "Flooring Contractor",
      "request_types": "",
      "visitcount": 254
   },
   "visits": {
      "storefront": 254,
      "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": "We specialize in epoxy flooring, polished concrete, and stained concrete flooring for commercial and residential clients in Central Ohio. We have the proper equipment, experienced personnel, and high quality materials to handle any flooring project. Our customer-oriented approach, ensures that every client is highly satisfied with their floor. We highly value Integrity so you will find one of our owners always on your job site. ",
      "service1": "Floor refinishing service",
      "service2": "Flooring Contractor",
      "service3": "Stained Concrete",
      "service4": "Polished Concrete",
      "service5": "Epoxy Flooring",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-03-20 06:29:25"
   },
   "location": {
      "uuid": "95771bc1-56da-11ed-b77c-b66e99367f32",
      "link_id": 318766,
      "account_id": 69960,
      "company": "Premier Concrete Coatings ",
      "sid": 23,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "16903",
      "zip": "43213",
      "address": "5752 Westbourne Avenue",
      "phone": "(614) 918-7345",
      "fax": null,
      "email": "pccofcolumbusoh@gmail.com",
      "name": "Premier Concrete Coatings ",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.9846583",
      "lon": "-82.8460555",
      "cityname": "Columbus",
      "statename": "Ohio"
   },
   "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": ""
}