Agave Laser and Aesthetic Clinic

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317973,
      "site_id": 33,
      "cat_id": 3,
      "priority": 2,
      "url": "https://agavelaserclinic.com",
      "title": "Agave Laser and Aesthetic Clinic",
      "description": "Agave Laser and Aesthetic Clinic is a leading provider of laser and aesthetic care for men and women in the San Antonio, Texas area.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69167,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-11-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 171,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22482,
      "ltop": "",
      "facebook": "https://www.facebook.com/agavelaserclinic",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/agavelaserclinic/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 1965,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9572acd6-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 07, 2019",
      "subcategory": "Laser Hair Removal",
      "request_types": "",
      "visitcount": 248
   },
   "visits": {
      "storefront": 248,
      "articles": 0,
      "videos": 0,
      "reviews": 12,
      "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": "Agave Laser and Aesthetic Clinic is a provider of medical aesthetic services in San Antonio, TX and includes laser hair removal, body shaping with non surgical fat reduction technology, fat loss diet plan, skin care for reducing signs of aging and sun damage, tattoo removal, hormone replacement therapy, injectables such as Botox.\r
The clinic utilizes the onsite medical director Caroline Hernandez, MD a well established Internal Medicine physician, Amber Ramos a certified laser technologist and, Rebeca Cruz a Medical Assistant and Certified Laser Technologist and Grace Co, Practice Administrator and Certified Laser Technologist. Our team has been working together 10 years or more and we are committed to helping our clients achieve the best results possible. The technology we utilize is exciting, produces definite results and is well tolerated.",
      "service1": "Laser Treatments",
      "service2": "Medical Aesthetic Services",
      "service3": "Pelleve Skin Tightening",
      "service4": "Picosure Skin Revitalization",
      "service5": "Laser hair removal",
      "service6": "Trusculpt 3D",
      "service7": "",
      "submit_dt": "2019-11-07 08:54:47"
   },
   "location": {
      "uuid": "9572acd6-56da-11ed-b77c-b66e99367f32",
      "link_id": 317973,
      "account_id": 69167,
      "company": "Agave Laser and Aesthetic Clinic",
      "sid": 33,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22482",
      "zip": "78251",
      "address": "1911 Rogers Road",
      "phone": "210-595-3500",
      "fax": null,
      "email": "agavelaserclinictx@gmail.com",
      "name": "Agave Laser and Aesthetic Clinic",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.4534218",
      "lon": "-98.6827944",
      "cityname": "San Antonio",
      "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": ""
}