Tri-County Medical Clinic

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313337,
      "site_id": 19,
      "cat_id": 71,
      "priority": 2,
      "url": "https://tricountymedicalclinic.com/",
      "title": "Tri-County Medical Clinic",
      "description": "Tri-County Medical Clinic is a family medicine practice in Sterling Heights, Michigan. Tri-County also has two subsidiaries, Dequindre Urgent Care Center and Troy Laser Center (cosmetic services).",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 64566,
      "approve_dt": "2018-03-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-05-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 844,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10695,
      "ltop": "",
      "facebook": "https://www.facebook.com/TriCountyMedicalClinicPC/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/TriCountyMedMI",
      "googleplus": "https://plus.google.com/101806911096071800473/posts",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 789,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "955aa451-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 26, 2017",
      "subcategory": "Family Practice",
      "request_types": "",
      "visitcount": 1124
   },
   "visits": {
      "storefront": 1124,
      "articles": 0,
      "videos": 0,
      "reviews": 14,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Tri-County Medical Clinic is a Sterling Heights, Michigan-based family medicine practice that has been serving the local community for over 30 years. We are dedicated to providing comprehensive healthcare for the entire family, at every stage of life. Our family medical center is home to the best board-certified family doctors with a special expertise in geriatric medicine. Tri-County Medical Clinic has two subsidiaries – Dequindre After Hours Urgent Care Center and Troy Laser Center – both of which provide additional services to meet the needs of our patients, including walk-in urgent care services and various cosmetic treatments.",
      "service1": "Botox",
      "service2": " Dermal Fillers",
      "service3": " X-ray services",
      "service4": " Diagnostic Testing",
      "service5": " Geriatric Medicine",
      "service6": " Women's Health",
      "service7": " Men's Health",
      "submit_dt": "2017-05-26 13:47:45"
   },
   "location": {
      "uuid": "955aa451-56da-11ed-b77c-b66e99367f32",
      "link_id": 313337,
      "account_id": 64566,
      "company": "Tri-County Medical Clinic",
      "sid": 19,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10695",
      "zip": "48310",
      "address": "37450 Dequindre Road, Sterling Heights, MI",
      "phone": "",
      "fax": null,
      "email": "wolok.docero@gmail.com",
      "name": "Tri-County Medical Clinic",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.567173",
      "lon": "-83.087865",
      "cityname": "Sterling Heights",
      "statename": "Michigan"
   },
   "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": ""
}