Clarkes 247

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 324854,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.clarkes247.co.uk/",
      "title": "Clarkes 247",
      "description": "Welcome to Clarkes, your one stop shop for professional painting, decorating and reactive maintenance services. Offering a wide range of services and specialist trades, we provide everything you could need under one roof. Whether you need an emergency plumber or gas engineer, or require efficient roof repairs or electrical repairs, we are on hand to deal with your issue. Our services cover homes as well as offices, factories, schools, shops, letting agents and apartment buildings.We provide a prompt and efficient service across London and anywhere within the M25, including Notting Hill and Swiss Cottage. We also cover Oxford, Brentwood, Guildford, High Wycombe and Waltham Abbey.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75843,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-05-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 265,
      "countrycode": "UK",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 476,
      "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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4e67b83e-f3cb-11ed-b5b4-b66e99367f32",
      "subdate": "May 16, 2023",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 28
   },
   "visits": {
      "storefront": 28,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-05-16 09:23:23"
   },
   "location": {
      "uuid": "4e67b83e-f3cb-11ed-b5b4-b66e99367f32",
      "link_id": 324854,
      "account_id": 75843,
      "company": "Clarkes 247",
      "sid": 6,
      "country": 265,
      "countrycode": "UK",
      "state": 0,
      "city": "476",
      "zip": "NW1 5LT",
      "address": "mazno27@mhmazno.com",
      "phone": "0207 247 365 0",
      "fax": null,
      "email": "mazno27@mhmazno.com",
      "name": "Clarkes 247",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "London",
      "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": ""
}