Davis Roofing and Restoration LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330519,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://davisroofingohio.com/?utm_campaign=gmb",
      "title": "Davis Roofing and Restoration LLC",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81322,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 25,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 17473,
      "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": 5047,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a9414a26-0ae4-11ef-8344-b66e99367f32",
      "subdate": "May 05, 2024",
      "subcategory": "Roofing Contractor",
      "request_types": "",
      "visitcount": 74
   },
   "visits": {
      "storefront": 74,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Davis Roofing in Powell, Ohio is a licensed, bonded and fully insured roofing, siding and gutter contractor that provides premier service and provides the best service at an affordable cost, AND, that will be with you every step of the way in your insurance claim. Whether you are looking to install a new roof, improve the appearance of your roof, or need roof repairs or replacement, contact Davis Roofing. We are the experts you need to get the job done the right way, the first time around.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-05 13:37:48"
   },
   "location": {
      "uuid": "a9414a26-0ae4-11ef-8344-b66e99367f32",
      "link_id": 330519,
      "account_id": 81322,
      "company": "Davis Roofing and Restoration LLC",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "17473",
      "zip": "43065",
      "address": "453 Village Park Dr",
      "phone": "(614) 810-8977",
      "fax": null,
      "email": "daviroofarestopoh@brite-email.com",
      "name": "Davis Roofing and Restoration LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.1673395",
      "lon": "-83.0808425",
      "cityname": "Powell",
      "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": ""
}