Whole Earth Provision Co. | KAVU KAVU Women's Simone Dress

KAVU

KAVU Women's Simone Dress

$50.00 $39.9920% off

Item # 681

Select Size S L

Selected Color

product description

A stylish print keeps your look fresh when you're wearing the KAVU Women's Simone Dress with a scoop neck and keyhole styling. Keep your cool during hot summer days with the silky feel of one hundred percent viscose woven fabric. The skirt includes front pockets and falls mid-thigh. This dress may become your summer go-to for shopping trips, vacations, or lunches with friends.

product specs

Dress length: 36in
Fabric: 4oz 100% viscose woven printed pattern

Pistil Women's Suzette Wide Brim Fedora Naturl_nat

PISTIL Pistil Women's Suzette Wide Brim Fedora $42.00

Toms Shoes TOMS Women's Classic Canvas Shoes $49.95

Birkenstock Women's Cotton Structure Socks Peppercorn

BIRKENSTOCK Birkenstock Women's Cotton Structure Socks $18.00 $12.99
28% off

Birkenstock Women's Gizeh Essentials EVA Sandals Lavender

BIRKENSTOCK Birkenstock Women's Gizeh Essentials EVA Sandals $39.95

Darn Tough Women's Vertex No Show Tab Ultra Light Cushion Socks Lightblue

DARN TOUGH Darn Tough Women's Vertex No Show Tab Ultra Light Cushion Socks $16.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

KEEN KEEN Women's Whisper Sandals $90.00 $53.99
40% off

KEEN KEEN Women's Whisper Sandals $90.00

TULA HATS Tula Women's Elegant Ranch Hat $37.95

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

TOMS Women's Dark Amber Suede Kelli Flats Darkamber

Toms Shoes TOMS Women's Dark Amber Suede Kelli Flats $79.95 $39.99
50% off

KEEN Women's UNEEK Water Sandals Gargoyle

KEEN KEEN Women's UNEEK Water Sandals $100.00 $64.99
35% off

Tula Women's Ranch Lattice Hat - L Straw

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

Birkenstock Women's Mayari Birkibuc Sandals Anthracite

BIRKENSTOCK Birkenstock Women's Mayari Birkibuc Sandals $99.95

Birkenstock Women's Mayari Oiled Leather Sandals Bluelth

BIRKENSTOCK Birkenstock Women's Mayari Oiled Leather Sandals $125.00

TULA HATS Tula Unisex Pecos Hat - XXL $37.95

TOMS Women's Black Arrow Embroidered Mesh Classics Alpargatas Blk.Arw.Mesh

Toms Shoes TOMS Women's Black Arrow Embroidered Mesh Classics Alpargatas $59.95

TOMS Women's Seaglass Torn Denim Espadrilles Apargatas Denim

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

Birkenstock Women's London Suede Shoes Taupesuede

BIRKENSTOCK Birkenstock Women's London Suede Shoes $170.00

Birkenstock Women’s Celina II Shoes Blacksd

BIRKENSTOCK Birkenstock Women’s Celina II Shoes $120.00

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	<ul> <li>Dress length: 36in</li> <li>Fabric: 4oz 100% viscose woven printed pattern</li> </ul>	[empty string]	[empty string]	58487	BLACKDASH,	[empty string]	KAVU	KAVU	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Dresses	[empty string]	[empty string]	[empty string]	2271	[empty string]	25311037	[empty string]	50	39	39.99	[empty string]	36608-DEFAULT-l.jpg	50	[empty string]	36608-DEFAULT-m.jpg	The breezy KAVU Women's Simone Dress is semi-fitted and hits just above the knee. It’s perfect for summer days. Get one before temps rise.	[empty string]	W/ S19 Simone Dress	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	PIN	[empty string]	ACTIVE	[empty string]	72M	[empty string]	[empty string]	FALL_3	[empty string]	[empty string]	[empty string]	N	KAVU	3	0	[empty string]	36608	36608	25-to-50	0.00	0	[empty string]	[empty string]	[empty string]	KAVU Women's Simone Dress	<p>A stylish print keeps your look fresh when you're wearing the KAVU Women's Simone Dress with a scoop neck and keyhole styling. Keep your cool during hot summer days with the silky feel of one hundred percent viscose woven fabric. The skirt includes front pockets and falls mid-thigh. This dress may become your summer go-to for shopping trips, vacations, or lunches with friends.</p>	[empty string]	Y	39.99	39.99	2860	0	L,S,	[empty string]	36608-DEFAULT-s.jpg	1000	681	135383	DRESSES	EMPTY	EMPTY	0	[empty string]	[empty string]	36608-DEFAULT-xs.jpg	WOMENS	shop/kavu-womens-simone-dress-135383	0	[empty string]	681	[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='135383' order by ID desc