For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 66 results

Filter By

Current Filters

  1. Order In Active No Remove This Item
  2. Age 10 + Remove This Item
Clear All

Category

  1. Bundles54item
  2. New Arrivals7item
  3. SkateHut Sale42item
  4. Summer Sale42item

Foldable?

  1. No17item

Height Adjustable?

  1. No17item

Sales Name

  1. Price Match9item

Channel Filters

  1. Allowed60item
  2. Excluded6item

Stock At Supplier

  1. No66item

Cross Sell Type

  1. Colour52item

Reporting Status

  1. Live65item
  2. Discontinued1 item

In Magento

  1. Yes22item
  2. No44item

Use In Google Feed

  1. Yes66item

B-Stock

  1. No66item

Own Brand?

  1. No66item

Channels Ready

  1. Yes62item
  2. No4item

Purchaser

  1. Tony16item
  2. Rob2item

Country Of Origin

  1. China50item

Google Feed Margin Cat

  1. z13item
  2. z21 item
  3. z312item
  4. other6item

Order In Product

  1. No66item

Export

  1. No66item

Has Identifier for GMC

  1. Yes16item
  2. No50item

Export Common

  1. No66item

Supplier Name

  1. Centrano23item
  2. J&R23item
  3. Onecall7item
  4. Shiner7item
  5. RI Distribution6item

Best Suited to

  1. Park14item
  2. Street16item
  3. Hybrid15item

Scooter Type

  1. Adult/Commuter Scooter5item
  2. Kids Scooter16item
  3. Stunt Scooter49item
  4. Cruiser Scooter4item

Is for Gifting?

  1. No66item

Scooter Bar Height

  1. Adjustable17item
  2. 584mm1 item
  3. 620mm11item
  4. 622mm4item
  5. 635mm5item
  6. 650mm6item
  7. 660mm3item
  8. 685mm1 item
  9. 700mm2item

Scooter Height

  1. 850mm5item
  2. 855mm4item
  3. 865mm5item
  4. 870mm17item
  5. 880mm2item
  6. 900mm10item
  7. 920mm1 item
  8. 940mm1 item
  9. 945mm2item
  10. 950mm9item
  11. 960mm1 item
  12. 965mm2item
  13. 980mm1 item
  14. 1000mm4item
  15. 1015mm1 item

Skill Level

  1. Beginner2item
  2. Intermediate31item
  3. Pro18item

Product Type Basic

  1. Scooters - Commuter6item
  2. Scooters - Folding11item
  3. Scooters - Stunt Scooters49item

Is Simple Product

  1. Yes66item

Department

  1. Scooters66item

Price

  1. £25.00 - £49.9913item
  2. £50.00 - £74.994item
  3. £125.00 - £149.9914item
  4. £150.00 - £174.9913item
  5. £175.00 - £199.9917item
  6. £200.00 - £224.991 item
  7. £275.00 and above4item

Brand Name

  1. Addict Scootering7item
  2. Blunt Envy7item
  3. JD Bug13item
  4. Lucky Scooters2item
  5. MGP (Madd Gear Pro)10item
  6. Native4item
  7. North Scooters4item
  8. Root Industries7item
  9. Striker10item
  10. Tilt Scooters2item

Number Of Wheels

  1. 211item

Product Type

  1. Scooters > Commuter Completes6item
  2. Scooters > Folding Completes11item
  3. Scooters > Stunt Completes49item

Main Colour

  1. Black27item
  2. Blue5item
  3. Bronze1 item
  4. Brown1 item
  5. Gold3item
  6. Green2item
  7. Grey1 item
  8. Neochrome3item
  9. Pink1 item
  10. Purple3item
  11. Raw6item
  12. Red3item
  13. Silver4item
  14. Teal3item
  15. White2item
  16. Yellow1 item

Scooter Wheel Size

  1. 100mm6item
  2. 120mm7item
  3. 200mm4item

Gender

  1. Unisex11item

Vegan

  1. No66item

Scooter Height

  1. 50cm - 75cm5item
  2. 68cm - 85cm11item
  3. 80cm - 90cm49item
  4. 90cm and over32item
  5. 69cm - 89cm24item

Bar Height Range

  1. 700mm and over1 item

Deck Length

  1. 19.5"12item
  2. 20"2item
  3. 20.5"8item
  4. 21"4item
  5. 21.5"1 item
  6. 22"3item
  7. 22.5"2item
  8. 23"1 item
  9. 19.75"8item

Deck Width

  1. 4.5"10item
  2. 5.2"4item
  3. 5.25"4item
  4. 5.5"9item
  5. 5.8"1 item
  6. 5.9"1 item
  7. 6"2item
  8. 6.25"2item
  9. 6.5"1 item

Scooter Bar Shape

  1. T - Shape20item
  2. Y - Shape19item

Age Group

  1. Kids11item

Scooter Rider Height Range

  1. 90cm - 125cm5item
  2. 125cm - 150cm28item
  3. 150cm - 170cm49item
  4. 170cm and over33item
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 (411330, 411331, 409243, 152973, 395027, 408088, 98851, 98852, 98853, 98854, 99167, 99168, 397964, 397967, 397970, 407260, 136512, 408241, 408244, 408247, 408250, 397973, 160004, 410377)) ORDER BY FIELD(e.entity_id,411330,411331,409243,152973,395027,408088,98851,98852,98853,98854,99167,99168,397964,397967,397970,407260,136512,408241,408244,408247,408250,397973,160004,410377)

Showing 23 out of 66

Page