Best Cosmetic Dentistry in Hanford

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310585,
      "site_id": 20,
      "cat_id": 30,
      "priority": 0,
      "url": "http://www.hanfordfamilydentistry.com",
      "title": "Best Cosmetic Dentistry in Hanford",
      "description": "Hanford Dentist, Cosmetic Dentistry Hanford, Dental Veneers Hanford, Dentist Hanford: Dr. Raiyani and his friendly, knowledgeable team takes pride in delivering high quality general and cosmetic dental care in a gentle manner.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61820,
      "approve_dt": "2015-09-30T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1343,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2007,
      "ltop": "",
      "facebook": "https://www.facebook.com/HanfordFamilyDental",
      "tiktok": "",
      "linkedin": "",
      "twitter": "https://twitter.com/DrN_Raiyani",
      "googleplus": "https://plus.google.com/112517526378545423406/about?hl=en",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 1,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 1930,
      "subcat_id": 942,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954e2acd-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 30, 2015",
      "subcategory": "Cosmetic Dentistry",
      "request_types": "",
      "visitcount": 1549
   },
   "visits": {
      "storefront": 1549,
      "articles": 0,
      "videos": 0,
      "reviews": 24,
      "coupons": 0,
      "products": 91,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Patients of Hanford Family Dental Center range in age from five years old all the way into their eighties. Each one of them has unique dental needs determined by age, lifestyle, heredity, preferences, and more. In our years of experience, we have learned that patient experience is everything!\nWhether we are treating a child patient or an adult who has endured unpleasant dental visits in the past, we are gentle and understanding, focused on creating a positive dental experience.\nWe would love to help you avoid cavities, gum disease, and other problems with exceptional care. If dental problems develop, our expertise in restoration can repair damage in the most beautiful way, achieving results that last for years.\nWe know that there are many people seeking quality dental care who are apprehensive about the experience they may have with a new dentist. The Hanford Family Dental Center team works hard to create a warm, relaxed atmosphere that is seen, heard, and felt from the moment patients enter our office.",
      "service1": "Root Canal Therapy",
      "service2": " Crowns and Bridges",
      "service3": " Teeth Whitening",
      "service4": " Gum Disease",
      "service5": " Veneers",
      "service6": " Bonding",
      "service7": " Dentures ",
      "submit_dt": "2015-09-30 15:22:14"
   },
   "location": {
      "uuid": "954e2acd-56da-11ed-b77c-b66e99367f32",
      "link_id": 310585,
      "account_id": 61820,
      "company": "Hanford Family Dental Center",
      "sid": 20,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2007",
      "zip": "93230",
      "address": "425 West 7th Street, Suite 104, Hanford, CA",
      "phone": "559-530-8080",
      "fax": "",
      "email": "raiyani@ekwa.com",
      "name": "Best Cosmetic Dentistry in Hanford",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "36.3253959",
      "lon": "-119.6514366",
      "cityname": "Hanford",
      "statename": "California"
   },
   "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": 1
      },
      {
         "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": ""
}