For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Purchaser Ricky Remove This Item
  2. Builder Part Yes Remove This Item
Clear All

Category

  1. Skateboards12item
  2. Scooters5item
  3. Skates1 item
  4. Longboards1 item
  5. SkateHut Sale6item

Sales Name

  1. Clearance1 item
  2. Price Match2item
  3. Red Tier 13item
  4. Red Tier 21 item

Scooter Compression Type

  1. SCS1 item

Variant Width

  1. 8"1 item
  2. 8.125"1 item
  3. 8.25"1 item

Channel Filters

  1. Allowed15item

Stock At Supplier

  1. Yes1 item
  2. No14item

Cross Sell Type

  1. Colour4item
  2. Size1 item
  3. Width3item

Reporting Status

  1. Live9item
  2. Discontinued6item

In Magento

  1. Yes15item

Use In Google Feed

  1. Yes15item

B-Stock

  1. No15item

Own Brand?

  1. No14item

Channels Ready

  1. Yes14item
  2. No1 item

Google Feed Margin Cat

  1. z12item
  2. z22item
  3. z311item

Skateboard Griptape

  1. Included1 item
  2. Not Included6item

Order In Active

  1. No11item

Order In Product

  1. Yes1 item
  2. No10item

Export

  1. No11item

Has Identifier for GMC

  1. Yes15item

Export Common

  1. No11item

Supplier Name

  1. Keen3item
  2. Shiner12item

Best Suited to

  1. Hybrid2item

Skateboard Deck Randomiser

  1. Yes2item
  2. No6item

Truck Bolt Length

  1. 1"1 item

Is for Gifting?

  1. No14item

Skateboard Height Range

  1. 4' 2" - 5' 2"1 item
  2. 5' 2" and over6item

Skateboard Shoe Size Range

  1. UK 1 - UK 51 item
  2. UK 5 - UK 83item
  3. UK 8 - UK 101 item
  4. UK 10 - UK 122item

Product Label Text

  1. Free Grip Tape7item
  2. 50% Off1 item
  3. 40% Off1 item

Product Type Basic

  1. Scooter Compression Kits1 item
  2. Scooter Decks2item
  3. Skateboard Bearings1 item
  4. Skateboard Decks7item
  5. Skateboard Grip Tape3item
  6. Skateboard Truck Bolts1 item

Is Simple Product

  1. Yes15item

Department

  1. Scooters3item
  2. Skateboards12item

Price

  1. £0.00 - £24.996item
  2. £50.00 and above9item

Brand Name

  1. Anti Hero3item
  2. Blazer Pro3item
  3. Bones Bearings1 item
  4. Creature1 item
  5. Independent1 item
  6. Krooked1 item
  7. MOB3item
  8. Santa Cruz1 item
  9. Sushi1 item

Product Type

  1. Scooters > Compression Kits1 item
  2. Scooters > Decks2item
  3. Skateboards > Bearings1 item
  4. Skateboards > Decks7item
  5. Skateboards > Grip Tape3item
  6. Skateboards > Truck Bolts1 item

Skateboard Age Range

  1. 8 to 131 item
  2. 13 and over6item

Skateboard Deck Width Range

  1. 7.50" - 7.99"1 item
  2. 8.00 - 8.124"3item
  3. 8.125" - 8.24"1 item
  4. 8.25" - 8.49"2item

Main Colour

  1. Black4item
  2. Blue1 item
  3. Gold1 item
  4. Green2item
  5. Multi1 item
  6. Neochrome1 item
  7. Silver1 item
  8. White1 item

Deck Type

  1. Integrated1 item

Scooter Bar Compatibility

  1. Fits Oversized Bars Fits Standard Bars1 item

Scooter Clamp Type

  1. SCS Compression1 item

Skateboard Deck Width

  1. 7.75"1 item
  2. 8"2item
  3. 8.06"1 item
  4. 8.125"1 item
  5. 8.25"1 item
  6. 8.38"1 item

Truck Width

  1. 9"2item

Scooter Deck Type

  1. Integrated 120mm2item

Skateboard Griptape Deck Width

  1. 9"4item

Vegan

  1. No14item

Deck Length

  1. 21"1 item
  2. 22"1 item

Deck Width

  1. 5.1"2item

Abec Rating

  1. Skate Rated1 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 (163937, 112528, 132394, 132393, 251094, 163825, 112270, 163738, 163739, 111508, 269057, 163735, 164090, 111570, 111470)) ORDER BY FIELD(e.entity_id,163937,112528,132394,132393,251094,163825,112270,163738,163739,111508,269057,163735,164090,111570,111470)

15 Items