For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Skateboard Griptape Applied Remove This Item
  2. Skateboard Length 32" Remove This Item
Clear All

Category

  1. Skateboards20item
  2. Longboards1 item
  3. Bundles20item
  4. New Arrivals1 item
  5. SkateHut Sale2item

Sales Name

  1. Clearance2item
  2. Price Match1 item
  3. Red Tier 15item
  4. Red Tier 21 item

Skateboard Type

  1. Longboard1 item
  2. Stunt5item
  3. Stunt15item

Variant Width

  1. 8"4item

Channel Filters

  1. Allowed21item

Stock At Supplier

  1. No19item

Cross Sell Type

  1. Colour12item
  2. Width2item

Reporting Status

  1. Live20item
  2. Pending1 item

In Magento

  1. Yes16item
  2. No5item

Use In Google Feed

  1. Yes21item

B-Stock

  1. No21item

Own Brand?

  1. No21item

Channels Ready

  1. Yes17item
  2. No4item

Purchaser

  1. Billy7item
  2. Phil3item
  3. Tony6item

Google Feed Margin Cat

  1. z23item
  2. z313item

Skateboard Wheel Base

  1. 14"17item
  2. 14.25"3item

Skateboard Deck Shape

  1. Classic Popsicle20item

Skateboard Deck Concave

  1. Medium20item

Skateboard Deck Construction

  1. 7-Ply20item

Order In Active

  1. Yes1 item
  2. No12item

Order In Product

  1. No18item

Skateboard Riding Use

  1. Street20item
  2. Park16item

Export

  1. No13item

Has Identifier for GMC

  1. Yes16item
  2. No5item

Export Common

  1. No12item

Supplier Name

  1. Centrano10item
  2. Dwindle1 item
  3. Nineteen763item
  4. Stateside7item

Is for Gifting?

  1. No21item

Skateboard Height Range

  1. 5' 2" and over16item

Skateboard Shoe Size Range

  1. UK 5 - UK 815item
  2. UK 8 - UK 101 item

Longboard Shape

  1. Pintail1 item

Skill Level

  1. Beginner7item
  2. Intermediate12item

Product Type Basic

  1. Longboard Completes1 item
  2. Skateboard - Completes20item

Is Simple Product

  1. Yes21item

Department

  1. Longboards1 item
  2. Skateboards20item

Price

  1. £25.00 - £49.993item
  2. £50.00 - £74.999item
  3. £75.00 - £99.998item
  4. £125.00 and above1 item

Brand Name

  1. Blueprint Skateboards3item
  2. Enjoi1 item
  3. Enuff7item
  4. Meow3item
  5. Rad4item
  6. Speed Demons3item

Product Type

  1. Longboards > Completes1 item
  2. Skateboards > Completes20item

Skateboard Age Range

  1. 13 and over16item

Skateboard Deck Width Range

  1. 8.00 - 8.124"18item
  2. 8.125" - 8.24"2item

Main Colour

  1. Black7item
  2. Blue3item
  3. Green1 item
  4. Grey1 item
  5. Multi2item
  6. Natural1 item
  7. Navy1 item
  8. Pink1 item
  9. Rasta1 item
  10. Teal1 item
  11. White1 item
  12. Yellow1 item

Skateboard Deck Width

  1. 8"18item
  2. 8.125"2item

Skateboard Griptape Deck Width

  1. 9"1 item

Vegan

  1. No21item

Longboard Length

  1. 32"1 item

Skateboard Size

  1. Full Size20item

Age Group

  1. Adult20item

Skateboard Wheel Size

  1. 52mm13item
  2. 53mm7item
  3. 70mm1 item

Abec Rating

  1. ABEC 11 item
  2. ABEC 54item
  3. ABEC 715item

Durometer Rating

  1. 55d4item
  2. 99a16item

Material Primary

  1. Birch1 item
  2. Canadian Maple4item
  3. Maple15item
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 (175593, 175596, 175513, 175519, 175512, 108918, 132947, 175469, 406684, 406687, 407638, 108824, 108828, 108832, 108972, 109005, 175594, 237827, 240772, 399583, 393158)) ORDER BY FIELD(e.entity_id,175593,175596,175513,175519,175512,108918,132947,175469,406684,406687,407638,108824,108828,108832,108972,109005,175594,237827,240772,399583,393158)

21 Items