For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 64 results

Filter By

Current Filters

  1. Export Common No Remove This Item
  2. Scooter Height 80cm - 90cm Remove This Item
Clear All

Category

  1. Bundles57item
  2. New Arrivals10item
  3. SkateHut Sale31item

Foldable?

  1. No11item

Height Adjustable?

  1. No11item

Sales Name

  1. Price Match11item
  2. Red Tier 23item

Scooter Compression Type

  1. IHC4item

Channel Filters

  1. Allowed52item
  2. Excluded9item
  3. Ebay Only3item

Stock At Supplier

  1. No62item

Cross Sell Type

  1. Colour52item

Reporting Status

  1. Live63item
  2. Discontinued1 item

In Magento

  1. Yes35item
  2. No29item

Use In Google Feed

  1. Yes64item

B-Stock

  1. No64item

Own Brand?

  1. No64item

Channels Ready

  1. Yes50item
  2. No14item

Purchaser

  1. Billy4item
  2. Tony20item
  3. Rob2item

Country Of Origin

  1. China39item

Google Feed Margin Cat

  1. z13item
  2. z24item
  3. z322item
  4. other6item

Order In Active

  1. No64item

Order In Product

  1. No64item

Export

  1. No64item

Has Identifier for GMC

  1. Yes24item
  2. No40item

Supplier Name

  1. Centrano14item
  2. Core2item
  3. Greenover3item
  4. J&R28item
  5. Onecall8item
  6. Shiner2item
  7. Stateside2item
  8. RI Distribution5item

Best Suited to

  1. Park19item
  2. Street5item
  3. Hybrid25item

Scooter Type

  1. Adult/Commuter Scooter1 item
  2. Kids Scooter10item
  3. Stunt Scooter53item

Is for Gifting?

  1. No64item

Scooter Bar Height

  1. Adjustable11item
  2. 550mm2item
  3. 570mm1 item
  4. 584mm6item
  5. 609mm6item
  6. 620mm9item
  7. 635mm5item
  8. 650mm5item
  9. 660mm1 item

Scooter Height

  1. 750mm1 item
  2. 800mm2item
  3. 810mm2item
  4. 815mm9item
  5. 825mm3item
  6. 830mm6item
  7. 850mm5item
  8. 855mm3item
  9. 865mm6item
  10. 870mm13item
  11. 880mm1 item
  12. 895mm1 item
  13. 900mm7item
  14. 950mm4item

Skill Level

  1. Beginner8item
  2. Intermediate39item
  3. Pro7item

Product Type Basic

  1. Scooters - Commuter2item
  2. Scooters - Folding9item
  3. Scooters - Stunt Scooters53item

Is Simple Product

  1. Yes64item

Department

  1. Scooters64item

Price

  1. £25.00 - £49.9913item
  2. £75.00 - £99.997item
  3. £100.00 - £124.999item
  4. £125.00 - £149.996item
  5. £150.00 - £174.9912item
  6. £175.00 - £199.9915item
  7. £225.00 and above2item

Brand Name

  1. Addict Scootering2item
  2. Blunt Envy8item
  3. Core2item
  4. Crisp Scooters3item
  5. JD Bug11item
  6. Lucky Scooters2item
  7. MGP (Madd Gear Pro)17item
  8. Native1 item
  9. Root Industries10item
  10. Slamm2item
  11. Striker6item

Number Of Wheels

  1. 210item

Product Type

  1. Scooters > Commuter Completes2item
  2. Scooters > Folding Completes9item
  3. Scooters > Stunt Completes53item

Main Colour

  1. Black28item
  2. Blue7item
  3. Bronze1 item
  4. Gold2item
  5. Green3item
  6. Multi1 item
  7. Neochrome4item
  8. Orange1 item
  9. Pink2item
  10. Purple1 item
  11. Raw2item
  12. Red4item
  13. Silver2item
  14. Teal3item
  15. White2item
  16. Yellow1 item

Scooter Wheel Size

  1. 100mm4item
  2. 120mm7item

Gender

  1. Unisex10item

Vegan

  1. No64item

Age

  1. 4 to 61 item
  2. 6 to 835item
  3. 8 to 1255item
  4. 10 +41item

Deck Length

  1. 19"3item
  2. 19.5"21item
  3. 20"1 item
  4. 20.5"5item
  5. 21"6item
  6. 19.75"4item
  7. 17"2item

Deck Width

  1. 4"2item
  2. 4.5"15item
  3. 4.8"5item
  4. 5.25"5item
  5. 5.5"11item

Scooter Bar Shape

  1. T - Shape14item
  2. Y - Shape26item

Age Group

  1. Kids10item

Scooter Rider Height Range

  1. 90cm - 125cm4item
  2. 125cm - 150cm44item
  3. 150cm - 170cm64item
  4. 170cm and over12item
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 (124581, 402132, 407008, 407011, 409243, 152972, 152973, 395027, 409118, 409119, 409120, 409121, 98851, 98852, 98853, 98854, 99167, 99168, 98961, 98962, 99134, 159991, 174960, 229657)) ORDER BY FIELD(e.entity_id,124581,402132,407008,407011,409243,152972,152973,395027,409118,409119,409120,409121,98851,98852,98853,98854,99167,99168,98961,98962,99134,159991,174960,229657)

Showing 24 out of 64

Page