For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 12 results

Filter By

Current Filters

  1. Foldable? No Remove This Item
  2. Main Colour Black Remove This Item
Clear All

Category

  1. Scooters9item
  2. Brands9item
  3. Bundles5item
  4. Clearance3item
  5. SkateHut Sale8item

Bike Frame Size

  1. 23.7"1 item

Bike Type

  1. Mountain1 item

Bike Wheel Size

  1. 29"1 item

Height Adjustable?

  1. No12item

Kick Stand?

  1. No3item

Light Brake?

  1. No3item

Light Front?

  1. No3item

Light Rear?

  1. No3item

Regenerative Breaking?

  1. No3item

Sales Name

  1. Price Match5item
  2. B-Stock3item

Channel Filters

  1. Allowed10item
  2. Excluded2item

Stock At Supplier

  1. Yes1 item
  2. No11item

Cross Sell Type

  1. Colour9item

Reporting Status

  1. Live12item

In Magento

  1. Yes8item
  2. No4item

Use In Google Feed

  1. Yes9item
  2. No3item

B-Stock

  1. Yes3item
  2. No9item

B-Stock Condition

  1. [Box Damage]2item
  2. [Pre-Owned]1 item

Own Brand?

  1. No12item

Channels Ready

  1. Yes9item
  2. No3item

Purchaser

  1. Tony6item

Country Of Origin

  1. China4item

Google Feed Margin Cat

  1. z38item
  2. other1 item

Order In Active

  1. Yes1 item
  2. No11item

Order In Active Shipping Group

  1. Oversize but on normal couriers and order in1 item

Order In Inactive Shipping Group

  1. Full size longboards1 item

Order In Product

  1. No12item

Export

  1. No12item

Has Identifier for GMC

  1. Yes8item
  2. No4item

Export Common

  1. No12item

Supplier Name

  1. CSG1 item
  2. J&R10item
  3. National Deals 1 item

Scooter Type

  1. Adult/Commuter Scooter3item
  2. Kids Scooter9item
  3. Cruiser Scooter3item

Is for Gifting?

  1. No12item

Scooter Bar Height

  1. Adjustable10item

Scooter Height

  1. 870mm1 item
  2. 950mm5item
  3. 1000mm4item

Product Type Basic

  1. Mountain Bike Completes1 item
  2. Scooters - Commuter5item
  3. Scooters - Folding5item
  4. Hoverkarts1 item

Is Simple Product

  1. Yes12item

Department

  1. Bikes1 item
  2. Scooters10item
  3. Skateboards1 item

Price

  1. £25.00 - £49.997item
  2. £50.00 - £74.994item
  3. £975.00 and above1 item

Brand Name

  1. GoHoverkart1 item
  2. GT1 item
  3. JD Bug6item
  4. MGP (Madd Gear Pro)4item

Number Of Wheels

  1. 26item

Product Type

  1. Bikes > Mountain Bike Completes1 item
  2. Scooters > Commuter Completes5item
  3. Scooters > Folding Completes5item
  4. Skateboards > Hoverkarts1 item

Sport

  1. Cycling1 item

Scooter Wheel Size

  1. 100mm5item
  2. 120mm1 item
  3. 200mm4item

Gender

  1. Unisex6item

Vegan

  1. No12item

Bike Size

  1. Medium1 item

Age

  1. 4 to 61 item
  2. 6 to 81 item
  3. 8 to 122item
  4. 10 +10item

Scooter Height

  1. 50cm - 75cm5item
  2. 68cm - 85cm5item
  3. 80cm - 90cm6item
  4. 90cm and over9item

Bike Fork Travel

  1. 120mm1 item

Bike Suspension

  1. Hardtail1 item

Age Group

  1. Kids6item

Scooter Rider Height Range

  1. 90cm - 125cm5item
  2. 125cm - 150cm5item
  3. 150cm - 170cm6item
  4. 170cm and over9item

Size Adjustable?

  1. No3item

Adjustable Stopper?

  1. No3item

Light-up Wheels?

  1. No3item
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 (345630, 377057, 99167, 397964, 397967, 397970, 405841, 98839, 98840, 98841, 98842, 98843)) ORDER BY FIELD(e.entity_id,345630,377057,99167,397964,397967,397970,405841,98839,98840,98841,98842,98843)

12 Items