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,1088765,1088765) and status='A'
 Z Supply - The Long Sleeve Camo Tee | Z Supply | Women's T- Shirts - Apparel - T- Shirts + Hover or Click to zoom
Z SUPPLY

The Long Sleeve Camo Tee | Z Supply | Women's T- Shirts

style # ZT155078

$36.99 Compare at $42.00

Fast & Free Shipping On Orders over $59.99

Do you have a camo obsession? The Z Supply Long Sleeve Camo Tee is soft, comfy and cute! Your favorite pocket tee now available in a long sleeve. Made from our ultra-soft hacci fabric, this tee features a curved v-neck, an unfinished slouchy chest pocket and a curved hem. FABRIC 52% Cotton 40% Polyester 8% Rayon CARE Our Signature Burnout garments are specially treated for perfectly imperfect variations in color that will evolve with wear and washing. To care, hand wash or machine wash cold, gentle cycle, and lay flat to dry, as a heated dryer will accelerate the aging process. Wash before wearing. FIT Relaxed Fit. Model is wearing Size S SPECS Bust: 36` Length: 28`
XS S M L XL
CAMOBLK CAMO GREEN
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details