Regional Hand Center

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 343628,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://regionalhand.com",
      "title": "Regional Hand Center",
      "description": "The Central Valley's premier Team of Orthopedic Hand Specialists and also Surgeons Whether you are planning a procedure or interested in options for treatment, the professional and also caring Regional Hand Center team makes it easy to discover the answers you need. Conditions we treat: Carpal Tunnel Syndrome, Tennis Elbow, Sports Injuries of the hand and wrist, Fractures of the hand, wrist and forearm, Trigger finger, and also Tendon Injuries. For an appointment or answers to your questions, call (599) 322- HAND.\r\n\r\nMore Info Visit Us https://regionalhand.com/",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94323,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 0,
      "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": 290,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4c7d6ec6-fe6d-11ef-a909-b66e99367f32",
      "subdate": "Mar 11, 2025",
      "subcategory": "Medical Specialists",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "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": "2025-03-11 11:38:06"
   },
   "location": {
      "uuid": "4c7d6ec6-fe6d-11ef-a909-b66e99367f32",
      "link_id": 343628,
      "account_id": 94323,
      "company": "",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "0",
      "zip": "93291",
      "address": "720 W Main St Ste A Visalia CA",
      "phone": "5593226600",
      "fax": null,
      "email": "regionalhandvis@outlook.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "36.3303947",
      "lon": "-119.2994842",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}