Teva

Teva Women's Voya Flip Leather Sandals

$44.95

Item # 1106867

This item ships for FREE
query
RESULTSET
query
  ATTR2 ATTR2_ENTRY_ID ORIGATTR2 QOH SKU_ID
1 [empty string] [empty string] [empty string] 86 536734
CACHED false
EXECUTIONTIME 422
SQL SELECT distinct (b.attr2) as origAttr2, max(CASE WHEN b.attr2_alias IS NULL OR RTRIM(LTRIM(b.attr2_alias)) = '' THEN b.attr2 ELSE b.attr2_alias END) as attr2, max(a.sku_id) as sku_id, max(b.attr2_entry_id) as attr2_entry_id, sum(e.qoh+e.qc) as qoh FROM tb_skus a LEFT JOIN tb_attr2_entries b WITH (NOLOCK) ON (b.attr2_entry_id = a.attr2_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) WHERE (a.style_id IN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = '1106867' and web_style > '' and web_style is not null ) or a.style_id =?) AND isNull(a.sell_web,'Y') = 'Y' AND e.store_id in(98,8,9,2,5,7,6,3,4) --AND e.qoh > 1 GROUP BY b.attr2 HAVING sum(e.qoh+e.qc) > 1
SQLPARAMETERS
array
1 141847
Teva Women's Voya Flip Leather Sandals CHIPMNK_CPM Teva Women's Voya Flip Leather Sandals BLACK_BLK
6 7 8 Small Med
Add to Cart Find in Store Add to Wish List

product description Teva Women's Voya Flip Leather Sandals are just the thing to slip on for your next outdoor adventure. They're carefully designed to suit the needs of anyone who anticipates spending a lot of time on her feet. Although premium leather uppers present the rough, durable look, cozy microfiber lining and cushy footbeds and midsoles provide the soothing comfort and optimized support you need to get through your day without foot soreness. Luxury style meets lightweight to make the a great pair of beach sandals.
product specs
  • A premium upper of rich, supple leather for a luxe look and feel
  • Every piece of leather is sourced from tanneries certified by Leather Working Group, whose mission is to promote sustainable and appropriate environmental business practices within the leather industry
  • Microfiber lining for a soft and more premimum feel against the skin
  • Mush® topsole cushions and forms to your foot for amazing comfor
  • A lightweight EVA-foam outsole keeps you light on your feet
  • Half pair weight for size W7/M9: 3.0oz
Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review
Very Poor Poor Average Very Good Excellent
Name: *
Location:
Review Title:
Review: * (maximum 1000 characters)
1 - 0 of 0

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


FREE SHIPPING* ON ORDERS OVER $20.00
My Bag (0)
Menu

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>A premium upper of rich, supple leather for a luxe look and feel</li> <li>Every piece of leather is sourced from tanneries certified by Leather Working Group, whose mission is to promote sustainable and appropriate environmental business practices within the leather industry</li> <li>Microfiber lining for a soft and more premimum feel against the skin</li> <li>Mush&#174; topsole cushions and forms to your foot for amazing comfor</li> <li>A lightweight EVA-foam outsole keeps you light on your feet</li> <li>Half pair weight for size W7/M9: 3.0oz</li> [empty string] [empty string] 61714 CHIPMNK_CPM,BLACK_BLK, [empty string] TEVA Teva CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Footwear &gt Sandals &gt Flip-Flops [empty string] [empty string] [empty string] 596 [empty string] 39859440 [empty string] 44.95 44 44.95 [empty string] 42215-DEFAULT-l.jpg 44.95 [empty string] 42215-DEFAULT-m.jpg Transition into summer adventures with comfort and deluxe style in Teva Women's Voya Flip Leather Sandals. [empty string] W/Voya Flip Leather N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 50G [empty string] [empty string] SPRING [empty string] [empty string] [empty string] [empty string] TEVA/DECKERS CORP 85 0 [empty string] 42215 42215 25-to-50 0.00 0 [empty string] [empty string] [empty string] Teva Women's Voya Flip Leather Sandals Teva Women's Voya Flip Leather Sandals are just the thing to slip on for your next outdoor adventure. They're carefully designed to suit the needs of anyone who anticipates spending a lot of time on her feet. Although premium leather uppers present the rough, durable look, cozy microfiber lining and cushy footbeds and midsoles provide the soothing comfort and optimized support you need to get through your day without foot soreness. Luxury style meets lightweight to make the a great pair of beach sandals. [empty string] N 44.95 44.95 2903 0 6,7,8,Med,Small, [empty string] 42215-DEFAULT-s.jpg 1000 1106867 141847 FOOTWEAR SANDALS FLIP-FLOPS 0 2 [empty string] 42215-DEFAULT-xs.jpg WOMENS shop/teva-womens-voya-flip-leather--141847 0 [empty string] 1106867 [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 0
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='141847' order by ID desc