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 0
SQL select * from tb_product_reviews where style_id in (0,1084180) and status='A'
 Olukai - Nohea Lole - Mens Shoes - Casual - Slip- On + Hover or Click to zoom
OLUKAI

Nohea Lole

style # NOHEA LOLE

$84.99

Fast & Free Shipping On Orders over $59.99

A special sunwashed canvas adds a new dimension to the Nohea family - fun, textural, and truly an OluKai original. The patented Drop-In Heel® design offers both a shoe or slide functionality. Hand-sewn seam stitching, elastic gore for customized fit and embroidered logo details. Due to the nature of the fit, we recommend ordering a half size down.
CLAY/TRENCHBLUE
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details