For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "Venom 2021 20” Complete BMX" has 7 results

Filter By

Current Filters

  1. Main Colour Navy Remove This Item
Clear All

Category

  1. Skateboards2item
  2. Longboards1 item
  3. Protection1 item
  4. Clothes2item
  5. Water Sports3item
  6. Bundles4item
  7. SkateHut Sale1 item

Helmet Certification

  1. EN1078 Certified1 item

Sales Name

  1. Clearance2item

Skateboard Type

  1. Longboard1 item
  2. Stunt1 item
  3. Stunt1 item

Variant Width

  1. 7.75"1 item

Channel Filters

  1. Allowed7item

Helmet Size Range

  1. 57 - 59cm1 item

Helmet Impact Type

  1. Single Impact1 item

Size

  1. Extra Large1 item

Stock At Supplier

  1. No6item

Cross Sell Type

  1. Colour3item

Reporting Status

  1. Live6item
  2. Discontinued1 item

In Magento

  1. Yes5item
  2. No3item

Use In Google Feed

  1. Yes7item
  2. No4item

B-Stock

  1. No7item

Own Brand?

  1. Yes1 item
  2. No6item

Channels Ready

  1. Yes7item

Purchaser

  1. Own Brand1 item

Google Feed Margin Cat

  1. z21 item
  2. z31 item
  3. other2item

Skateboard Wheel Base

  1. 14"1 item
  2. 14.25"1 item

Skateboard Deck Shape

  1. Classic Popsicle2item

Skateboard Griptape

  1. Applied3item

Skateboard Length

  1. 31"1 item
  2. 32"1 item

Skateboard Deck Concave

  1. Medium2item

Skateboard Deck Construction

  1. 7-Ply2item

Order In Active

  1. No2item

Order In Product

  1. No3item

Skateboard Riding Use

  1. Street2item
  2. Park1 item

Export

  1. No2item

Has Identifier for GMC

  1. Yes3item
  2. No4item

Export Common

  1. No2item

Supplier Name

  1. Barts2item
  2. Centrano1 item
  3. Nineteen761 item
  4. Rock Solid1 item
  5. Spirit Sports1 item
  6. dryrobe1 item

Is for Gifting?

  1. No7item

Skateboard Height Range

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

Skateboard Shoe Size Range

  1. UK 1 - UK 51 item

Is Configurable Product

  1. Yes1 item

Longboard Shape

  1. Pintail1 item

Skill Level

  1. Intermediate2item

Product Type Basic

  1. Swimming Shorts2item
  2. Longboard Completes1 item
  3. Helmets1 item
  4. Skateboard - Completes2item
  5. Changing Robes1 item

Is Simple Product

  1. Yes3item
  2. No4item

Department

  1. Clothes/Accessories2item
  2. Longboards1 item
  3. Protection1 item
  4. Skateboards2item
  5. Water2item

Price

  1. £25.00 - £49.993item
  2. £50.00 - £74.991 item
  3. £75.00 - £99.991 item
  4. £125.00 - £149.991 item
  5. £175.00 and above1 item

Brand Name

  1. Barts2item
  2. Habitat1 item
  3. Ocean Pacific1 item
  4. QUBA1 item
  5. Rad1 item
  6. Dryrobe1 item

Head Size Multi

  1. 57cm1 item
  2. 58cm1 item
  3. 59cm1 item

Product Type

  1. Clothes/Accessories > Swimming Shorts2item
  2. Longboards > Completes1 item
  3. Protection > Helmets1 item
  4. Skateboards > Completes2item
  5. Water > Apparel > Changing Robes1 item

Head Size

  1. 55 - 60 cm1 item

Age Range

  1. Adults1 item

Skateboard Deck Width Range

  1. 7.50" - 7.99"1 item
  2. 8.00 - 8.124"1 item

Skateboard Deck Width

  1. 7.75"1 item
  2. 8"1 item

Size

  1. Small2item
  2. Medium1 item
  3. Large2item

Head Size Single

  1. 57cm1 item

Gender

  1. Male2item
  2. Unisex1 item

Vegan

  1. No7item

Longboard Length

  1. 40"1 item

Helmet Type

  1. Bike Helmet1 item

Skateboard Size

  1. Full Size2item

Age Group

  1. Adult5item

Skateboard Wheel Size

  1. 52mm1 item
  2. 53mm1 item

Abec Rating

  1. ABEC 51 item
  2. ABEC 71 item

Durometer Rating

  1. 99a2item

Material Primary

  1. Maple2item
  2. Polyester Blend2item
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 (161588, 406684, 407593, 223478, 387766, 388249, 369398)) ORDER BY FIELD(e.entity_id,161588,406684,407593,223478,387766,388249,369398)

7 Items