NO. 4 BILLFOLD WALLET

colonel littleton

No WLF4

1 Review(s)

$215.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	59	[empty string]	[empty string]	1	2	-1	0	BROWN	10	[empty string]	554484	[empty string]	114846

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 (6,7,11,14,3,9,15,5,8,2,1) 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(6,7,11,14,3,9,15,5,8,2,1) 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	114846

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

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

traditional currency carrier

Colonel Littleton has created this classic gentleman's folding wallet designed for rear pocket carry. The No. 4 Billfold is made of the Colonel's soft, vintage brown dry-milled leather right in his workshop in Lynnville, TN. It has a polished leather interior and stylish edge stitching. Inside, there is a compartment for billed currency, slots for four credit cards and one ID card as well as two hidden pockets. Give this wallet a personal touch by having it monogrammed on the lower right front with three initials.

Made in USA
Crafted of vintage brown dry-milled leather
Polished leather interior
Edge stitched
Interior has slots for currency, credit cards, and ID
Interior also has two hidden pockets
Dimensions when closed: 3 1/2 x 4 inches
Made in Col. Littleton's Workshop in Lynnville, TN, USA
Lower right front may be personalized at an additional cost with three initials
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
Shane

December 1, 2017

Best Wallet I have ever owned!

I got this Wallet for Christmas before I went to Afghanistan for deployment. This wallet still looks great and only gets better with age. Something to be said about great craftsmanship and this wallet is a testament to the craft. I recommend this wallet to anyone. I cant say enough good things about this wallet.

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

Colonel Littleton has created this classic gentleman's folding wallet designed for rear pocket carry. The No. 4 Billfold is made of the Colonel's soft, vintage brown dry-milled leather right in his workshop in Lynnville, TN. It has a polished leather interior and stylish edge stitching. Inside, there is a compartment for billed currency, slots for four credit cards and one ID card as well as two hidden pockets. Give this wallet a personal touch by having it monogrammed on the lower right front with three initials.
Specs
- Made in USA
- Crafted of vintage brown dry-milled leather
- Polished leather interior
- Edge stitched
- Interior has slots for currency, credit cards, and ID
- Interior also has two hidden pockets
- Dimensions when closed: 3 1/2 x 4 inches
- Made in Col. Littleton's Workshop in Lynnville, TN, USA
- Lower right front may be personalized at an additional cost with three initials
- 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
- Shane
  
  December 1, 2017
  
  Best Wallet I have ever owned!
  
  I got this Wallet for Christmas before I went to Afghanistan for deployment. This wallet still looks great and only gets better with age. Something to be said about great craftsmanship and this wallet is a testament to the craft. I recommend this wallet to anyone. I cant say enough good things about this wallet.
QA

Your Name Email Question
Live Chat

NO. 4 BILLFOLD WALLET

$215.00

Choose Color

Qty

Description

Specs

Reviews

Live Chat

Best Wallet I have ever owned!

Spill the Beans

Best Wallet I have ever owned!

You may also like