EUR €

  • Choose a currency

  • British Pound Sterling Website:
  • Danish Krone Website:
  • Swedish Krona Website:
  • MOTO Website:

For Sales & Advice Call Us on 071928374650192837565

Search

Menu

Loading...

Your search for "feiyue mid" has 16 results

Filter By

Current Filters

  1. Order In Product No Remove This Item
  2. Purchaser Ricky Remove This Item
Clear All

Category

  1. Skateboards13item
  2. Bikes1 item
  3. Longboards1 item
  4. Brands14item
  5. Bundles12item
  6. Clearance2item
  7. Offers5item
  8. Half Price3item
  9. SkateHut Sale5item
  10. Last One7item

Order In Active

  1. Yes1 item
  2. No14item

Order In Active Shipping Group

  1. Order in - 5 day leadtime1 item

Export

  1. No14item

Has Identifier for GMC

  1. Yes16item

Export Common

  1. No14item

Supplier Name

  1. Hotline UK2item
  2. Shiner14item

Skateboard Deck Randomiser

  1. No12item

Is for Gifting?

  1. No16item

Bike Frame Size

  1. 23.5"1 item

Bike Type

  1. BMX1 item

Bike Wheel Size

  1. 29"1 item

Product Label Text

  1. 50% Off2item
  2. 40% Off1 item
  3. 45% Off1 item
  4. Last One7item
  5. 55% Off1 item

Longboard Shape

  1. Cruiser1 item

Stock At Supplier

  1. Yes1 item
  2. No13item

Cross Sell Type

  1. Colour5item
  2. Width5item

Reporting Status

  1. Live16item

Sales Name

  1. Price Match1 item
  2. Red Tier 12item
  3. Red Tier 21 item
  4. B-Stock2item

In Magento

  1. Yes14item
  2. No2item

Season Name

  1. Carryover Stock12item
  2. Clearance2item
  3. Summer 201 item
  4. Spring 211 item

Use In Google Feed

  1. Yes14item
  2. No2item

B-Stock

  1. Yes2item
  2. No14item

B-Stock Condition

  1. [Box Damage]1 item
  2. [Pre-Owned]1 item

Product Type Basic

  1. BMX Completes1 item
  2. Mountain BIke Seat Posts1 item
  3. Cruisers1 item
  4. Skateboard Trucks12item
  5. Undercarriage Kits1 item

Own Brand?

  1. No16item

Channels Ready

  1. Yes14item
  2. No2item

Variant Width

  1. 139mm2item
  2. 148mm1 item
  3. 149mm1 item
  4. 159mm1 item
  5. 5"1 item
  6. 5.25"1 item
  7. 5.5"1 item
  8. 6"1 item
  9. 9"2item

Channel Filters

  1. Allowed13item
  2. Excluded3item

Google Feed Margin Cat

  1. z22item
  2. z312item

Department

  1. Bikes2item
  2. Longboards1 item
  3. Skateboards13item

Is Simple Product

  1. Yes16item

Price

  1. €0.00 - €24.991 item
  2. €25.00 - €49.996item
  3. €50.00 - €74.992item
  4. €75.00 - €99.994item
  5. €125.00 - €149.991 item
  6. €150.00 - €174.991 item
  7. €600.00 and above1 item

Sport

  1. Cycling2item

Brand Name

  1. Arbor Skateboards1 item
  2. Birdhouse1 item
  3. Brand-X1 item
  4. Bullet1 item
  5. Grind King3item
  6. Independent4item
  7. Krux2item
  8. SE1 item
  9. Sushi1 item
  10. Thunder1 item

Age

  1. 13+ Years1 item

Product Type

  1. Bikes > BMX Completes1 item
  2. Bikes > Mountain Bikes > Seat Posts1 item
  3. Longboards > Cruisers1 item
  4. Skateboards > Trucks12item
  5. Skateboards > Undercarriage Kits1 item

Longboard Length

  1. 32"1 item

Skateboard Truck Height

  1. Mid - Wheels 53-56mm13item

Main Colour

  1. Black5item
  2. Multi1 item
  3. Raw3item
  4. Silver7item

Skateboard Deck Width Suitability

  1. 7.35"1 item
  2. 7.4"1 item
  3. 7.5"2item
  4. 7.6"2item
  5. 7.75"3item
  6. 7.8"6item
  7. 7.85"6item
  8. 7.88"5item
  9. 7.9"5item
  10. 8"6item
  11. 8.1"5item
  12. 8.12"6item
  13. 8.2"5item
  14. 8.25"4item
  15. 8.3"2item
  16. 8.38"3item
  17. 8.4"2item
  18. 8.5"4item
  19. 8.6"5item
  20. 8.62"4item
  21. 8.68"4item
  22. 8.7"4item
  23. 8.75"4item
  24. 8.82"3item
  25. 8.85"3item
  26. 8.9"3item
  27. 9"3item
  28. 9.12"2item
  29. 9.5"2item
  30. 9.62"2item
  31. 10"2item
  32. 10.5"2item
  33. 7.875"3item
  34. 8.125"3item
  35. 8.375"2item
  36. 8.675"2item

Skateboard Truck Hanger Width

  1. 130mm1 item
  2. 139mm2item
  3. 148mm1 item
  4. 149mm1 item
  5. 159mm1 item
  6. 5.0"1 item
  7. 5.25"2item
  8. 5.5"1 item
  9. 6.0"1 item
  10. 9.0"2item

Vegan

  1. No16item

Truck Width

  1. 139mm2item
  2. 148mm1 item
  3. 149mm1 item
  4. 159mm1 item
  5. 5"1 item
  6. 5.25"1 item
  7. 5.5"1 item
  8. 6"1 item
  9. 9"2item

Skateboard Wheel Size

  1. 65mm1 item

Size Adjustable?

  1. No2item

Adjustable Stopper?

  1. No2item

Light-up Wheels?

  1. No2item

Builder Part

  1. Yes11item
  2. No1 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 = '5' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 5 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 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 (112613, 60328, 111784, 111785, 163732, 377510, 379688, 174061, 238014, 111764, 111765, 111769, 111775, 112354, 112518, 176505))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,112613,60328,111784,111785,163732,377510,379688,174061,238014,111764,111765,111769,111775,112354,112518,176505)

16 Items