WOMEN'S PFG TAMIAMI SHIRT

No 1275701-100

Be the first to review!

$45.00

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	WHITE	78684	[empty string]	[empty string]	0	3	0	0	WHITE	37	[empty string]	743370	[empty string]	151884

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (3,8,9,1,2,6,11,5,7,14,15) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id in (145295,151884,167472,183881,183882) AND e.store_id in(3,8,9,1,2,6,11,5,7,14,15) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

struct
INTERNALLISTPRICE	45
INTERNALMARKDOWN	false
INTERNALPRICE	45
REG	45
SALE	45
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

CHOOSE Size

Size Chart

Size

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

it's fishing time any season

For those weekends spent at the lake or by the seaside, look no further than the Women's PFG Tamiami Shirt. This versatile long sleeve is part of Columbia's Performance Fishing Gear line and is crafted from ultra-light ripstop fabric that wicks away moisture to keep you comfortable and dry. UPF 40 sun protection shields your skin from UV rays even on the cloudiest of days. Roll-up tab sleeves and mesh-lined ventilation at the center of the back offer the ultimate in cool-wearing style when it gets muggy.

100% polyester
Performance Fishing Gear (PFG) line
Full-snap front closure
Spread collar
Long roll-tab sleeves
Two on-seam zip pockets
Shirttail hemline with split side seams
Hook-and-loop Columbia® patch rod holder tab at left chest for hands-free convenience
Omni-Shade® UPF 40 provides maximum protection from UV rays
Omni-Wick® technology actively breathes and pulls moisture away from your skin
Modern classic fit
Antimicrobial treatment protects shirt from bacterial growth
Mesh-lined vent at center back
Machine wash cold, tumble dry low
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

For those weekends spent at the lake or by the seaside, look no further than the Women's PFG Tamiami Shirt. This versatile long sleeve is part of Columbia's Performance Fishing Gear line and is crafted from ultra-light ripstop fabric that wicks away moisture to keep you comfortable and dry. UPF 40 sun protection shields your skin from UV rays even on the cloudiest of days. Roll-up tab sleeves and mesh-lined ventilation at the center of the back offer the ultimate in cool-wearing style when it gets muggy.
Specs
- 100% polyester
- Performance Fishing Gear (PFG) line
- Full-snap front closure
- Spread collar
- Long roll-tab sleeves
- Two on-seam zip pockets
- Shirttail hemline with split side seams
- Hook-and-loop Columbia® patch rod holder tab at left chest for hands-free convenience
- Omni-Shade® UPF 40 provides maximum protection from UV rays
- Omni-Wick® technology actively breathes and pulls moisture away from your skin
- Modern classic fit
- Antimicrobial treatment protects shirt from bacterial growth
- Mesh-lined vent at center back
- Machine wash cold, tumble dry low
- Imported
Reviews

No Reviews Yet!
QA

Your Name Email Question
Live Chat

WOMEN'S PFG TAMIAMI SHIRT

$45.00

Choose Color

CHOOSE Size

Qty

Description

Specs

Reviews

Live Chat

Spill the Beans

You may also like

Regular Price: $59.00

Sale Price: $20.49