Pop-A-Lock of St Charles County

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 316082,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://popalockstcharles.com/",
      "title": "Pop-A-Lock of St Charles County",
      "description": "Pop-A-Lock – for 24-Hour Locksmith services in St. Charles MO. We specialize in residential & commercial locksmith and car door unlocking.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 67286,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-11-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 115,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 25,
      "city_id": 12749,
      "ltop": "",
      "facebook": "https://www.facebook.com/PopALockofStLouis",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://www.google.com/maps/place/Pop-A-Lock+of+St+Charles+County/@38.780053,-90.482953,9z/data=!4m5!3m4!1s0x0:0x1721f03f33bd1e32!8m2!3d38.780053!4d-90.482953",
      "youtube_channel": "https://www.youtube.com/user/PopALockofStLouis/",
      "youtube": "https://www.youtube.com/user/PopALockofStLouis/",
      "youtube_title": null,
      "pinterest": "",
      "yelp": " ",
      "foursquare": " ",
      "instagram": " ",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 6603,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95687524-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 08, 2018",
      "subcategory": "Locksmith",
      "request_types": "",
      "visitcount": 140
   },
   "visits": {
      "storefront": 140,
      "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": "At Pop-A-Lock, we are always striving to stay on top of the newest technology. We are specialized in providing a professional locksmith services to customers throughout St Charles County and have built our business around a commitment to quality customer service, reliability and a respectful approach to our work. \r
\r
From residential and commercial hardware to the latest in automotive technology, we do it all. Our locksmiths are experienced, trained, bonded and insured, assuring you top-notch service from a friendly person. We use the latest equipment, and all our work is guaranteed. We stock all major brands of locks and security systems and can source any other products that you need. Whether it is residential, commercial or automotive, we can handle all challenges. Visit https://popalockstcharles.com/ for more details.",
      "service1": "Commercial Locksmith Services",
      "service2": "Automotive Locksmith Services",
      "service3": "Access Control Systems",
      "service4": "Key Control Systems",
      "service5": "Lock Re-Keying",
      "service6": "Lock Replacement",
      "service7": "Locked Out",
      "submit_dt": "2018-11-08 10:39:02"
   },
   "location": {
      "uuid": "95687524-56da-11ed-b77c-b66e99367f32",
      "link_id": 316082,
      "account_id": 67286,
      "company": "Pop-A-Lock of St Charles County",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12749",
      "zip": "63301",
      "address": "222 S. 2nd Street Suite #111",
      "phone": "636-536-0044",
      "fax": null,
      "email": "popalockstcharles@gmail.com",
      "name": "Pop-A-Lock of St Charles County",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.2538382",
      "lon": "-85.7523246",
      "cityname": "St. Charles",
      "statename": "Missouri"
   },
   "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": ""
}