Best Home Improvement Contractor UK

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337070,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://consumer-advisory.co.uk/",
      "title": "Best Home Improvement Contractor UK",
      "description": "Consumer Advisorytakes away the guess work in who totrust for your home improvements. Our dedicated team are some of the mostexperienced personnelin the field of Conservatory roof tiling and insulation and withover 30 years'' experience they know exactly who you should use and more importantly who you should not.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87801,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "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": 6625,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "113706cf-8f96-11ef-ab46-b66e99367f32",
      "subdate": "Oct 21, 2024",
      "subcategory": "HVAC",
      "request_types": "",
      "visitcount": 67
   },
   "visits": {
      "storefront": 67,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "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": "2024-10-21 10:20:16"
   },
   "location": {
      "uuid": "113706cf-8f96-11ef-ab46-b66e99367f32",
      "link_id": 337070,
      "account_id": 87801,
      "company": "Best Home Improvement Contractor UK",
      "sid": 76,
      "country": 265,
      "countrycode": "UK",
      "state": 0,
      "city": "476",
      "zip": "WC2H9JQ",
      "address": "71-75 Shelton StreetConvent GardenLondonWC2H9JQ",
      "phone": "01622 92 53 03",
      "fax": null,
      "email": "consumeradvisery@gmail.com",
      "name": "Best Home Improvement Contractor UK",
      "status": "",
      "start_dt": null,
      "end_dt": null,
      "lat": "51.5146943",
      "lon": "-0.1235069",
      "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": ""
}