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,1075530,1075530) and status='A'
 Chaco - Men's Z1 Classic - Mens Shoes - Athletic - Outdoor + Hover or Click to zoom
CHACO

Men's Z1 Classic

style # J105409

$104.99

Fast & Free Shipping On Orders over $59.99

The Classic series of Chaco sandal is streamlined, timeless and perfect for all of your outdoor adventures. This sandal comes standard with adjustable straps that custom fit to your foot, the podiatrist-certified LUVSEAT™ PU footbed for all-day comfort and support, and ChacoGrip™ rubber for the best performing Classic outsole to date. Go ahead, take the first step into comfort and performance.
STITCHSLATE
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details