SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`was_price`, `e`.`actual_wattage`, `e`.`cap_type`, `e`.`cap_type_value`, `e`.`bulb_types`, `e`.`bulb_types_value`, `e`.`bulb_shape`, `e`.`bulb_shape_value`, `e`.`material`, `e`.`finish`, `e`.`colour`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`links_exist`, `e`.`is_imported`, `e`.`collection_style`, `e`.`collection_style_value`, `e`.`lookbook`, `e`.`lookbook_value`, `e`.`lookbook_image`, `e`.`beam_angle`, `e`.`beam_angle_value`, `e`.`bulb_colour_temperature`, `e`.`bulb_colour_temperature_value`, `e`.`equivilent_wattage`, `e`.`equivilent_wattage_value`, `e`.`bulb_lumens`, `e`.`google_promotion_code`, `e`.`google_promotion_code_value`, `e`.`high_street_price`, `e`.`bulb_qty`, `e`.`productpage_image`, `e`.`is_new`, `e`.`discontinued`, `e`.`cut_out_hole_size`, `e`.`product_type`, `e`.`style`, `e`.`offers`, `e`.`filter_collection`, `e`.`touch_activated_lhn`, `e`.`touch_activated_lhn_value`, `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` FROM `catalog_product_flat_8` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=8 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '541' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '4' AND price_index.customer_group_id = 0 WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 48

22 Item(s)

per page
Bellevue White / Beech 42 Ceiling Fan With Remote Control Compare Products
Magnum Copper / Black 42 Celling Fan With Remote Control Compare Products
Nimrod Copper 42 Ceiling Fan With 1 Light Compare Products
Taurus Copper 42 Ceiling Fan With Remote Control Compare Products
Florida Colonial Matt Black Leaf 52 Ceiling Fan With Remote Compare Products
Scimitar Brushed Chrome & Black 42" Ceiling Fan with Spotlights Compare Products
Spitfire Brushed Chrome 30" Ceiling Fan with Light Compare Products
Hawker White & Polished Brass 36" Ceiling Fan with 3 Lights Compare Products
Typhoon Brushed Chrome 30" Ceiling Fan with Light Compare Products
Nimrod White  42" Ceiling Fan with 1 Light Compare Products
Candy Multi Coloured 30” Celling Fan with Opal Glass Compare Products
MiniSun Fanaway Classic 48" Antique Black Ceiling Fan Remote Compare Products
MiniSun Kichler 54" Link In Polished Nickel Fan Remote Control Compare Products

Remote Control for Ceiling Fan

Product Code: 18878
Remote Control for Ceiling Fan Compare Products
24" Extension Rod for Ceiling Fans WHITE Compare Products
24" Extension Rod for Ceiling Fans CHROME Compare Products
MiniSun Fanaway EVO1 LED 48" Ceiling Fan Remote Control Compare Products
Taurus Duck Egg Blue / Cream 42" Ceiling Fan With Remote Control Compare Products
Sebring Brushed Chrome / Clear 48" Ceiling Fan With Remote Control Compare Products
Taurus Silver Grey 42” Celling Fan with Remote Control Compare Products
Magnum Brushed Chrome / Black 42” Celling Fan with Remote Control Compare Products
Apache Chrome / Wood 48" Ceiling Fan With Remote Control Compare Products

22 Item(s)

per page