Need a new account?

To get access to our prices and make an order, sign up for a wholesale account and we will review it for approval!

sign up button

Search

Search



 
Advanced Search

Halo Reach - Series 1 Warthog Vehicle Supreme Boxed Set

Manufacturer:   McFarlane
Product No#   MCF18941

Halo Reach - Series 1 Warthog Vehicle Supreme Boxed Set

The deluxe vehicle boxed set is a Warthog with Gatling Gun with rolling wheels, turning steering wheel, spinning gun turret and elevating Gatling gun.

1194 - Table 'orders_products' is marked as crashed and should be repaired

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6422' and opa.orders_id = opb.orders_id and opb.products_id != '6422' 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

TEP_DB_ERRORR

Barcode:  0787926189414
This product was added to our catalog on Monday 29 March, 2010.