J&L Pacific Lock & Key

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315767,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://jandlpacificlockandkey.com",
      "title": "J&L Pacific Lock & Key",
      "description": "Email: contact@jandlpacificlockandkey.com",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66979,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-09-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 179,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18610,
      "ltop": "",
      "facebook": "https://www.facebook.com/JLPacificLockKey",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/JLPacficLockKey",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "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": 5872,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9566ad23-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 14, 2018",
      "subcategory": "Locksmiths",
      "request_types": "",
      "visitcount": 239
   },
   "visits": {
      "storefront": 239,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "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": "J&L Pacific Lock and Key is a family owned and handled locksmith business in Medford, OR. We offer locksmith services for homes, businesses and automotive at our store throughout business hours and mobile services are given 24 hour a day seven days a week. Clients complete satisfaction is our number one goal.\r
J&L Pacific Lock&Key is a completely licensed locksmith service provider. We are permitted to do work in the state of Oregon, and we have been acknowledged by the ALOA (Associated Locksmiths of America).\r
We are also registered with the City of Medford, Oregon Secretary of State, and also the Oregon Construction Contractors Board.",
      "service1": "Locksmith",
      "service2": "Locksmith Medford Oregon",
      "service3": "24-hour locksmith",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-09-14 05:38:01"
   },
   "location": {
      "uuid": "9566ad23-56da-11ed-b77c-b66e99367f32",
      "link_id": 315767,
      "account_id": 66979,
      "company": "J&L Pacific Lock & Key",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18610",
      "zip": "97504",
      "address": "628 Crater Lake Ave",
      "phone": "(541) 930-8363",
      "fax": null,
      "email": "jandlpacificlockandkeymedford@gmail.com",
      "name": "J&L Pacific Lock & Key",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.3354201",
      "lon": "-122.8614515",
      "cityname": "Medford",
      "statename": "Oregon"
   },
   "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": ""
}