Whole Earth Provision Co. | HOT CHILLYS Hot Chillys Women's Micro-Elite Chamois Print Tights

HOT CHILLYS

Hot Chillys Women's Micro-Elite Chamois Print Tights

$75.00

Item # HC9928P

Select Color

Hot Chillys Women's Micro-Elite Chamois Print Tights ICYPEA_417

Hot Chillys Women's Micro-Elite Chamois Print Tights DIAMON_690

Hot Chillys Women's Micro-Elite Chamois Print Tights HZSTRI_675

Select Size XS S M L XL

product description Micro-Elite Chamois has been the leader in body fit, technical performance thermal base layer for decades. These thermal Hot Chillys Women's Micro-Elite Chamois Print Tights are engineered with intimately blended fibers with specific attributes to continuously keep you warm, comfortable and dry. These winter thermal leggings are also knit in a single smooth face and napped back for easy layering and extra warmth without adding bulk. The body fit design of these thermal tights for women allows full range of motion without any restrictions.

Fit tip: These winter thermal leggings feature a snug, body fitting silhouette for exceptional moisture management. If you are in-between sizes - order up one size.

product specs

Midweight warmth, body fit
Smooth wide waistband
No side seams
Sublimated prints
Moisture transfer fibers wick away moisture from your skin
Bio-Silver Antimicrobial properties inhibit the growth of odor-causing bacteria
4-way stretch
UPF 30 protection

Teva Teva Women's Sirra Sandals $69.95

Toms Women's Dust Gold Suede Marisa Sandals Dstgoldsuede

Toms Shoes Toms Women's Dust Gold Suede Marisa Sandals $89.95

TOMS Women's Seaglass Torn Denim Espadrilles Apargatas Denim

Toms Shoes TOMS Women's Seaglass Torn Denim Espadrilles Apargatas $59.00

Ugg UGG Women's McKay Boots $149.95

TOMS Women's Black Suede Kelsey Booties Blk.Sd

Toms Shoes TOMS Women's Black Suede Kelsey Booties $89.95

Vionic Women’s Kirra Backstrap Sandals Brnz

VIONIC Vionic Women’s Kirra Backstrap Sandals $99.95 $69.99
30% off

TULA HATS Tula Women's Elegant Ranch Hat $37.95

Ugg UGG Women's Classic Short II Boots $159.95

Birkenstock Papillio Women’s Lana Sandals Black

BIRKENSTOCK Birkenstock Papillio Women’s Lana Sandals $140.00

Tula Women's Ranch Lattice Hat - L Straw

TULA HATS Tula Women's Ranch Lattice Hat - L $37.95

TULA HATS Tula Unisex Pecos Hat - XXL $37.95

TULA HATS Tula Unisex Pecos Hat - S/M $37.95

Birkenstock Women's Mayari Sandals Zinfandl

BIRKENSTOCK Birkenstock Women's Mayari Sandals $125.00

TOMS Women's Majorca Cutout Sandals Natural

Toms Shoes TOMS Women's Majorca Cutout Sandals $89.95

TOMS Women’s Black on Black Heritage Canvas Cupsole Alpargatas Blk.Canv.Blksole

Toms Shoes TOMS Women’s Black on Black Heritage Canvas Cupsole Alpargatas $54.95

Teva Women's Terra Fi 4 Sandals Atlantic

Teva Teva Women's Terra Fi 4 Sandals $100.00

Birkenstock Women's Mayari Sandals Tobacco

BIRKENSTOCK Birkenstock Women's Mayari Sandals $125.00

TOMS Women’s Birch Canvas TRVL LITE Slip-On Shoes Birchcanv

Toms Shoes TOMS Women’s Birch Canvas TRVL LITE Slip-On Shoes $69.95

*More Colors Available* DAKINE Dakine Women’s Lola Handbag $35.00 $24.99
29% off

TOMS Women's Classic Canvas Shoes - Black on Black Black.Black

Toms Shoes TOMS Women's Classic Canvas Shoes - Black on Black $49.95

Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review

1 - 0 of 0

No reviews have been written for this product.
Be the first one! –

query

RESULTSET

query
	ADDITIONAL_DESCRIPTION	AGERANGE	ALTIMAGERECORDCOUNT	ATTR1ID	ATTR1LIST	ATTR2ID	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	DESCRIPTION	FAMLIST	GENDER	GOOGLEPRODUCTTAXONOMY	HEXLIST	ID	INSTORE_ONLY	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	KEYWORDS	LARGEPICTURE	LISTPRICE	LOWESTPRICE	MEDIUMPICTURE	METADESC	METATAGS	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	ORIGBRAND	OVERALLQOH	OVERALL_RATING	PAGETITLE	PICTUREID	PICTURE_ID	PRICERANGE	PRODREVIEWSAVERAGE	PRODREVIEWSRECORDCOUNT	QUANTITYONHANDSUM	QUANTITYSOLDSUM	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SCALEID	SHIP_SURCHARGE	SIZELIST	SIZING_IMAGE_FILE	SMALLPICTURE	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TINYPICTURE	TYP	URL	USEPACKAGE	VIDEO	WEBSTYLE	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	<li>Midweight warmth, body fit</li> <li>Smooth wide waistband</li> <li>No side seams</li> <li>Sublimated prints</li> <li>Moisture transfer fibers wick away moisture from your skin</li> <li>Bio-Silver Antimicrobial properties inhibit the growth of odor-causing bacteria</li> <li>4-way stretch</li> <li>UPF 30 protection</li>	[empty string]	[empty string]	59625	ICYPEA_417,DIAMON_690,HZSTRI_675,	[empty string]	HOT CHILLYS	HOT CHILLYS	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Underwear &gt Baselayers	[empty string]	[empty string]	[empty string]	596	[empty string]	29296213	[empty string]	75	75	75	[empty string]	38842-DEFAULT-l.jpg	75	[empty string]	38842-DEFAULT-m.jpg	Experience a full range of motion without any restrictions in these Hot Chillys Women's Micro-Elite Chamois Print Tights.	[empty string]	W/ MICRO-ELITE CHAMOIS PRINT LEGGING	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	PIN	[empty string]	[empty string]	A	24C	[empty string]	[empty string]	FALL_3	[empty string]	[empty string]	[empty string]	[empty string]	HOT CHILLYS	73	0	[empty string]	38842	38842	50-to-100	0.00	0	[empty string]	[empty string]	[empty string]	Hot Chillys Women's Micro-Elite Chamois Print Tights	Micro-Elite Chamois has been the leader in body fit, technical performance thermal base layer for decades. These thermal Hot Chillys Women's Micro-Elite Chamois Print Tights are engineered with intimately blended fibers with specific attributes to continuously keep you warm, comfortable and dry. These winter thermal leggings are also knit in a single smooth face and napped back for easy layering and extra warmth without adding bulk. The body fit design of these thermal tights for women allows full range of motion without any restrictions. <br><br> Fit tip: These winter thermal leggings feature a snug, body fitting silhouette for exceptional moisture management. If you are in-between sizes - order up one size.	[empty string]	N	75	75	60756	0	L,M,S,XL,XS,	[empty string]	38842-DEFAULT-s.jpg	1000	HC9928P	137161	UNDERWEAR	BASELAYERS	EMPTY	0	0	[empty string]	38842-DEFAULT-xs.jpg	WOMENS	shop/hot-chillys-womens-micro-elite-137161	0	[empty string]	HC9928P	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * from [dbo].[web_all_products] WHERE style_id='137161' order by ID desc