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,1073536,1073536) and status='A'
 Chaco - Men's Z/2 Classic - Mens Shoes - Casual - Sandal + Hover or Click to zoom
CHACO

Men's Z/2 Classic

style # J105465

$104.99

Fast & Free Shipping On Orders over $59.99

Streamlined and dependable since 1989, Chaco`s Classic series is comprised of only 8 component parts, making for the simple, timeless sandal design that made the Chaco name. Every pair comes standard with adjustable straps that custom-fits to your foot, a toe-loop for additional forefoot control, plus the podiatrist-certified LUVSEAT™ PU footbed for all-day comfort and support. Now featuring ChacoGrip™ rubber for the best performing Classic outsole to date. Experience the Classic Sandal like never before.
FILMSTRIP/COP
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details