Fast Delivery
Price Match
Expert Support
Fast Delivery
Price Match
Expert Support
Call Us Call Us Help Help Basket Basket

Freestanding Fans

View as Grid List

7 Items

Set Descending Direction
    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' 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 (1006, 1137, 2963, 3754, 3755, 4036, 4122)) ORDER BY FIELD(e.entity_id,1006,1137,2963,3754,3755,4036,4122)
  1. PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 59.99

    Dimensions: H 89 x W 25 x D 17 cm

    £59.99
    More Info
  2. PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 49.99

    Dimensions: H 90 x W 20 x D 20 cm

    £49.99
    More Info
  3. PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 59.99

    Dimensions: H 130 x W 42 x D 45 cm

    £59.99
    More Info
  4. PRIORITY: | QTY: 2 | RECOMMENDED: | PRICE: 79.99

    Dimensions: H 51 x W 22.5 x D 38.5 cm

    £79.99
    More Info
  5. PRIORITY: | QTY: 3 | RECOMMENDED: | PRICE: 79.99

    Dimensions: H 51 x W 22 x D 38 cm

    £79.99
    More Info
  6. PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 199.99

    Dimensions: H 94 x W 35 x D 35 cm

    £199.99
    More Info
  7. PRIORITY: | QTY: 1 | RECOMMENDED: | PRICE: 199.99

    Dimensions: H 93 x W 35 x D 35 cm

    £199.99
    More Info
per page
Filters
Price
  1. £0.00 - £99.99 (5)
  2. £100.00 and above (2)
Manufacturer
  1. IGENIX (3)
  2. Shark (2)
  3. Vybra (2)
Warranty
  1. 1 (2)
  2. 2 (4)
Check delivery to your postcode
postcode: local: no
session postcode: session local: no
A G A B C D E F G