
WOMEN'S DREAMSCAPE LOUNGE PANTS
$22.99
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 AS_WISH 113168 [empty string] [empty string] 0 2 0 0 AS_WISH 28 Y [empty string] 941998 [empty string] 201227 2 CAT_NAP 113169 [empty string] [empty string] 0 2 0 0 CAT_NAP 37 Y [empty string] 941999 [empty string] 201227 3 UNDER_PALMS 113170 [empty string] [empty string] 0 2 0 0 UNDER_PALMS 53 Y [empty string] 942000 [empty string] 201227 4 HEAD_IN_CLOUDS 113171 [empty string] [empty string] 0 2 0 0 HEAD_IN_CLOUDS 43 Y [empty string] 942001 [empty string] 201227 5 MDNGHT_MIRAGE 113172 [empty string] [empty string] 0 2 0 0 MDNGHT_MIRAGE 40 Y [empty string] 942002 [empty string] 201227 6 DESERT_DREAMS 113173 [empty string] [empty string] 0 2 0 0 DESERT_DREAMS 49 Y [empty string] 942003 [empty string] 201227 CACHED false EXECUTIONTIME 0 SQL 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,5,8,6,9,14,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,5,8,6,9,14,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 201227 struct INTERNALLISTPRICE 22.99 INTERNALMARKDOWN false INTERNALPRICE 22.99 REG 22.99 SALE 22.99 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 AS_WISH 113168 [empty string] [empty string] 0 2 0 0 AS_WISH 28 Y [empty string] 941998 [empty string] 201227 2 CAT_NAP 113169 [empty string] [empty string] 0 2 0 0 CAT_NAP 37 Y [empty string] 941999 [empty string] 201227 3 UNDER_PALMS 113170 [empty string] [empty string] 0 2 0 0 UNDER_PALMS 53 Y [empty string] 942000 [empty string] 201227 4 HEAD_IN_CLOUDS 113171 [empty string] [empty string] 0 2 0 0 HEAD_IN_CLOUDS 43 Y [empty string] 942001 [empty string] 201227 5 MDNGHT_MIRAGE 113172 [empty string] [empty string] 0 2 0 0 MDNGHT_MIRAGE 40 Y [empty string] 942002 [empty string] 201227 6 DESERT_DREAMS 113173 [empty string] [empty string] 0 2 0 0 DESERT_DREAMS 49 Y [empty string] 942003 [empty string] 201227 CACHED false EXECUTIONTIME 0 SQL 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,5,8,6,9,14,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,5,8,6,9,14,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 201227 struct INTERNALLISTPRICE 22.99 INTERNALMARKDOWN false INTERNALPRICE 22.99 REG 22.99 SALE 22.99 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 AS_WISH 113168 [empty string] [empty string] 0 2 0 0 AS_WISH 28 Y [empty string] 941998 [empty string] 201227 2 CAT_NAP 113169 [empty string] [empty string] 0 2 0 0 CAT_NAP 37 Y [empty string] 941999 [empty string] 201227 3 UNDER_PALMS 113170 [empty string] [empty string] 0 2 0 0 UNDER_PALMS 53 Y [empty string] 942000 [empty string] 201227 4 HEAD_IN_CLOUDS 113171 [empty string] [empty string] 0 2 0 0 HEAD_IN_CLOUDS 43 Y [empty string] 942001 [empty string] 201227 5 MDNGHT_MIRAGE 113172 [empty string] [empty string] 0 2 0 0 MDNGHT_MIRAGE 40 Y [empty string] 942002 [empty string] 201227 6 DESERT_DREAMS 113173 [empty string] [empty string] 0 2 0 0 DESERT_DREAMS 49 Y [empty string] 942003 [empty string] 201227 CACHED false EXECUTIONTIME 0 SQL 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,5,8,6,9,14,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,5,8,6,9,14,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 201227 struct INTERNALLISTPRICE 22.99 INTERNALMARKDOWN false INTERNALPRICE 22.99 REG 22.99 SALE 22.99 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 AS_WISH 113168 [empty string] [empty string] 0 2 0 0 AS_WISH 28 Y [empty string] 941998 [empty string] 201227 2 CAT_NAP 113169 [empty string] [empty string] 0 2 0 0 CAT_NAP 37 Y [empty string] 941999 [empty string] 201227 3 UNDER_PALMS 113170 [empty string] [empty string] 0 2 0 0 UNDER_PALMS 53 Y [empty string] 942000 [empty string] 201227 4 HEAD_IN_CLOUDS 113171 [empty string] [empty string] 0 2 0 0 HEAD_IN_CLOUDS 43 Y [empty string] 942001 [empty string] 201227 5 MDNGHT_MIRAGE 113172 [empty string] [empty string] 0 2 0 0 MDNGHT_MIRAGE 40 Y [empty string] 942002 [empty string] 201227 6 DESERT_DREAMS 113173 [empty string] [empty string] 0 2 0 0 DESERT_DREAMS 49 Y [empty string] 942003 [empty string] 201227 CACHED false EXECUTIONTIME 0 SQL 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,5,8,6,9,14,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,5,8,6,9,14,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 201227 struct INTERNALLISTPRICE 22.99 INTERNALMARKDOWN false INTERNALPRICE 22.99 REG 22.99 SALE 22.99 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 AS_WISH 113168 [empty string] [empty string] 0 2 0 0 AS_WISH 28 Y [empty string] 941998 [empty string] 201227 2 CAT_NAP 113169 [empty string] [empty string] 0 2 0 0 CAT_NAP 37 Y [empty string] 941999 [empty string] 201227 3 UNDER_PALMS 113170 [empty string] [empty string] 0 2 0 0 UNDER_PALMS 53 Y [empty string] 942000 [empty string] 201227 4 HEAD_IN_CLOUDS 113171 [empty string] [empty string] 0 2 0 0 HEAD_IN_CLOUDS 43 Y [empty string] 942001 [empty string] 201227 5 MDNGHT_MIRAGE 113172 [empty string] [empty string] 0 2 0 0 MDNGHT_MIRAGE 40 Y [empty string] 942002 [empty string] 201227 6 DESERT_DREAMS 113173 [empty string] [empty string] 0 2 0 0 DESERT_DREAMS 49 Y [empty string] 942003 [empty string] 201227 CACHED false EXECUTIONTIME 0 SQL 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,5,8,6,9,14,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,5,8,6,9,14,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 201227 struct INTERNALLISTPRICE 22.99 INTERNALMARKDOWN false INTERNALPRICE 22.99 REG 22.99 SALE 22.99 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 AS_WISH 113168 [empty string] [empty string] 0 2 0 0 AS_WISH 28 Y [empty string] 941998 [empty string] 201227 2 CAT_NAP 113169 [empty string] [empty string] 0 2 0 0 CAT_NAP 37 Y [empty string] 941999 [empty string] 201227 3 UNDER_PALMS 113170 [empty string] [empty string] 0 2 0 0 UNDER_PALMS 53 Y [empty string] 942000 [empty string] 201227 4 HEAD_IN_CLOUDS 113171 [empty string] [empty string] 0 2 0 0 HEAD_IN_CLOUDS 43 Y [empty string] 942001 [empty string] 201227 5 MDNGHT_MIRAGE 113172 [empty string] [empty string] 0 2 0 0 MDNGHT_MIRAGE 40 Y [empty string] 942002 [empty string] 201227 6 DESERT_DREAMS 113173 [empty string] [empty string] 0 2 0 0 DESERT_DREAMS 49 Y [empty string] 942003 [empty string] 201227 CACHED false EXECUTIONTIME 0 SQL 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,5,8,6,9,14,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,5,8,6,9,14,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 201227 struct INTERNALLISTPRICE 22.99 INTERNALMARKDOWN false INTERNALPRICE 22.99 REG 22.99 SALE 22.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0
CHOOSE Size
- Description
- Specs
- Reviews
- Live Chat
Dreamscape Lounge Wear pants by Hello Mello are your companion in comfort. Unwind in the colorful custom designs and fresh style of their signature soft lounge wear. The stretch fabric moves and breathes with you in relaxed fit sizes. All wrapped up in matching travel totes - perfect for gift giving. Long pants have comfortable elastic waistband with adjustable drawstring.
- Fabric: 95% polyester/ 5% spandex
- S/M fits sizes 4-8; M/L fits sizes 8-12; L/XL fits sizes 12-16.
- Approximately 28 inch inseam for Medium size.
- Machine wash in cold with like colors; tumble dry low.
- Imported
No Reviews Yet!
-
Description
Dreamscape Lounge Wear pants by Hello Mello are your companion in comfort. Unwind in the colorful custom designs and fresh style of their signature soft lounge wear. The stretch fabric moves and breathes with you in relaxed fit sizes. All wrapped up in matching travel totes - perfect for gift giving. Long pants have comfortable elastic waistband with adjustable drawstring.
-
Specs
- Fabric: 95% polyester/ 5% spandex
- S/M fits sizes 4-8; M/L fits sizes 8-12; L/XL fits sizes 12-16.
- Approximately 28 inch inseam for Medium size.
- Machine wash in cold with like colors; tumble dry low.
- Imported
- Reviews
You may also like
