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 Offers: Last Chance
Product Type
  1. Outdoor Lighting (2)
Offers
  1. Outlet (1)
  2. Last Chance (2)
Touch Activated
  1. No (2)
Price
  1. £10.00 - £19.99 (1)
  2. £50.00 and above (1)
Colour
  1. Blue (2)
  2. Silver (2)
Material
  1. Metal (2)
  2. Plastic (2)
Finish
  1. Brushed Metallic (2)
Bulb Technology Types
  1. LED (2)
Compare Products

You have no items to compare.

Filter By

Currently Shopping by

  1. Offers: Last Chance Remove This Item
Offers
  1. Outlet (1)
  2. Last Chance (2)
Colour
  1. Blue (2)
  2. Silver (2)
Price
  1. £10.00 - £19.99 (1)
  2. £50.00 and above (1)
Material
  1. Metal (2)
  2. Plastic (2)
Finish
  1. Brushed Metallic (2)
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 = '370' 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 `offers_idx` ON offers_idx.entity_id = e.entity_id AND offers_idx.attribute_id = '716' AND offers_idx.store_id = 7 AND offers_idx.value IN('2106') WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 48

2 Item(s)

per page

Set Descending Direction