For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Has Identifier for GMC No Remove This Item
  2. Skateboard Deck Width Range 7.50" - 7.99" Remove This Item
Clear All

Skateboard Type

  1. Stunt8item

Variant Width

  1. 7.5"1 item
  2. 7.75"1 item

Channel Filters

  1. Allowed11item
  2. Excluded2item

Stock At Supplier

  1. No13item

Cross Sell Type

  1. Colour1 item

Reporting Status

  1. Live13item

In Magento

  1. Yes2item
  2. No11item

Use In Google Feed

  1. Yes13item

B-Stock

  1. No13item

Own Brand?

  1. No13item

Channels Ready

  1. Yes13item

Skateboard Wheel Base

  1. 13.875"1 item
  2. 14"7item

Skateboard Deck Shape

  1. Classic Popsicle8item

Skateboard Griptape

  1. Applied8item
  2. Not Included5item

Skateboard Length

  1. 31"2item
  2. 31.2"2item
  3. 31.5"4item

Skateboard Deck Concave

  1. Medium8item

Skateboard Deck Construction

  1. 7-Ply8item

Order In Active

  1. No12item

Order In Product

  1. No13item

Skateboard Riding Use

  1. Street8item

Export

  1. No12item

Export Common

  1. No12item

Supplier Name

  1. Centrano3item
  2. HLC1 item
  3. Nineteen764item
  4. Rolling Thunder3item
  5. Shiner1 item
  6. Stateside1 item

Skateboard Deck Randomiser

  1. No5item

Is for Gifting?

  1. No13item

Product Label Text

  1. Free Grip Tape5item

Skill Level

  1. Beginner3item
  2. Intermediate5item

Product Type Basic

  1. Skateboard - Completes8item
  2. Skateboard Decks5item

Is Simple Product

  1. Yes13item

Department

  1. Skateboards13item

Price

  1. £0.00 - £24.991 item
  2. £25.00 - £49.991 item
  3. £50.00 - £74.996item
  4. £75.00 and above5item

Brand Name

  1. Element1 item
  2. Enuff1 item
  3. Flip1 item
  4. Meow1 item
  5. Primitive3item
  6. Rad3item
  7. Sk8 Mafia1 item
  8. The Heart Supply2item

Product Type

  1. Skateboards > Completes8item
  2. Skateboards > Decks5item

Main Colour

  1. Black7item
  2. Gold1 item
  3. Natural1 item
  4. Purple3item
  5. White1 item

Skateboard Deck Width

  1. 7.5"1 item
  2. 7.75"12item

Vegan

  1. No13item

Skateboard Size

  1. Full Size8item

Age Group

  1. Adult5item
  2. Kids3item

Skateboard Wheel Size

  1. 52mm7item
  2. 54mm1 item

Abec Rating

  1. ABEC 55item
  2. ABEC 72item
  3. ABEC 91 item

Durometer Rating

  1. 101a3item
  2. 85a1 item
  3. 90a1 item
  4. 95a2item
  5. 99a1 item

Material Primary

  1. Canadian Maple3item
  2. Maple5item

Builder Part

  1. Yes5item
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 (408070, 397946, 407758, 409277, 406651, 405817, 408334, 388084, 408430, 406648, 406729, 392251, 392254)) ORDER BY FIELD(e.entity_id,408070,397946,407758,409277,406651,405817,408334,388084,408430,406648,406729,392251,392254)

13 Items