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

Snow Globes

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`, `at_bestsellers`.`qty_ordered` AS `bestsellers`, `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 `amasty_sorting_bestsellers` AS `at_bestsellers` ON (at_bestsellers.`product_id`=e.entity_id) AND (at_bestsellers.store_id = '5') LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (61205, 72073, 78821, 78855, 78908, 78909, 67504, 67505, 67532, 72075, 14441, 32461, 45297, 45317, 78854, 82518, 72074, 67506, 67516, 67519, 67520, 72096, 55183, 83343)) ORDER BY FIELD(e.entity_id,61205,72073,78821,78855,78908,78909,67504,67505,67532,72075,14441,32461,45297,45317,78854,82518,72074,67506,67516,67519,67520,72096,55183,83343)

24 Items

Set Ascending Direction
per page
  1. Gingerbread House Large Musical Snow Globe Decoration
    Gisela Graham Gingerbread House Large Musical Snow Globe Decoration
    Special Price $67.50 Regular Price $75.00
    Add to Wish List Add to Compare
  2. Fox and Robin with Watering Can Large Musical Snow Globe Decoration
    Gisela Graham Fox and Robin with Watering Can Large Musical Snow Globe Decoration
    Special Price $60.30 Regular Price $67.00
    Add to Wish List Add to Compare
  3. Large Pink & Gold Rocking Horse Musical Snow Globe Decoration
    Gisela Graham Large Pink & Gold Rocking Horse Musical Snow Globe Decoration
    Special Price $54.00 Regular Price $60.00
    Add to Wish List Add to Compare
  4. Snowman & Woodland Animals Large Musical Snow Globe
    Gisela Graham Snowman & Woodland Animals Large Musical Snow Globe
    Special Price $54.00 Regular Price $60.00
    Add to Wish List Add to Compare
  5. Silver & White Village Large Musical Snow Globe
    Gisela Graham Silver & White Village Large Musical Snow Globe
    Special Price $51.30 Regular Price $57.00
    Add to Wish List Add to Compare
  6. Polar Bear Family Musical Snow Globe
    Gisela Graham Polar Bear Family Musical Snow Globe
    Special Price $24.30 Regular Price $27.00
    Add to Wish List Add to Compare
  7. Assorted Santa Snow Globe
    Gisela Graham Assorted Santa Snow Globe
    Special Price $14.40 Regular Price $16.00
    Add to Wish List Add to Compare
  8. Assorted Santa With Tree Snow Globe
    Gisela Graham Assorted Santa With Tree Snow Globe
    Special Price $14.40 Regular Price $16.00
    Add to Wish List Add to Compare
  9. Ballet Shoes Medium Snow Globe Decoration
    Gisela Graham Ballet Shoes Medium Snow Globe Decoration
    Special Price $18.90 Regular Price $21.00
    Add to Wish List Add to Compare
  10. Toadstool House Large Musical Snow Globe Decoration
    Gisela Graham Toadstool House Large Musical Snow Globe Decoration
    Special Price $54.00 Regular Price $60.00
    Add to Wish List Add to Compare
  11. New England Santa Snowdome
    Gisela Graham New England Santa Snowdome
    Special Price $13.50 Regular Price $15.00
    Add to Wish List Add to Compare
  12. Gold & White Resin Deer Mini Snow Dome Decoration
    Gisela Graham Gold & White Resin Deer Mini Snow Dome Decoration
    Special Price $8.10 Regular Price $9.00
    Add to Wish List Add to Compare
  13. Santa with Sack Musical Snow Globe
    Gisela Graham Santa with Sack Musical Snow Globe
    Special Price $40.50 Regular Price $45.00
    Add to Wish List Add to Compare
  14. Winter Scene with Deer Snow Globe
    Gisela Graham Winter Scene with Deer Snow Globe
    Special Price $46.80 Regular Price $52.00
    Add to Wish List Add to Compare
  15. Assorted Robin Medium Snow Globe Decoration
    Gisela Graham Assorted Robin Medium Snow Globe Decoration
    Special Price $17.10 Regular Price $19.00
    Add to Wish List Add to Compare
  16. 9cm Boxed Snow Globe
    Paddington Bear 9cm Boxed Snow Globe
    Special Price $40.50 Regular Price $45.00
    Out of stock
    Add to Wish List Add to Compare
  17. Woodland Animals Large Musical Snow Globe Decoration
    Gisela Graham Woodland Animals Large Musical Snow Globe Decoration
    Special Price $60.30 Regular Price $67.00
    Out of stock
    Add to Wish List Add to Compare
  18. Nutcracker Story Musical Snow Globe
    Gisela Graham Nutcracker Story Musical Snow Globe
    Special Price $57.60 Regular Price $64.00
    Out of stock
    Add to Wish List Add to Compare
  19. Robin Medium Snow Globe Decoration
    Gisela Graham Robin Medium Snow Globe Decoration
    Special Price $18.90 Regular Price $21.00
    Out of stock
    Add to Wish List Add to Compare
  20. Assorted Gonk Girl Mini Snow Globe Decoration
    Gisela Graham Assorted Gonk Girl Mini Snow Globe Decoration
    Special Price $9.00 Regular Price $10.00
    Out of stock
    Add to Wish List Add to Compare
  21. Santa & Reindeer Large Musical Snow Globe Decoration
    Gisela Graham Santa & Reindeer Large Musical Snow Globe Decoration
    Special Price $67.50 Regular Price $75.00
    Out of stock
    Add to Wish List Add to Compare
  22. Santa with Garland Large Musical Snow Globe Decoration
    Gisela Graham Santa with Garland Large Musical Snow Globe Decoration
    Special Price $54.00 Regular Price $60.00
    Out of stock
    Add to Wish List Add to Compare
  23. Brown Reindeer Mini Snow Dome Decoration
    Gisela Graham Brown Reindeer Mini Snow Dome Decoration
    Special Price $8.10 Regular Price $9.00
    Out of stock
    Add to Wish List Add to Compare
  24. Union Jack 5.5cm Plastic Snowstorm
    Paddington Bear Union Jack 5.5cm Plastic Snowstorm
    Special Price $8.10 Regular Price $9.00
    Out of stock
    Add to Wish List Add to Compare

24 Items

Set Ascending Direction
per page
closex
Filter Products
Filters
Product
  1. Decoration 1 item
  2. Snow Globe 23 items
Brand
  1. Gisela Graham 22 items
  2. Paddington Bear 2 items
Range
  1. Paddington Bear 2 items
Price
Special Features
  1. Boxed 2 items
Colour
  1. Blue 1 item
  2. Brown 3 items
  3. Clear 1 item
  4. Cream 3 items
  5. Gold 4 items
  6. Green 6 items
  7. Grey 1 item
  8. Multi 5 items
  9. Orange 1 item
  10. Pink 1 item
  11. Red 14 items
  12. Silver 1 item
  13. White 12 items
Material
  1. Glass 18 items
  2. Plastic 1 item
  3. Polyresin 1 item
  4. Resin 3 items
Occasion
  1. Christmas 9 items
Christmas Decorations Range
  1. Ballerinas 1 item
  2. Birds 2 items
  3. Gonks 1 item
  4. Traditional 9 items
  5. Wildlife & Nature 5 items
Film & TV Collections
  1. Paddington Bear 2 items

Customer Service

Fast and secure payment with:
Secure Payment Options
Terms & Conditions
© 2023 - 2024