For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "radio revo 20"" has 22 results

Filter By

Current Filters

  1. Channels Ready No Remove This Item
  2. Has Identifier for GMC No Remove This Item
Clear All

Category

  1. Skateboards4item
  2. Scooters16item
  3. Bikes2item
  4. Electrics1 item
  5. Bundles16item
  6. New Arrivals13item
  7. SkateHut Sale17item
  8. Black Friday Deals1 item

Bike Frame Size

  1. 20"1 item

Bike Type

  1. Electric1 item

Bike Wheel Size

  1. 20"1 item

Channel Filters

  1. Allowed14item
  2. Excluded8item

Max Range

  1. 24 miles1 item

Max Speed

  1. 15.5 mph1 item

Stock At Supplier

  1. Yes1 item
  2. No21item

Cross Sell Type

  1. Colour11item

Reporting Status

  1. Live22item

In Magento

  1. Yes12item
  2. No10item

Use In Google Feed

  1. Yes22item

B-Stock

  1. No22item

Own Brand?

  1. No22item

Country Of Origin

  1. China15item

Google Feed Margin Cat

  1. z26item
  2. z32item
  3. other4item

Order In Active

  1. No17item

Order In Product

  1. Yes1 item
  2. No17item

Export

  1. No17item

Export Common

  1. No17item

Supplier Name

  1. Flow1 item
  2. J&R16item
  3. Keen4item
  4. Upgrade1 item

Best Suited to

  1. Park9item
  2. Hybrid7item

Scooter Type

  1. Stunt Scooter16item

Is for Gifting?

  1. Yes2item
  2. No20item

Scooter Bar Height

  1. 533mm7item
  2. 584mm5item
  3. 609mm2item
  4. 635mm2item

Scooter Height

  1. 710mm4item
  2. 750mm4item
  3. 770mm1 item
  4. 800mm2item
  5. 815mm4item
  6. 830mm1 item

Skill Level

  1. Beginner7item
  2. Intermediate9item

Product Type Basic

  1. Electric Bike Completes1 item
  2. Scooters - Stunt Scooters16item
  3. Skateboard Wax4item
  4. Bike Locks1 item

Is Simple Product

  1. Yes22item

Department

  1. Bikes2item
  2. Scooters16item
  3. Skateboards4item

Price

  1. £0.00 - £24.994item
  2. £50.00 - £74.995item
  3. £75.00 - £99.997item
  4. £100.00 - £124.992item
  5. £125.00 - £149.991 item
  6. £150.00 - £174.992item
  7. £675.00 and above1 item

Brand Name

  1. ABUS1 item
  2. Flow1 item
  3. Ganj Wax4item
  4. MGP (Madd Gear Pro)16item

Product Type

  1. Bikes > Electric Bike Completes1 item
  2. Skateboards > Wax4item
  3. Scooters > Stunt Completes16item
  4. Bikes > Accessories > Bike Locks1 item

Sport

  1. Cycling1 item

Main Colour

  1. Black13item
  2. Bronze1 item
  3. Gold2item
  4. Green1 item
  5. Neochrome1 item
  6. Pink2item
  7. Silver1 item
  8. White1 item

Vegan

  1. No22item

Bike Size

  1. Medium1 item

Age

  1. 4 to 67item
  2. 6 to 816item
  3. 8 to 128item

Scooter Height

  1. 50cm - 75cm7item
  2. 68cm - 85cm16item
  3. 80cm - 90cm8item
  4. 69cm - 89cm16item

Deck Length

  1. 19"2item
  2. 19.5"2item

Bike Suspension

  1. Rigid1 item

Deck Width

  1. 4"2item
  2. 4.5"2item

Scooter Bar Shape

  1. Y - Shape2item

Scooter Rider Height Range

  1. 90cm - 125cm7item
  2. 125cm - 150cm16item
  3. 150cm - 170cm8item

Material Primary

  1. Hi-Ten Steel1 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 (388666, 409273, 409274, 409276, 409275, 405102, 407848, 407851, 405093, 405111, 407842, 407845, 405081, 405087, 405105, 405108, 405090, 402732, 405096, 405075, 405078, 405072)) ORDER BY FIELD(e.entity_id,388666,409273,409274,409276,409275,405102,407848,407851,405093,405111,407842,407845,405081,405087,405105,405108,405090,402732,405096,405075,405078,405072)

22 Items