A Reason to Smile

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317326,
      "site_id": 20,
      "cat_id": 30,
      "priority": 2,
      "url": "https://www.r2smile.com",
      "title": "A Reason to Smile",
      "description": "Whether you need a simple cleaning or an extensive makeover, at A Reason to Smile you will get the highest level of care and the attention you deserve.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68524,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 187,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 1026,
      "ltop": "",
      "facebook": "https://www.facebook.com/R2Smile/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/ReasontoSmileAZ",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/r2smile3/",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 952,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956f2c8d-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 21, 2019",
      "subcategory": "Dental Hygienists",
      "request_types": "",
      "visitcount": 292
   },
   "visits": {
      "storefront": 292,
      "articles": 0,
      "videos": 0,
      "reviews": 18,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At A Reason to Smile, we truly care about our patients.  Itu2019s essential that all patients understand why a procedure is going to be performed.  We take the time to communicate so our patients understand their issue, its consequence and the best solution so expectations align with the prescribed treatment.",
      "service1": "Pediatric Dentistry",
      "service2": "dental implants",
      "service3": "Invisalign braces",
      "service4": "Cosmetic Dentistry",
      "service5": "General Dentistry",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-06-21 12:34:16"
   },
   "location": {
      "uuid": "956f2c8d-56da-11ed-b77c-b66e99367f32",
      "link_id": 317326,
      "account_id": 68524,
      "company": "A Reason to Smile",
      "sid": 20,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1026",
      "zip": "85254",
      "address": "6945 E Sahuaro Dr Ste A-3",
      "phone": "(480) 951-3333",
      "fax": null,
      "email": "r2smile3@gmail.com",
      "name": "A Reason to Smile",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.58393",
      "lon": "-111.9318018",
      "cityname": "Scottsdale",
      "statename": "Arizona"
   },
   "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": ""
}