NO. 5 FRONT POCKET WALLET WITH FOLD-OVER FLAP

colonel littleton

No W5FL

1 Review(s)

No.5 Front Pocket Wallet With Fold- Over Flap

$60.00

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BROWN	45551	[empty string]	[empty string]	0	5	0	0	BROWN	10	[empty string]	637205	[empty string]	130472
2	BLACK	45552	[empty string]	[empty string]	0	5	0	0	BLACK	10	[empty string]	925200	[empty string]	130472
3	SADDLE_TAN	45553	[empty string]	[empty string]	0	5	0	0	SADDLE_TAN	10	[empty string]	637206	[empty string]	130472

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 (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=-1000000000) 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=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= -1000000000 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	130472

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BROWN	45551	[empty string]	[empty string]	0	5	0	0	BROWN	10	[empty string]	637205	[empty string]	130472
2	BLACK	45552	[empty string]	[empty string]	0	5	0	0	BLACK	10	[empty string]	925200	[empty string]	130472
3	SADDLE_TAN	45553	[empty string]	[empty string]	0	5	0	0	SADDLE_TAN	10	[empty string]	637206	[empty string]	130472

array
1	130472

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BROWN	45551	[empty string]	[empty string]	0	5	0	0	BROWN	10	[empty string]	637205	[empty string]	130472
2	BLACK	45552	[empty string]	[empty string]	0	5	0	0	BLACK	10	[empty string]	925200	[empty string]	130472
3	SADDLE_TAN	45553	[empty string]	[empty string]	0	5	0	0	SADDLE_TAN	10	[empty string]	637206	[empty string]	130472

array
1	130472

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

Qty

Available Online Only

Add to Basket

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

Description
Specs
Reviews
Live Chat

cash and carry

Stash your cash in the classically rugged Front Pocket Wallet with Fold-Over Flap. Handcrafted in Colonel Littleton's workshop, this handsome leather accessory is made of brown native American steer hide, tanned in Tennessee, and dry milled to attain buttery softness. Detailed edge stitching and two convenient pockets round out the wallet's features, and the front flap may be monogrammed with three block initials to make it extra special. Like its name implies, it is compact enough to carry in your front pocket but has enough room not only for your bills but also for a few credit cards and ID.

Made in USA
Made of brown native American steer hide
Tanned in Tennessee
Dry milled to achieve softness
Two pockets
Edge stitched
Dimensions: 3.9 x 3 inches
Weight: 8 ounces
Handmade in Col. Littleton's Workshop in Lynnville, TN, USA
May be personalized with three initials at an additional charge
Please call Mast Store's Customer Service line toll-free for engraving or embossing options at 1.866.367.6278

Average 5 out of 5

1 reviews
Rick

May 14, 2020

Love this wallet!

Got this as a gift a few years ago. My large wallet in my back pocket was causing back pain and ridicule. This made me more efficient and simplified what I carry.

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

Stash your cash in the classically rugged Front Pocket Wallet with Fold-Over Flap. Handcrafted in Colonel Littleton's workshop, this handsome leather accessory is made of brown native American steer hide, tanned in Tennessee, and dry milled to attain buttery softness. Detailed edge stitching and two convenient pockets round out the wallet's features, and the front flap may be monogrammed with three block initials to make it extra special. Like its name implies, it is compact enough to carry in your front pocket but has enough room not only for your bills but also for a few credit cards and ID.
Specs
- Made in USA
- Made of brown native American steer hide
- Tanned in Tennessee
- Dry milled to achieve softness
- Two pockets
- Edge stitched
- Dimensions: 3.9 x 3 inches
- Weight: 8 ounces
- Handmade in Col. Littleton's Workshop in Lynnville, TN, USA
- May be personalized with three initials at an additional charge
- Please call Mast Store's Customer Service line toll-free for engraving or embossing options at 1.866.367.6278
Reviews
- Average 5 out of 5
  
  1 reviews
- Rick
  
  May 14, 2020
  
  Love this wallet!
  
  Got this as a gift a few years ago. My large wallet in my back pocket was causing back pain and ridicule. This made me more efficient and simplified what I carry.
Live Chat

NO. 5 FRONT POCKET WALLET WITH FOLD-OVER FLAP

$60.00

Choose Color

Qty

Description

Specs

Reviews

Live Chat

Love this wallet!

Spill the Beans

Love this wallet!

You may also like