Kaysar Oilfield Services Ltd.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309668,
      "site_id": 6,
      "cat_id": 39,
      "priority": 0,
      "url": "http://www.kaysaroilfield.com/",
      "title": "Kaysar Oilfield Services Ltd.",
      "description": "Kaysar Oilfield Services Ltd. is well known name in Grande Prairie to fulfill oilfield equipment needs. We provide 3-phase generators, light towers, light tower fuel skid combo unit rentals and more on reasonable rent.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60904,
      "approve_dt": "2016-01-07T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-06-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 3,
      "clickcount": 975,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 155,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 267,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95492cf5-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 08, 2015",
      "subcategory": "Equipment Rentals",
      "request_types": "",
      "visitcount": 1133
   },
   "visits": {
      "storefront": 1133,
      "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": "Kaysar Oilfield Ltd was founded in 2006. We started with only one Light tower and through hard work and perseverance established ourselves in to a reputable company.\n\nToday we are a striving company that delivers top notch service and a wide variety of rental equipment. The retuning customers appreciate that our values have not changed from the beginning.\n\nNo matter what the years bring and how the oilfield progresses we will always put our costumers first.",
      "service1": "Oilfield Supplies",
      "service2": " Oilfield Rental Equipment",
      "service3": " Office Trailers",
      "service4": " Dispose of all garbage from unit",
      "service5": " Delivery of all equipment",
      "service6": " 24 hour hauling",
      "service7": " 2-ton picker operations",
      "submit_dt": "2015-06-08 12:46:34"
   },
   "location": {
      "uuid": "95492cf5-56da-11ed-b77c-b66e99367f32",
      "link_id": 309668,
      "account_id": 60904,
      "company": "Kaysar Oilfield Services Ltd.",
      "sid": 6,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "155",
      "zip": "T0H 0W0",
      "address": "10601, 82 Avenue, 105",
      "phone": "",
      "fax": "",
      "email": "rental.equipment@hotmail.com",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "55.241786",
      "lon": "-118.813563",
      "cityname": "Edmonton",
      "statename": ""
   },
   "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": ""
}