Halls Advanced Dentistry

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348561,
      "site_id": 20,
      "cat_id": 30,
      "priority": 2,
      "url": "https://advanceddentistrytulsa.com/",
      "title": "Halls Advanced Dentistry",
      "description": "Comprehensive Dental Care for Tulsa Families\nHalls Advanced Dentistry provides exceptional dental care to Tulsa families and neighboring communities, offering everything from routine preventive services to advanced restorative treatments. Led by Dr. Brandon Halls, our skilled dental team is committed to delivering high-quality care in a comfortable, hassle-free environment. We focus on building lasting relationships with our patients while ensuring they receive the comprehensive dental services they deserve for optimal oral health.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99256,
      "approve_dt": "2025-07-11T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 18376,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1d1d64e0-4750-11f0-a909-b66e99367f32",
      "subdate": "Jun 12, 2025",
      "subcategory": "Dentists",
      "request_types": "",
      "visitcount": 80
   },
   "visits": {
      "storefront": 80,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 30,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Halls Advanced Dentistry, Dr. Brandon Halls and our friendly team combine the latest dental technology with a personal touch. We're dedicated to making you feel comfortable and cared for, while providing top-quality treatment tailored just for you. Your smile and well-being are always our priority.",
      "service1": "routine dental exams and cleanings",
      "service2": " comprehensive dental implants",
      "service3": " restorative dentistry and fillings",
      "service4": " cosmetic dentistry treatments",
      "service5": " preventive care and oral health education",
      "service6": " emergency dental services",
      "service7": " advanced dental procedures and specialized treatments",
      "submit_dt": "2025-06-12 05:43:06"
   },
   "location": {
      "uuid": "1d1d64e0-4750-11f0-a909-b66e99367f32",
      "link_id": 348561,
      "account_id": 99256,
      "company": "Halls Advanced Dentistry",
      "sid": 20,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "18376",
      "zip": "74133",
      "address": "6911 South 66th East Avenue, 300",
      "phone": "+1 918-477-7677",
      "fax": null,
      "email": "advanceddentistrytulsa@brite-post.com",
      "name": "Halls Advanced Dentistry",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "36.0630559",
      "lon": "-95.9025431",
      "cityname": "Tulsa",
      "statename": "Oklahoma"
   },
   "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": ""
}