For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 23 results

Filter By

Current Filters

  1. Height Adjustable? No Remove This Item
Clear All

Category

  1. Scooters22item
  2. Brands22item
  3. Bundles10item
  4. Clearance1 item
  5. SkateHut Sale17item

Foldable?

  1. No23item

Kick Stand?

  1. No1 item

Light Brake?

  1. No1 item

Light Front?

  1. No1 item

Light Rear?

  1. No1 item

Regenerative Breaking?

  1. No1 item

Sales Name

  1. Price Match5item
  2. B-Stock1 item

Variant Width

  1. 4.72"1 item

Channel Filters

  1. Allowed21item
  2. Excluded1 item

Stock At Supplier

  1. No22item

Cross Sell Type

  1. Colour16item

Reporting Status

  1. Live22item

In Magento

  1. Yes12item
  2. No11item

Use In Google Feed

  1. Yes21item
  2. No2item

B-Stock

  1. Yes1 item
  2. No22item

B-Stock Condition

  1. [Cosmetic Damage]1 item

Own Brand?

  1. No23item

Channels Ready

  1. Yes21item
  2. No2item

Purchaser

  1. Tony12item
  2. Rob4item

Country Of Origin

  1. China10item

Google Feed Margin Cat

  1. z312item

Order In Active

  1. No23item

Order In Product

  1. No23item

Export

  1. No23item

Has Identifier for GMC

  1. Yes12item
  2. No11item

Export Common

  1. No23item

Supplier Name

  1. J&R17item
  2. Onecall4item
  3. TKC1 item

Scooter Type

  1. Adult/Commuter Scooter5item
  2. Kids Scooter20item
  3. Cruiser Scooter4item

Is for Gifting?

  1. No23item

Scooter Bar Height

  1. Adjustable21item

Scooter Height

  1. 870mm7item
  2. 950mm6item
  3. 1000mm8item

Product Label Text

  1. 10% Off1 item

Product Type Basic

  1. Scooters - Commuter6item
  2. Scooter Decks1 item
  3. Scooters - Folding11item
  4. Scooters - Three Wheel4item

Is Simple Product

  1. Yes22item
  2. No1 item

Department

  1. Scooters22item

Price

  1. £0.00 - £24.991 item
  2. £25.00 - £49.9913item
  3. £50.00 - £74.998item
  4. £75.00 and above1 item

Brand Name

  1. JD Bug14item
  2. MGP (Madd Gear Pro)4item
  3. Sacrifice1 item
  4. Vital4item

Number Of Wheels

  1. 211item

Product Type

  1. Scooters > Commuter Completes6item
  2. Scooters > Decks1 item
  3. Scooters > Folding Completes11item
  4. Scooters > Three Wheeled Completes4item

Main Colour

  1. Black9item
  2. Blue2item
  3. Grey1 item
  4. Pink2item
  5. Purple2item
  6. Red2item
  7. Teal4item

Scooter Wheel Size

  1. 100mm6item
  2. 120mm7item
  3. 200mm4item
  4. n/a4item

Scooter Deck Type

  1. Integrated 120mm1 item

Gender

  1. Unisex11item

Vegan

  1. No23item

Bundle Starting Price

  1. £50.00 and above1 item

Age

  1. 4 to 61 item
  2. 6 to 86item
  3. 8 to 1212item
  4. 10 +17item

Scooter Height

  1. 50cm - 75cm5item
  2. 68cm - 85cm9item
  3. 80cm - 90cm16item
  4. 90cm and over10item
  5. 69cm - 89cm5item

Deck Length

  1. 20.8"1 item

Deck Width

  1. 4.72"1 item

Age Group

  1. Kids11item

Scooter Rider Height Range

  1. 90cm - 125cm5item
  2. 125cm - 150cm10item
  3. 150cm - 170cm16item
  4. 170cm and over10item

Size Adjustable?

  1. No1 item

Adjustable Stopper?

  1. No1 item

Light-up Wheels?

  1. No1 item
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 (331595, 395027, 98851, 98852, 98853, 98854, 99167, 99168, 397964, 397967, 397970, 397973, 409578, 409579, 409580, 409581, 98839, 98840, 98841, 98842, 98843, 406009, 235029)) ORDER BY FIELD(e.entity_id,331595,395027,98851,98852,98853,98854,99167,99168,397964,397967,397970,397973,409578,409579,409580,409581,98839,98840,98841,98842,98843,406009,235029)

23 Items