Ricardo C. Guillen, DDS PLLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315435,
      "site_id": 20,
      "cat_id": 30,
      "priority": 2,
      "url": "https://www.guillendds.com",
      "title": "Ricardo C. Guillen, DDS PLLC",
      "description": "Dr. Guillen and his entire dental team put our patients first, offering comprehensive dental treatments, advanced technology, and affordable financing options in a relaxing, welcoming environment.\r\n\r\nIt is essential to have dental technology and tools that are up to date. Dr. Guillen proudly uses the latest technology in dental care to ensure that every diagnosis is accurate and every dental treatment is necessary.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66652,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-07-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 131,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22354,
      "ltop": "",
      "facebook": "https://www.facebook.com/Ricardo-C-Guillen-DDS-PLLC-651126775001878/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/ricardo-c-guillen-dds-pllc",
      "twitter": "https://twitter.com/GUILLENDDS",
      "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": 949,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "94b49e4e-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 08, 2018",
      "subcategory": "Dental Cleanings",
      "request_types": "",
      "visitcount": 153
   },
   "visits": {
      "storefront": 153,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Whether you're a new or current patient, in most cases, Dr. Guillen can offer a same-day emergency dental appointment. Emergency dental care services can treat:\r\n\r\nu2713 Toothaches or tooth sensitivity\r\nu2713 Cracked or chipped teeth\r\nu2713 Lost or loose dental fillings\r\nu2713 Sore and inflamed gums\r\nu2713 Oral accidents resulting in missing teeth",
      "service1": "Porcelain veneers",
      "service2": "Teeth whitening",
      "service3": "Dental implant restoration",
      "service4": "Sedation dentistry",
      "service5": "Cosmetic dentistry",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-07-08 17:11:58"
   },
   "location": {
      "uuid": "94b49e4e-56da-11ed-b77c-b66e99367f32",
      "link_id": 315435,
      "account_id": 66652,
      "company": "Ricardo C. Guillen, DDS PLLC",
      "sid": 20,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22354",
      "zip": "78374",
      "address": "501 Moore Ave.",
      "phone": "(361) 643-7811",
      "fax": null,
      "email": "ricardoguillendds@gmail.com",
      "name": "Ricardo C. Guillen, DDS PLLC",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "27.8734718",
      "lon": "-97.3254338",
      "cityname": "Portland",
      "statename": "Texas"
   },
   "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": ""
}