Whole Earth Provision Co. | Teva Teva Women's Sirra Sandals

Teva

Teva Women's Sirra Sandals

$69.95

Item # 1019240-BLK

Selected Color

Selected Size 10

product description The Teva Women's Sirra Sandals have super-sleek crossover straps and low-key, comfortable footbeds that make for a sandal that's flattering, elegant and adventure ready.

product specs

Water-ready polyester webbing stands up to abuse and dries quickly after getting wet
Ladder lock enclosure for a customized fit
Lightweight EVA-foam outsole
Rugged Durabrasion Rubber outsole stands up to abuse and supplies great traction

Injinji Injinji Unisex Liner Crew Socks $10.00

TOMS Women's Majorca Cutout Sandals Natural

Toms Shoes TOMS Women's Majorca Cutout Sandals $89.95

Tula Unisex Lifeguard Hat - L/XL Natural

TULA HATS Tula Unisex Lifeguard Hat - L/XL $37.95 $26.99
29% off

TOMS Women's Vintage Blue Large Herringbone Woven Alpargatas Vblu.Lgherb

Toms Shoes TOMS Women's Vintage Blue Large Herringbone Woven Alpargatas $54.95

Birkenstock Women's Mayari Oiled Leather Sandals Tobacco

BIRKENSTOCK Birkenstock Women's Mayari Oiled Leather Sandals $125.00

TOMS Women's Black Denim Majorca Cutout Sandals Blackdenim

Toms Shoes TOMS Women's Black Denim Majorca Cutout Sandals $89.95

TOMS Women's Classic Canvas Shoes - Grey Grey

Toms Shoes TOMS Women's Classic Canvas Shoes - Grey $49.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

TOMS Women's Black Suede Kelsey Booties Blk.Sd

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

TOMS Women's Mist Chambray Sunset Slip-Ons Mistslubchm

Toms Shoes TOMS Women's Mist Chambray Sunset Slip-Ons $64.95 $38.99
40% off

Teva Women's Terra Fi 4 Sandals Atlantic

Teva Teva Women's Terra Fi 4 Sandals $100.00

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

Birkenstock Papillio Women’s Lana Sandals Black

BIRKENSTOCK Birkenstock Papillio Women’s Lana Sandals $140.00

TOMS Women's Natural Metallic Woven Slip-Ons Nmetl.Wovn

Toms Shoes TOMS Women's Natural Metallic Woven Slip-Ons $54.95

Birkenstock Women's Mayari Oiled Leather Sandals Zinfandl

BIRKENSTOCK Birkenstock Women's Mayari Oiled Leather Sandals $125.00

Toms Women's Dust Gold Suede Marisa Sandals Dstgoldsuede

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

Vionic Women’s Kirra Backstrap Sandals Brnz

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

Klogs Footwear Klogs Women's Springfield Shoes $59.95

Ugg UGG Women's McKay Boots $149.95

TOMS Women's Taupe Gray Suede Paxton Slip-Ons Wrtaupe

Toms Shoes TOMS Women's Taupe Gray Suede Paxton Slip-Ons $79.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>Water-ready polyester webbing stands up to abuse and dries quickly after getting wet</li> <li>Ladder lock enclosure for a customized fit</li> <li>Lightweight EVA-foam outsole</li> <li>Rugged Durabrasion Rubber outsole stands up to abuse and supplies great traction</li>	[empty string]	[empty string]	54440	BLACK,	65432	TEVA	Teva	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Footwear &gt Sandals &gt Performance Sandals	[empty string]	[empty string]	[empty string]	596	[empty string]	31489716	[empty string]	69.95	69	69.95	[empty string]	18116-DEFAULT-l.jpg	69.95	[empty string]	18116-DEFAULT-m.jpg	Flatter your feet with Teva Women's Sirra Sandals	[empty string]	W/Sirra	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	50E	[empty string]	[empty string]	FALL_3	[empty string]	[empty string]	[empty string]	[empty string]	TEVA/DECKERS CORP	1	0	[empty string]	18116	18116	50-to-100	0.00	0	[empty string]	[empty string]	[empty string]	Teva Women's Sirra Sandals	The Teva Women's Sirra Sandals have super-sleek crossover straps and low-key, comfortable footbeds that make for a sandal that's flattering, elegant and adventure ready.	[empty string]	N	69.95	69.95	2875	0	10,	[empty string]	18116-DEFAULT-s.jpg	1000	1019240-BLK	127436	FOOTWEAR	SANDALS	PERFORMANCE SANDALS	0	2	[empty string]	18116-DEFAULT-xs.jpg	WOMENS	shop/teva-womens-sirra-sandals-127436	0	[empty string]	1019240-BLK	[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='127436' order by ID desc