For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "squbi three wheel scooter" has 22 results

Filter By

Current Filters

  1. Purchaser Rob Remove This Item
  2. Order In Active No Remove This Item
Clear All

Category

  1. Bundles21item
  2. SkateHut Sale10item
  3. Black Friday Deals6item

Foldable?

  1. No6item

Height Adjustable?

  1. No6item

Channel Filters

  1. Allowed8item
  2. Excluded14item

Stock At Supplier

  1. No22item

Reporting Status

  1. Live22item

In Magento

  1. No22item

Use In Google Feed

  1. Yes22item

B-Stock

  1. No22item

Own Brand?

  1. No22item

Channels Ready

  1. Yes8item
  2. No14item

Country Of Origin

  1. China8item

Order In Product

  1. No22item

Export

  1. No22item

Has Identifier for GMC

  1. Yes14item
  2. No8item

Export Common

  1. No22item

Supplier Name

  1. Centrano22item

Best Suited to

  1. Park2item
  2. Street3item

Scooter Type

  1. Adult/Commuter Scooter3item
  2. Kids Scooter3item
  3. Stunt Scooter2item

Is for Gifting?

  1. No22item

Scooter Bar Height

  1. Adjustable6item

Scooter Height

  1. 840mm3item
  2. 865mm1 item
  3. 940mm2item
  4. 980mm1 item

Is Configurable Product

  1. No14item

Skill Level

  1. Intermediate2item
  2. Pro2item

Product Type Basic

  1. Scooter Bearings1 item
  2. Scooters - Commuter3item
  3. Scooter Decks3item
  4. Scooters - Folding3item
  5. Scooter Forks4item
  6. Scooter Grip Tape2item
  7. Scooter Headsets4item
  8. Scooters - Stunt Scooters2item

Is Simple Product

  1. Yes22item

Department

  1. Scooters22item

Price

  1. £0.00 - £24.993item
  2. £25.00 - £49.9911item
  3. £50.00 - £74.993item
  4. £75.00 - £99.993item
  5. £225.00 and above2item

Brand Name

  1. Ethic1 item
  2. HangUp Scooters6item
  3. Lucky Scooters2item
  4. Native3item
  5. North Scooters9item
  6. Trynyty1 item

Product Type

  1. Scooters > Bearings1 item
  2. Scooters > Commuter Completes3item
  3. Scooters > Decks3item
  4. Scooters > Folding Completes3item
  5. Scooters > Forks4item
  6. Scooters > Grip Tape2item
  7. Scooters > Headsets4item
  8. Scooters > Stunt Completes2item

Main Colour

  1. Black5item
  2. Blue3item
  3. Green1 item
  4. Pink2item
  5. Red2item
  6. Silver5item
  7. Teal2item
  8. White1 item
  9. Yellow1 item

Deck Type

  1. Integrated3item

Scooter Fork Type

  1. Fork For 120mm Wheels SCS4item

Scooter Headset Type

  1. Integrated4item

Scooter Wheel Size

  1. 125mm3item
  2. 200mm3item

Scooter Deck Type

  1. Integrated 125mm3item

Vegan

  1. No22item

Age

  1. 6 to 85item
  2. 8 to 125item
  3. 10 +8item

Scooter Height

  1. 68cm - 85cm4item
  2. 80cm - 90cm5item
  3. 90cm and over3item
  4. 69cm - 89cm5item

Deck Length

  1. 19.5"1 item
  2. 22"1 item
  3. 23"2item

Deck Width

  1. 4.5"1 item
  2. 5.75"3item

Scooter Bar Shape

  1. Y - Shape1 item

Age Group

  1. Adult14item

Scooter Rider Height Range

  1. 125cm - 150cm5item
  2. 150cm - 170cm5item
  3. 170cm and over3item

Abec Rating

  1. Skate Rated1 item

Builder Part

  1. Yes13item
  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 = '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 (408838, 408832, 408835, 408592, 408595, 408598, 408601, 408712, 408715, 408718, 410374, 410377, 408604, 408577, 408580, 408583, 408679, 408607, 408610, 408613, 408616, 408517)) ORDER BY FIELD(e.entity_id,408838,408832,408835,408592,408595,408598,408601,408712,408715,408718,410374,410377,408604,408577,408580,408583,408679,408607,408610,408613,408616,408517)

22 Items