John Mee Vac-Ex Hire

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332639,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.vac-ex.co.uk/",
      "title": "John Mee Vac-Ex Hire",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83418,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 14,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 478,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 6285,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f6f24bff-3ccf-11ef-8344-b66e99367f32",
      "subdate": "Jul 08, 2024",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 48
   },
   "visits": {
      "storefront": 48,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "John Mee founded John Mee Construction Limited in 1993 to carry out civil engineering work including deep drainage and tunnelling work. In 2005 the company won an award for a Sheffield city centre contract, which specified hand-dig only, due to the site being heavily congested with underground services. John Mee decided to invest in his first vacuum excavator, the UKs first, to complete this job successfully, without any strikes' on services.",
      "service1": "Vac Ex",
      "service2": "Vacuum Excavation",
      "service3": "Suction Excavation",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-08 02:15:37"
   },
   "location": {
      "uuid": "f6f24bff-3ccf-11ef-8344-b66e99367f32",
      "link_id": 332639,
      "account_id": 83418,
      "company": " ",
      "sid": 76,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "478",
      "zip": "DN3 3FD",
      "address": "Unit 2, Derbyshire Court, West Moor Park",
      "phone": "01302 366900",
      "fax": null,
      "email": "johnmeevacexh@brite-post.com",
      "name": " ",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "53.381129",
      "lon": "-1.470085",
      "cityname": "Sheffield",
      "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": ""
}