For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "feiyue x bruce lee" has 24 results

Filter By

Current Filters

  1. Main Colour Black Remove This Item
  2. Scooter Height 80cm - 90cm Remove This Item
Clear All

Category

  1. Bundles23item
  2. New Arrivals6item
  3. SkateHut Sale15item

Foldable?

  1. No7item

Height Adjustable?

  1. No7item

Sales Name

  1. Reduction1 item
  2. Clearance2item
  3. Price Match7item
  4. Red Tier 22item

Scooter Compression Type

  1. IHC3item
  2. HIC2item

Channel Filters

  1. Allowed23item
  2. Excluded1 item

Stock At Supplier

  1. No24item

Cross Sell Type

  1. Colour21item

Reporting Status

  1. Live24item

In Magento

  1. Yes18item
  2. No6item

Use In Google Feed

  1. Yes24item

B-Stock

  1. No24item

Own Brand?

  1. No24item

Channels Ready

  1. Yes17item
  2. No7item

Purchaser

  1. Ricky2item
  2. Tony11item

Country Of Origin

  1. China10item

Google Feed Margin Cat

  1. z11 item
  2. z23item
  3. z313item
  4. other1 item

Order In Active

  1. No24item

Order In Product

  1. No24item

Export

  1. No24item

Has Identifier for GMC

  1. Yes14item
  2. No10item

Export Common

  1. No24item

Supplier Name

  1. Centrano5item
  2. J&R14item
  3. Onecall2item
  4. Shiner3item

Best Suited to

  1. Park6item
  2. Street1 item
  3. Hybrid9item

Scooter Type

  1. Kids Scooter7item
  2. Stunt Scooter17item

Is for Gifting?

  1. No24item

Scooter Bar Height

  1. Adjustable7item
  2. 570mm1 item
  3. 584mm5item
  4. 609mm1 item
  5. 620mm2item
  6. 660mm1 item

Scooter Height

  1. 600mm1 item
  2. 750mm1 item
  3. 815mm4item
  4. 820mm2item
  5. 825mm3item
  6. 830mm1 item
  7. 845mm1 item
  8. 850mm1 item
  9. 865mm1 item
  10. 870mm2item
  11. 890mm1 item
  12. 900mm1 item
  13. 950mm5item

Skill Level

  1. Beginner4item
  2. Intermediate14item

Product Type Basic

  1. Scooters - Commuter1 item
  2. Scooters - Folding6item
  3. Scooters - Stunt Scooters17item

Is Simple Product

  1. Yes24item

Department

  1. Scooters24item

Price

  1. £25.00 - £49.997item
  2. £75.00 - £99.995item
  3. £100.00 - £124.991 item
  4. £125.00 - £149.995item
  5. £150.00 - £174.994item
  6. £175.00 and above2item

Brand Name

  1. Addict Scootering1 item
  2. Blazer Pro2item
  3. Blunt Envy2item
  4. Ethic1 item
  5. JD Bug7item
  6. MGP (Madd Gear Pro)7item
  7. Root Industries3item
  8. Striker1 item

Number Of Wheels

  1. 27item

Product Type

  1. Scooters > Commuter Completes1 item
  2. Scooters > Folding Completes6item
  3. Scooters > Stunt Completes17item

Scooter Bar Compatibility

  1. Fits Standard Bars1 item

Scooter Bar Type

  1. Aluminium (Standard)1 item

Scooter Clamp Type

  1. Collar Clamp1 item

Scooter Fork Type

  1. Fork For 120mm Wheels IHC2item

Scooter Headset Type

  1. Integrated1 item

Scooter Wheel Size

  1. 100mm5item
  2. 110mm2item
  3. 120mm2item

Scooter Deck Type

  1. Integrated 120mm1 item

Gender

  1. Unisex7item

Vegan

  1. No24item

Age

  1. 4 to 61 item
  2. 6 to 813item
  3. 8 to 1216item
  4. 10 +12item

Scooter Brake Type

  1. Flex Fender1 item

Deck Length

  1. 19"1 item
  2. 19.5"7item
  3. 20.5"2item
  4. 21"2item

Deck Width

  1. 120mm1 item
  2. 4.5"2item
  3. 4.8"3item
  4. 5.1"2item
  5. 5.5"3item

Scooter Bar Shape

  1. T - Shape3item
  2. Y - Shape7item

Age Group

  1. Kids7item

Scooter Rider Height Range

  1. 90cm - 125cm5item
  2. 125cm - 150cm21item
  3. 150cm - 170cm24item
  4. 170cm and over6item
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 (409024, 409017, 152972, 337451, 99134, 174960, 254916, 254917, 98839, 98840, 98841, 98842, 98843, 399919, 159991, 98845, 407851, 407848, 405093, 405099, 405111, 405090, 400123, 99167)) ORDER BY FIELD(e.entity_id,409024,409017,152972,337451,99134,174960,254916,254917,98839,98840,98841,98842,98843,399919,159991,98845,407851,407848,405093,405099,405111,405090,400123,99167)

24 Items