Whole Earth Provision Co. | AQUA SHERE Aqua Sphere Kaiman Swim Goggles

AQUA SHERE

Aqua Sphere Kaiman Swim Goggles - Amber Lens

$19.95

Item # 171120

Selected Size L

Selected Color

Aqua Sphere Kaiman Swim Goggles - Amber Lens AMBER

product description

Enjoy 180-degree vision in a traditional shape with the Aqua Sphere Kaiman Swim Goggles - Amber Lens featuring patented curved lens technology. The Kaiman has a proprietary Softeril material and easy-adjust side buckles to help provide a comfortable, just-right fit.

product specs

Amber lens / Black Frame
Adult fit
Easy-adjust buckle system
Plexisol lens
100% UVA and UVB protection
180-degree distortion-free visibility
Scratch-resistant coating
Anti-fog coating

Tula Women's Ranch Lattice Hat - S Straw

TULA HATS Tula Women's Ranch Lattice Hat - S $35.95

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

Tula Unisex Fedora Hat Multi Band - Small Multi_band

TULA HATS Tula Unisex Fedora Hat Multi Band - Small $35.95

Klogs Footwear Women's Springfield Wide Non-Slip Shoes Black

Klogs Footwear Klogs Footwear Women's Springfield Wide Non-Slip Shoes $59.95 $54.95
8% off

Tula Unisex Gardener Lattice Hat - S/M Straw

TULA HATS Tula Unisex Gardener Lattice Hat - S/M $37.95

*More Colors Available* DAKINE Dakine Women’s Lola Handbag $24.99 to $35.00

Tula Women's Carmel Hat Cranberry Band Cranberryband

TULA HATS Tula Women's Carmel Hat Cranberry Band $37.95

Tula Women's Carmel Hat Black Band Blkband

TULA HATS Tula Women's Carmel Hat Black Band $37.95

Klogs Footwear Klogs Women's Springfield Shoes $59.95 $54.95
8% off

ECCO ECCO Women's Yucatan Sandals $130.00

Tula Women's Ranch Lattice Hat - L Straw

TULA HATS Tula Women's Ranch Lattice Hat - L $37.95 $35.95
5% off

*More Colors Available* DAKINE Dakine Women’s Jojo Handbag $25.00 $17.99
28% off

Teva Women's Mush Mandalyn Wedge Ola 2 Sandals Black

Teva Teva Women's Mush Mandalyn Wedge Ola 2 Sandals $30.00

Injinji Injinji Unisex Liner Crew Socks $10.00

TULA HATS Tula Unisex Pecos Hat - L/XL $37.95

TULA HATS Tula Unisex Pecos Hat - XXL $37.95

ECCO ECCO Women's Yucatan Sandals $130.00

Tula Unisex Gardener Lattice Hat - L/XL Straw

TULA HATS Tula Unisex Gardener Lattice Hat - L/XL $37.95

TULA HATS Tula Women's Elegant Ranch Hat $37.95

Tula Unisex Lifeguard Hat - L/XL Natural

TULA HATS Tula Unisex Lifeguard Hat - L/XL $37.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	<ul> <li>Amber lens / Black Frame</li> <li>Adult fit</li> <li>Easy-adjust buckle system</li> <li>Plexisol lens</li> <li>100% UVA and UVB protection</li> <li>180-degree distortion-free visibility</li> <li>Scratch-resistant coating</li> <li>Anti-fog coating</li> </ul>	[empty string]	[empty string]	5113	AMBER,	[empty string]	AQUA SHERE	AQUA SHERE	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Swimwear	[empty string]	[empty string]	[empty string]	211	[empty string]	22108731	[empty string]	19.95	19	19.95	[empty string]	25706-DEFAULT-l.jpg	19.95	[empty string]	25706-DEFAULT-m.jpg	Enjoy 180-degree vision with the Aqua Sphere Kaiman Swim Goggles - Amber Lens featuring curved lens technology. The proprietary Softeril material and easy-adjust side buckles help provide a just-right fit.	[empty string]	KAIMAN GOGGLE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ODDBALL	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	60H	[empty string]	[empty string]	FALL_1	[empty string]	[empty string]	[empty string]	[empty string]	AQUA SPHERE	9	0	[empty string]	25706	25706	15-to-20	0.00	0	[empty string]	[empty string]	[empty string]	Aqua Sphere Kaiman Swim Goggles - Amber Lens	<p>Enjoy 180-degree vision in a traditional shape with the Aqua Sphere Kaiman Swim Goggles - Amber Lens featuring patented curved lens technology. The Kaiman has a proprietary Softeril material and easy-adjust side buckles to help provide a comfortable, just-right fit.</p>	[empty string]	N	19.95	19.95	281	0	3_LG,	[empty string]	25706-DEFAULT-s.jpg	20	171120	40357	SWIMWEAR	EMPTY	EMPTY	0	2	[empty string]	25706-DEFAULT-xs.jpg	WOMENS	shop/aqua-sphere-kaiman-swim-goggle-40357	0	[empty string]	171120	[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='40357' order by ID desc