• My Account
  • Register
  • Compare Products
Shop
Wishlist
My Cart
Shop
Account
Return to Previous Page
x

House of Disaster: Lamps & Lights

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`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` 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 = '5' LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (58645, 70003, 70012, 70013, 73756, 35106, 47833, 52512, 53943, 66398, 66399, 66400, 84517, 70001, 73757, 66397)) ORDER BY FIELD(e.entity_id,58645,70003,70012,70013,73756,35106,47833,52512,53943,66398,66399,66400,84517,70001,73757,66397)

16 Items

Set Ascending Direction
per page
  1. The Beatles Yellow Submarine Small LED Light
    House Of Disaster The Beatles Yellow Submarine Small LED Light
    Special Price $34.20 Regular Price $38.00
    Add to Wish List Add to Compare
  2. Broccoli Mini LED Light
    House Of Disaster Broccoli Mini LED Light
    Special Price $22.20 Regular Price $37.00
    Add to Wish List Add to Compare
  3. Peanuts Snoopy House Light Up Keyring
    House Of Disaster Peanuts Snoopy House Light Up Keyring
    Special Price $12.60 Regular Price $14.00
    Add to Wish List Add to Compare
  4. Peanuts Snoopy Light Up Keyring
    House Of Disaster Peanuts Snoopy Light Up Keyring
    Special Price $12.60 Regular Price $14.00
    Add to Wish List Add to Compare
  5. Peanuts Snoopy Rainbow Mini LED Light
    House Of Disaster Peanuts Snoopy Rainbow Mini LED Light
    Special Price $35.10 Regular Price $39.00
    Add to Wish List Add to Compare
  6. Moomin Moomintroll Small LED Light
    House Of Disaster Moomin Moomintroll Small LED Light
    Special Price $30.60 Regular Price $34.00
    Add to Wish List Add to Compare
  7. Moomin Snorkmaiden Small LED Light
    House Of Disaster Moomin Snorkmaiden Small LED Light
    Special Price $30.60 Regular Price $34.00
    Add to Wish List Add to Compare
  8. Penguin Small LED Light
    House Of Disaster Penguin Small LED Light
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare
  9. Moomin & Snorkmaiden Love Small LED Light
    House Of Disaster Moomin & Snorkmaiden Love Small LED Light
    Special Price $36.90 Regular Price $41.00
    Add to Wish List Add to Compare
  10. Moomin & Snorkmaiden ‘Love’ Light Up Keyring
    House Of Disaster Moomin & Snorkmaiden ‘Love’ Light Up Keyring
    Special Price $12.60 Regular Price $14.00
    Add to Wish List Add to Compare
  11. Moomin Light Up Keyring
    House Of Disaster Moomin Light Up Keyring
    Special Price $12.60 Regular Price $14.00
    Add to Wish List Add to Compare
  12. Moomin Snorkmaiden Light Up Keyring
    House Of Disaster Moomin Snorkmaiden Light Up Keyring
    Special Price $12.60 Regular Price $14.00
    Add to Wish List Add to Compare
  13. Peanuts Snoopy House Mini LED Light
    House Of Disaster Peanuts Snoopy House Mini LED Light
    Special Price $30.60 Regular Price $34.00
    Add to Wish List Add to Compare
  14. Squirrel Mini LED Light
    House Of Disaster Squirrel Mini LED Light
    Special Price $28.80 Regular Price $32.00
    Out of stock
    Add to Wish List Add to Compare
  15. Peanuts Standing Snoopy LED Light
    House Of Disaster Peanuts Standing Snoopy LED Light
    Special Price $70.20 Regular Price $78.00
    Out of stock
    Add to Wish List Add to Compare
  16. Moomin Little My Light Up Keyring
    House Of Disaster Moomin Little My Light Up Keyring
    Special Price $12.60 Regular Price $14.00
    Out of stock
    Add to Wish List Add to Compare

16 Items

Set Ascending Direction
per page
Trending In This Category
The Beatles Yellow Submarine Small LED Light
The Beatles Yellow Submarine Small LED Light
Special Price $34.20 Regular Price $38.00
Moomin Moomintroll Small LED Light
Moomin Moomintroll Small LED Light
Special Price $30.60 Regular Price $34.00
Moomin Snorkmaiden Small LED Light
Moomin Snorkmaiden Small LED Light
Special Price $30.60 Regular Price $34.00
Penguin Small LED Light
Penguin Small LED Light
Special Price $27.00 Regular Price $30.00
Moomin & Snorkmaiden Love Small LED Light
Moomin & Snorkmaiden Love Small LED Light
Special Price $36.90 Regular Price $41.00
Moomin & Snorkmaiden ‘Love’ Light Up Keyring
Moomin & Snorkmaiden ‘Love’ Light Up Keyring
Special Price $12.60 Regular Price $14.00
Moomin Light Up Keyring
Moomin Light Up Keyring
Special Price $12.60 Regular Price $14.00
Moomin Snorkmaiden Light Up Keyring
Moomin Snorkmaiden Light Up Keyring
Special Price $12.60 Regular Price $14.00
Broccoli Mini LED Light
Broccoli Mini LED Light
Special Price $22.20 Regular Price $37.00
Peanuts Snoopy House Light Up Keyring
Peanuts Snoopy House Light Up Keyring
Special Price $12.60 Regular Price $14.00
closex

Customer Service

Fast and secure payment with:
Secure Payment Options
Terms & Conditions
© Great British Brands USA 2023 - 2026