CategoriesAirsoft Innovations (11)ASC Wear (2)BBBastard BBs (1)Pantac Gear (67)  Bags/Cases (10)
  Belts/Personal (8)
  Holsters (2)
  Hydration (4)
  Miscellaneous (1)
  Pouches (26)
  Slings (3)
  Vests - Modular (7)
  Vests - Static (6)
Tachyon XC (5)
Your Email Address
Your Password
Create Account

Cart0 items

Molle Hydration Pack For Molle Vests - Pantac

From RedWolf Airsoft:

Made of CORDURA, compatitable with all molle system vests. Capacity is 2 lites. Size : 24cm x 48cm.

You Buy Now

Coyote Brown [WB-C224-CB-A]  $76.99CAD  Quantity :
Multicam - Codura [WB-C224-MC-A]  $98.99CAD  Quantity :
Olive Drab [WB-C224-OD-A]  $76.99CAD  Quantity :
Khaki [WB-C224-TN-A]  $76.99CAD  Quantity :
Multicam - Nylon [WB-N224-MC-A]  $71.99CAD  Quantity :
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ascmart_ascmart.xp.products_id' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_xsell xp, products p, products_description pd where xp.products_id = '67' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 6