For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 65 results

Filter By

Current Filters

  1. Order In Active No Remove This Item
  2. Scooter Height 80cm - 90cm Remove This Item
Clear All

Category

  1. Bundles58item
  2. New Arrivals10item
  3. SkateHut Sale32item

Foldable?

  1. No12item

Height Adjustable?

  1. No12item

Sales Name

  1. Price Match12item
  2. Red Tier 23item

Scooter Compression Type

  1. IHC4item

Channel Filters

  1. Allowed53item
  2. Excluded9item
  3. Ebay Only3item

Stock At Supplier

  1. No63item

Cross Sell Type

  1. Colour53item

Reporting Status

  1. Live64item
  2. Discontinued1 item

In Magento

  1. Yes36item
  2. No29item

Use In Google Feed

  1. Yes65item

B-Stock

  1. No65item

Own Brand?

  1. No65item

Channels Ready

  1. Yes51item
  2. No14item

Purchaser

  1. Billy4item
  2. Tony21item
  3. Rob2item

Country Of Origin

  1. China39item

Google Feed Margin Cat

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

Order In Product

  1. No65item

Export

  1. No65item

Has Identifier for GMC

  1. Yes25item
  2. No40item

Export Common

  1. No65item

Supplier Name

  1. Centrano14item
  2. Core2item
  3. Greenover3item
  4. J&R29item
  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 Scooter11item
  3. Stunt Scooter53item

Is for Gifting?

  1. No65item

Scooter Bar Height

  1. Adjustable12item
  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. 950mm5item

Skill Level

  1. Beginner8item
  2. Intermediate39item
  3. Pro7item

Product Type Basic

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

Is Simple Product

  1. Yes65item

Department

  1. Scooters65item

Price

  1. £25.00 - £49.9914item
  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 Bug12item
  6. Lucky Scooters2item
  7. MGP (Madd Gear Pro)17item
  8. Native1 item
  9. Root Industries10item
  10. Slamm2item
  11. Striker6item

Number Of Wheels

  1. 211item

Product Type

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

Main Colour

  1. Black29item
  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. 100mm5item
  2. 120mm7item

Gender

  1. Unisex11item

Vegan

  1. No65item

Age

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

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. Kids11item

Scooter Rider Height Range

  1. 90cm - 125cm5item
  2. 125cm - 150cm45item
  3. 150cm - 170cm65item
  4. 170cm and over13item
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, 174960, 99134, 159991, 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,174960,99134,159991,229657)

Showing 24 out of 65

Page