Please wait...

Continue shopping
View cart & checkout
Continue shopping
View cart & checkout

Valuelights

Trade Customers Call 0161 837 6099Trade Customers: 0161 837 6099
Consumer Helpline Call 0161 647 7377Consumer Helpline: 0161 647 7377

Skip to Main Content »

Filter By
  1. Remove This Item Touch Activated: No
Product Type
  1. Light Bulbs (10)
Touch Activated
  1. No (10)
Price
  1. £3.00 - £3.99 (4)
  2. £4.00 - £4.99 (1)
  3. £5.00 and above (5)
Colour
  1. Cool White (4)
  2. Warm White (6)
Cap Type
  1. MR11 (1)
  2. GU10 (9)
Material
  1. Glass (4)
  2. Metal (2)
  3. Plastic (5)
Bulb Shape
  1. Spotlight (10)
Finish
  1. Frosted (7)
Bulb Technology Types
  1. LED (10)
Wattage
  1. 0-2.5W (1)
  2. 3-5W (9)
Lumens
  1. 420lm (2)
  2. 150lm (1)
  3. 450 (2)
  4. 400 (2)
  5. 280 (2)
  6. 200 (1)
Compare Products

You have no items to compare.

Filter By

Currently Shopping by

  1. Touch Activated: No Remove This Item
Colour
  1. Cool White (4)
  2. Warm White (6)
Price
  1. £3.00 - £3.99 (4)
  2. £4.00 - £4.99 (1)
  3. £5.00 and above (5)
Material
  1. Glass (4)
  2. Metal (2)
  3. Plastic (5)
Finish
  1. Frosted (7)
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_7` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=7 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '361' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '3' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `touch_activated_lhn_idx` ON touch_activated_lhn_idx.entity_id = e.entity_id AND touch_activated_lhn_idx.attribute_id = '719' AND touch_activated_lhn_idx.store_id = 7 AND touch_activated_lhn_idx.value IN('2249') WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 48

10 Item(s)

per page

Set Descending Direction