Hyjo

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345551,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://hyjo.co.uk",
      "title": "Hyjo",
      "description": "Hyjo is London's leading interior gardening professional, offering a variety of high-quality products, skilled guidance, and innovative solutions for growers of all levels. Established in 2003 and based in North London, we give whatever you need for successful interior expanding, consisting of expand tents, hydroponic systems, expand lights, ventilation, nutrients, and plant media. Our knowledgeable team is passionate regarding helping customers maximise their yields while minimising dangers. Whether you're a novice or a professional, Hyjo is your relied on partner for accomplishing exceptional outcomes.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96246,
      "approve_dt": "2025-10-03T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 9,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "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": 288,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c995f968-1bfc-11f0-a909-b66e99367f32",
      "subdate": "Apr 18, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 53
   },
   "visits": {
      "storefront": 53,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 21,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hyjo is Britain's leading specialized indoor gardening centre based in London, offering comprehensive solutions for indoor horticulture enthusiasts. With extensive expertise serving growers from beginners to experts, Hyjo provides carefully selected hydroponic equipment, systems, and growing supplies alongside expert advice to maximize results and eliminate risks in UK indoor growing environments.",
      "service1": "hydroponic grow systems",
      "service2": " grow tent equipment",
      "service3": " indoor lighting solutions",
      "service4": " plant nutrients and additives",
      "service5": " growing media and substrates",
      "service6": " propagation to harvest equipment",
      "service7": " specialized growing consultation and advice",
      "submit_dt": "2025-04-18 02:28:17"
   },
   "location": {
      "uuid": "c995f968-1bfc-11f0-a909-b66e99367f32",
      "link_id": 345551,
      "account_id": 96246,
      "company": "Hyjo - Britain's Leading Specialized Indoor Gardening Centre ",
      "sid": 6,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "476",
      "zip": "N15 4RG",
      "address": "Unit 9, Rainbow Works 21 Markfield Road",
      "phone": "020 8808 4321",
      "fax": null,
      "email": "hyjolondon@gmail.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "51.5836157",
      "lon": "-0.0645756",
      "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": ""
}