Mayfair Dental Center

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326573,
      "site_id": 20,
      "cat_id": 30,
      "priority": 2,
      "url": "https://www.mayfairdentalcenter.com/",
      "title": "Mayfair Dental Center",
      "description": "When you visit Mayfair Dental Center in Philadelphia, PA, for the first time, we''ll begin by conducting an extensive oral exam. Using technology like x-rays, our dentist looks at the overall condition of your teeth, gums, and jawbones to determine which of our services is right for you. Our team will then outline our recommended services in your personalized treatment plan. We''ll also take this time to answer any questions you may have about our offerings.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77444,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-11-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 39,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19705,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9b38c6de-8d01-11ee-8344-b66e99367f32",
      "subdate": "Nov 27, 2023",
      "subcategory": "Dentists",
      "request_types": "",
      "visitcount": 73
   },
   "visits": {
      "storefront": 73,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-11-27 08:47:33"
   },
   "location": {
      "uuid": "9b38c6de-8d01-11ee-8344-b66e99367f32",
      "link_id": 326573,
      "account_id": 77444,
      "company": "Mayfair Dental Center",
      "sid": 20,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19705",
      "zip": "19135",
      "address": "6412 Frankford Avenue, Suite 10",
      "phone": "",
      "fax": null,
      "email": "olegamayev@mail-burst.com",
      "name": "Mayfair Dental Center",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.0300349",
      "lon": "-75.057738",
      "cityname": "Philadelphia",
      "statename": "Pennsylvania"
   },
   "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": ""
}

all our featured social media