GBP £

For Sales & Advice Call Us on 0121 501 1111

Search

Menu
Settings
  • AUD A$
  • CAD CA$
  • USD $

    • HOVERBOARDS

    Get involved in the latest trends and swerve into our range of hoverboards and self-balancing scooters. Skate hoverboards have become all the rage for celebrities, with many taking to Instagram to show off their skills and the occasional fail. They’re fun for everyone as allow you to spin 360-degrees on the spot or zoom up and down the path. Kids and adults alike. with two wheels, two motors and a double balancing system to help keep you upright, our cheap hoverboards for sale couldn’t be safer or easier to control, without breaking the bank. Shop top brands including: Oxboard, Y-Volution, Segbo and more. Explore the full range online today and enjoy free delivery on orders over £40.

    Loading...
    SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (110850, 110825, 110826, 110828, 110830, 110833, 110834, 110835))) AND (e.created_in <= '1641570900') AND (e.updated_in > '1641570900') ORDER BY FIELD(e.entity_id,110850,110825,110826,110828,110830,110833,110834,110835)