LOTR - Aragorn vs. Uruk-Hai - The Wall of Helms Deep Diorama

$349.99 USD  $227.49 USD
Save: 35% off

Limited Edition of 750 pieces.
The Wall of Helm's Deep Diorama captures Aragorn in the heat of battle, as he turns from one attacker to another with grim resolve. The Uruk-hai berserker is slain, but before Aragorn can dispatch the ladder, he must face a ferocious swordsman. The diorama has been sculpted in approximately 1:9 scale, each figure standing approximately 9.5 inches tall. Each piece is cast in high quality polystone, hand-finished, and hand-painted to exacting standards. The Wall of Helm's Deep Diorama is complete with a hand-numbered individual edition number on the bottom side of the base. Don't miss this chance to continue your collection of The Lord of the Rings Dioramas!

Sold Out
  • Model: LOTR - Aragorn vs. Uruk-Hai - The Wall of Helms Deep Diorama
  • Manufactured by: Sideshow


This product was added to our catalog on Sunday 03 July, 2011.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'heros_zencart.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '523' and opa.orders_id = opb.orders_id and opb.products_id != '523' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]