For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 33 results

Filter By

Current Filters

  1. Skill Level Intermediate Remove This Item
  2. Age 10 + Remove This Item
Clear All

Category

  1. New Arrivals3item
  2. SkateHut Sale17item
  3. Summer Sale13item

Sales Name

  1. Price Match4item

Channel Filters

  1. Allowed30item
  2. Excluded3item

Stock At Supplier

  1. Yes1 item
  2. No32item

Cross Sell Type

  1. Colour23item

Reporting Status

  1. Live32item
  2. Discontinued1 item

In Magento

  1. Yes8item
  2. No25item

Use In Google Feed

  1. Yes33item

B-Stock

  1. No33item

Own Brand?

  1. No33item

Channels Ready

  1. Yes29item
  2. No4item

Purchaser

  1. Tony5item
  2. Rob2item

Country Of Origin

  1. China28item

Google Feed Margin Cat

  1. z13item
  2. z21 item
  3. z31 item
  4. other3item

Order In Active

  1. No29item

Order In Product

  1. No33item

Export

  1. No29item

Has Identifier for GMC

  1. Yes5item
  2. No28item

Export Common

  1. No29item

Supplier Name

  1. Centrano15item
  2. J&R3item
  3. Onecall8item
  4. Shiner3item
  5. Stateside1 item
  6. RI Distribution3item

Best Suited to

  1. Park13item
  2. Street7item
  3. Hybrid9item

Scooter Type

  1. Stunt Scooter33item

Is for Gifting?

  1. No33item

Scooter Bar Height

  1. 600mm1 item
  2. 620mm15item
  3. 635mm3item
  4. 650mm3item

Scooter Height

  1. 840mm1 item
  2. 850mm3item
  3. 855mm3item
  4. 865mm6item
  5. 870mm12item
  6. 900mm3item
  7. 945mm1 item
  8. 950mm3item

Product Type Basic

  1. Scooters - Stunt Scooters33item

Is Simple Product

  1. Yes33item

Department

  1. Scooters33item

Price

  1. £125.00 - £149.9910item
  2. £150.00 - £174.9912item
  3. £175.00 and above11item

Brand Name

  1. Addict Scootering3item
  2. Blunt Envy8item
  3. Lucky Scooters2item
  4. MGP (Madd Gear Pro)3item
  5. Root Industries3item
  6. Slamm1 item
  7. Striker13item

Product Type

  1. Scooters > Stunt Completes33item

Main Colour

  1. Black10item
  2. Blue3item
  3. Bronze1 item
  4. Gold2item
  5. Green1 item
  6. Neochrome3item
  7. Orange1 item
  8. Purple1 item
  9. Raw2item
  10. Red1 item
  11. Silver4item
  12. Teal2item
  13. White1 item
  14. Yellow1 item

Vegan

  1. No33item

Scooter Height

  1. 68cm - 85cm5item
  2. 80cm - 90cm29item
  3. 90cm and over7item
  4. 69cm - 89cm22item

Deck Length

  1. 19"3item
  2. 19.5"12item
  3. 20.5"1 item
  4. 21"4item
  5. 22"1 item
  6. 19.75"8item

Deck Width

  1. 4.5"10item
  2. 5.5"9item
  3. 6"1 item

Scooter Bar Shape

  1. T - Shape8item
  2. Y - Shape20item

Scooter Rider Height Range

  1. 125cm - 150cm21item
  2. 150cm - 170cm29item
  3. 170cm and over8item
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, 411059, 136512, 408241, 408244, 408247, 408250, 160004, 410377, 407872, 160000, 160001, 400129, 400132, 400135, 411379, 411380, 411381, 408913, 408916, 408919)) ORDER BY FIELD(e.entity_id,411330,411331,409243,152973,411059,136512,408241,408244,408247,408250,160004,410377,407872,160000,160001,400129,400132,400135,411379,411380,411381,408913,408916,408919)

Showing 24 out of 33

Page