query
RESULTSET
query
  AGE_RANGE CUSTOMER_ID CUSTOM_RATING_1 CUSTOM_RATING_2 CUSTOM_RATING_3 DTE EMAIL_ADDRESS FULL_NAME GENDER HOW_LONG LOCATION NICKNAME OVERALL_RATING PRODUCT_REVIEW_ID REVIEW REVIEW_TITLE STATE_REGION STATUS STYLE_ID YOUR_CITY
CACHED false
EXECUTIONTIME 15
SQL select * from tb_product_reviews where style_id in (0,1090860,1090860) and status='A'
 Keen - Keen Uneek - Mens Shoes - Casual - Sandal + Hover or Click to zoom
KEEN

Keen Uneek

style # 1020781

$99.99

Fast & Free Shipping On Orders over $59.99

UNEEK adapts to your feet for the perfect fit, with innovative two-cord construction and a free-moving cord junction that provides freedom of movement, security and structure. The lightweight midsole delivers durability and comfort, while the higher-traction rubber outsole keeps your step secure. Two cords and a sole—now that`s UNEEK. Features include: Cleansport NXT™ for natural odor control, Microfiber footbed cover, Microfiber heel back, Polyester braided cord with nylon core for increased strength, Razor siping for improved ground traction, and secure fit lace capture system. We reccomend ordering a half size up.
9 9.5 10 10.5 11 11.5 12 13 14
BLUE/GREY
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details