WOMEN'S ROLLED UP HEM DENIM SHORTS

No C8029R

Description
Specs
Reviews
Live Chat

Roll up to summer in style

Embellish your signature look with rolled-up denim shorts for women. These soft stretchy Indigo shorts will make your legs look fabulous and your style effortless. Dress them up with some strappy sandals and a breezy blouse, or keep it simple with a tank or tee and your favorite flats. Nothing says summer better than a nice pair of shorts. And Charlie B knows you couldn’t be more comfortable or feel more stylish than in this flattering jean short. Wear it with a tank top and enjoy your hot-weather look.

Material: 73% cotton, 23% polyester, 3% viscose, and 1% spandex
Rolled up hem
Front and back pockets
Stretch denim short design
Care instruction: wash your shorts in your washing machine and hang to dry
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

Embellish your signature look with rolled-up denim shorts for women. These soft stretchy Indigo shorts will make your legs look fabulous and your style effortless. Dress them up with some strappy sandals and a breezy blouse, or keep it simple with a tank or tee and your favorite flats. Nothing says summer better than a nice pair of shorts. And Charlie B knows you couldn’t be more comfortable or feel more stylish than in this flattering jean short. Wear it with a tank top and enjoy your hot-weather look.
Specs
- Material: 73% cotton, 23% polyester, 3% viscose, and 1% spandex
- Rolled up hem
- Front and back pockets
- Stretch denim short design
- Care instruction: wash your shorts in your washing machine and hang to dry
- Imported
Reviews

No Reviews Yet!
Live Chat

$59.00

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	PINK,GRAY	111905	[empty string]	[empty string]	0	3	0	0	CORAL	35	Y	[empty string]	1001000	[empty string]	212984
2	INDIGO	111906	[empty string]	[empty string]	0	3	0	0	INDIGO	102	Y	[empty string]	1001003	[empty string]	212984

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,max(a.sell_web) as sell_web 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,14,6,5,9,8,15,7,2,1,3,97) 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 in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,14,6,5,9,8,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	212984

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	PINK,GRAY	111905	[empty string]	[empty string]	0	3	0	0	CORAL	35	Y	[empty string]	1001000	[empty string]	212984
2	INDIGO	111906	[empty string]	[empty string]	0	3	0	0	INDIGO	102	Y	[empty string]	1001003	[empty string]	212984