Men > Shirts > Long Sleeve

Menís Long Sleeve
Realtree Outfitters Green Gr/heather Grey Knit Pieced Henley W/ Real Tree Collection-men’s Long Sleeve Knit

$39.95

Note: This product is in high demand, please allow extra time for delivery.


update product_parents set totalinventory = '0' where parentid = '699'
Add to Cart

 Need it fast? Some sizes are shipped next business day. Click here for availability.


Realtree Outfitters Men’s Rib Knit Long Sleeve Shirt
Rib Knit Collar
Contrast Cover Stitch
Real Tree Outfitters Series Embroidery
Contrasting Knit Sleeves
Real Tree Emb On Back Neck

Style #04-078-0391-0100GR    Product #699



update product_parents set vendorinventorywhen = now() where parentid = '699'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

update product_parents set nextdelivery = '' where parentid = '699'

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 2xl - nodim = 0

1: 3xl - nodim = 0

Karmin Importing...

2: s - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '13343'

2: m - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '14958'

2: l - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '14959'

2: xl - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '14960'

2: 2xl - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '14961'

2: 3xl - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '14962'

TIQ 0

update products set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where prodid = '13343' and parentid='699'

update product_parents set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where parentid='699'

 

We are currently gathering reviews for this product.


Category: Menís Long Sleeve
Color: Green
Style #: 04-078-0391-0100GR
Product #: 699
Short URL:

brand: realtree outfitters   View more from Realtree Outfitters brand.





refine 2015-01-23 < 2015-01-25

insert into refine_assignments set parentprodid = '13343', parentid = '699', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '13343', parentid = '699', refine_attributeid = '25', refine_categoryid = '5'


View All Categories


Stay in touch: