Shopping Cart now in your cart 0 items
Homepage Company Specials Web Create an Account Log In Contact Us
Categories
Reviews
Write Review Write a review on this product!

Top » Catalog » BANDOLIERS » BANDOLERA004 » BANDOLIER 004
[BANDOLERA004]
Five cm wide white faux leather Bandolier. Length according to size. Clips at the ends to military cartridge belts. Terminals, pins and emblems simulating buckle are optional. Made of brass. Metals can be nickel plating.

Metals are not included in the prices



Para elegir la talla adecuada dirijase al apartado de “Como tomar mis medidas” / We suggest that you check our “How to messure my size” section to get the right size.

IVA no incluido en el precio / VAT not included

Los precios son para una unidad o pack, para pedidos superiores contactar con nosotros para descuentos. Consultar existencias y plazo de entrega.
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'marisaor_tienda.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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