SELECT p2c.categories_id, c.parent_id FROM products_to_categories p2c, categories c WHERE p2c.categories_id = c.categories_id AND p2c.products_id AND c.parent_id IN (637,1602) AND p2c.products_id = '6743' AND c.categories_id != 1620 SELECT p.products_id FROM products p, products_to_categories p2c1, products_to_categories p2c2, categories c WHERE p.products_id = p2c1.products_id AND p.products_id = p2c2.products_id AND p2c1.categories_id != p2c2.categories_id AND p2c2.categories_id = c.categories_id AND p2c1.categories_id = '1551' AND p2c2.categories_id NOT IN (1551) AND c.parent_id NOT IN (1551) AND p.products_id != '6743' AND p.products_status = 1 GROUP BY p.products_id ORDER BY RAND()


Stephanie Lily Phone Wallet with RFID Protection

Stephanie Lily Phone Wallet with RFID Protection

Stephanie Lily Phone Wallet with RFID Protection

$72.00

Chestnut (CHS) Black (BLK)
 
 
 

Carry-all phone wallet with a detachable wristlet holds multiple phone versions (including iPhone 6) as well as cards and cash.

Features: Detachable wristlet, Snap closure, 1 open window phone slot, 3 card slots, 1 ID window, 1 flat slide pocket, 1 zipper pocket on the back side.

5.625 x 3.125 x 0.75

Style # 449

Collection code # STLK