Dr. David D. Hayes Family Dentistry

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329626,
      "site_id": 20,
      "cat_id": 30,
      "priority": 2,
      "url": "http://drdavidhayes.com/",
      "title": "Dr. David D. Hayes Family Dentistry",
      "description": "Dr. David Hayes and his staff provide quality, compassionate care for all of your oral health needs. Our practice was established in 2000 and today we still have the same mission  to ensure that every patient leaves our office with a bright, healthy smile. Our staff is here to listen to your concerns and explain options and procedures to make you comfortable with your dental care choices. Convenient and extended hours are available, and most insurance plans are accepted.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80441,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 31,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 17689,
      "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": 6293,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "82672bc9-f250-11ee-8344-b66e99367f32",
      "subdate": "Apr 04, 2024",
      "subcategory": "Dentists",
      "request_types": "",
      "visitcount": 76
   },
   "visits": {
      "storefront": 76,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Dr. David Hayes and his staff provide quality, compassionate care for all of your oral health needs. Our practice was established in 2000 and today we still have the same mission " to ensure that every patient leaves our office with a bright, healthy smile. Our staff is here to listen to your concerns and explain options and procedures to make you comfortable with your dental care choices. Convenient and extended hours are available, and most insurance plans are accepted.",
      "service1": "Teeth Whitening",
      "service2": "Restorative Care",
      "service3": "Preventative Cleaning",
      "service4": "Pediatric Dentistry",
      "service5": "Oral Screening",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-04 06:56:50"
   },
   "location": {
      "uuid": "82672bc9-f250-11ee-8344-b66e99367f32",
      "link_id": 329626,
      "account_id": 80441,
      "company": "Dr. David D. Hayes Family Dentistry",
      "sid": 20,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "17689",
      "zip": "43081",
      "address": "483 Lazelle Road",
      "phone": "+1 614-781-1288",
      "fax": null,
      "email": "davidhayesfd@mail-burst.com",
      "name": "Dr. David D. Hayes Family Dentistry",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.1352849",
      "lon": "-82.9937589",
      "cityname": "Westerville",
      "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": ""
}