For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 18 results

Filter By

Current Filters

  1. Has Identifier for GMC No Remove This Item
  2. Brand Name Core Remove This Item
Clear All

Category

  1. Skateboards5item
  2. Scooters14item
  3. Longboards2item
  4. Protection2item
  5. Bags1 item
  6. Brands16item
  7. Bundles14item
  8. New Arrivals4item
  9. SkateHut Sale8item
  10. Summer Sale3item

Variant Width

  1. 4.5"2item

Channel Filters

  1. Allowed14item
  2. Excluded4item

Stock At Supplier

  1. No18item

Cross Sell Type

  1. Colour4item

Reporting Status

  1. Live18item

In Magento

  1. Yes2item
  2. No16item

Use In Google Feed

  1. Yes18item
  2. No2item

B-Stock

  1. No18item

Own Brand?

  1. No18item

Channels Ready

  1. Yes17item
  2. No1 item

Country Of Origin

  1. China3item

Order In Active

  1. No13item

Order In Product

  1. No16item

Export

  1. No13item

Export Common

  1. No13item

Supplier Name

  1. Core18item

Best Suited to

  1. Park3item

Scooter Type

  1. Stunt Scooter3item

Skateboard Deck Randomiser

  1. No2item

Is for Gifting?

  1. Yes1 item
  2. No17item

Scooter Bar Height

  1. 550mm2item

Scooter Height

  1. 810mm3item

Skill Level

  1. Beginner3item

Product Type Basic

  1. Ramps3item
  2. Pad Sets2item
  3. Scooter Accessories1 item
  4. Scooter Decks2item
  5. Scooter Headsets5item
  6. Scooters - Stunt Scooters3item
  7. Skateboard Bearings2item

Is Simple Product

  1. Yes16item
  2. No2item

Department

  1. General Hardware3item
  2. Protection2item
  3. Scooters11item
  4. Skateboards2item

Price

  1. £0.00 - £24.999item
  2. £25.00 - £49.997item
  3. £50.00 and above2item

Product Type

  1. General Hardware > Ramps3item
  2. Protection > Pad Sets2item
  3. Scooters > Accessories1 item
  4. Scooters > Decks2item
  5. Scooters > Headsets5item
  6. Skateboards > Bearings2item
  7. Scooters > Stunt Completes3item

Main Colour

  1. Black8item
  2. Blue4item
  3. Neochrome1 item
  4. Pink2item
  5. Red1 item
  6. Silver1 item
  7. White1 item

Deck Type

  1. Integrated7item

Scooter Headset Type

  1. Integrated5item

Pad Size

  1. Extra Extra Small2item
  2. Extra Small2item
  3. Small2item

Scooter Deck Type

  1. Integrated 120mm2item

Vegan

  1. No18item

Age

  1. 6 to 83item
  2. 8 to 123item

Scooter Height

  1. 68cm - 85cm3item
  2. 80cm - 90cm3item
  3. 69cm - 89cm2item

Deck Length

  1. 19"1 item
  2. 17"3item
  3. 18.5"1 item

Deck Width

  1. 4"3item
  2. 4.5"2item

Scooter Bar Shape

  1. Y - Shape3item

Scooter Rider Height Range

  1. 125cm - 150cm3item
  2. 150cm - 170cm3item

Abec Rating

  1. ABEC 111 item
  2. Skate Rated1 item

Material Primary

  1. Aluminium1 item

Builder Part

  1. Yes9item
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' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.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 (408460, 408472, 401524, 401542, 407005, 407008, 407011, 407668, 407671, 407674, 407677, 407680, 401311, 409016, 411389, 401314, 409026, 385526)) ORDER BY FIELD(e.entity_id,408460,408472,401524,401542,407005,407008,407011,407668,407671,407674,407677,407680,401311,409016,411389,401314,409026,385526)

18 Items