select p.products_model, m.manufacturers_name, m.manufacturers_display_name, p.products_image, IF(LEFT(TRIM(pd.products_name),1) <> '(',pd.products_name,SUBSTRING(pd.products_name,LOCATE(')', pd.products_name)+2)) AS products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_image
from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id
where p.products_status = 1
AND p.products_price > 0
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and m.display_on_listing = 1
and pd.language_id = '1'
and p2c.categories_id = '12713' and p.products_quantity > 0 order by p.products_quantity=0, p.products_image='cherries.jpg', p.products_image='', p.products_date_added desc, pd.products_name
Hosiery/Stockings
SORT CATEGORY BY
Total Products: 170
ST-DES042BLKOS_ep
(0)
Compare at $11.07$8.86($12.40 CAD)You save $2.21 (20% off)
ST-DES042BLKOSX_ep
(0)
Compare at $11.07$8.86($12.40 CAD)You save $2.21 (20% off)
ST-DES053BLKOS_ep
(0)
Compare at $12.84$10.27($14.38 CAD)You save $2.57 (20% off)
ST-DES053BLKOSX_ep
(0)
Compare at $12.84$10.27($14.38 CAD)You save $2.57 (20% off)
ST-DES056BLKOS_ep
(0)
Compare at $11.07$8.86($12.40 CAD)You save $2.21 (20% off)
ST-DES044BLKOS_ep
(0)
Compare at $11.07$8.86($12.40 CAD)You save $2.21 (20% off)
ST-DES044BLKOSX_ep
(0)
Compare at $11.07$8.86($12.40 CAD)You save $2.21 (20% off)
ST-DES056BLKOSX_ep
(0)
Compare at $11.07$8.86($12.40 CAD)You save $2.21 (20% off)
BW1918-RED_ep
(0)
$5.70($7.98 CAD)
BW747_ep
(0)
$11.41($15.97 CAD)
SE-3000-30-3_ep
(0)
Compare at $15.70$12.56($17.58 CAD)You save $3.14 (20% off)
SE-3000-60-3_ep
(0)
Compare at $33.93$27.14($38.00 CAD)You save $6.79 (20% off)
SE-3000-65-3_ep
(0)
Compare at $33.93$27.14($38.00 CAD)You save $6.79 (20% off)
SE-3000-70-3_ep
(0)
Compare at $35.00$28.00($39.20 CAD)You save $7.00 (20% off)
SE-3000-75-3_ep
(0)
Compare at $35.00$28.00($39.20 CAD)You save $7.00 (20% off)
SE-3001-05-3_ep
(0)
Compare at $19.99$15.99($22.39 CAD)You save $4.00 (20% off)
SE-3001-10-3_ep
(0)
Compare at $19.99$15.99($22.39 CAD)You save $4.00 (20% off)
SE-3001-25-3_ep
(0)
Compare at $23.57$18.86($26.40 CAD)You save $4.71 (20% off)
SE-3001-30-3_ep
(0)
Compare at $23.57$18.86($26.40 CAD)You save $4.71 (20% off)
SE-3001-35-3_ep
(0)
Compare at $24.27$19.42($27.18 CAD)You save $4.85 (20% off)
SE-3001-40-3_ep
(0)
Compare at $24.27$19.42($27.18 CAD)You save $4.85 (20% off)
SE-3001-50-3_ep
(0)
Compare at $31.41$25.13($35.18 CAD)You save $6.28 (20% off)
SE-3001-55-3_ep
(0)
Compare at $31.41$25.13($35.18 CAD)You save $6.28 (20% off)
BW411_ep
(0)
$2.73($3.82 CAD)
BW651_ep
(0)
$2.73($3.82 CAD)
BW718_ep
(0)
$2.73($3.82 CAD)
BW699W_ep
(0)
$1.76($2.46 CAD)
BW1907_ep
(0)
$14.27($19.98 CAD)
BW1996_ep
(0)
$14.27($19.98 CAD)
BW1996Q_ep
(0)
$21.14($29.60 CAD)
BW1909-NG_ep
(0)
$15.00($21.00 CAD)
BW2051_ep
(0)
$21.41($29.97 CAD)
BW2053_ep
(0)
$18.56($25.98 CAD)
BW2053Q_ep
(0)
$21.41($29.97 CAD)
BW2056_ep
(0)
$27.13($37.98 CAD)
BW700-PU_ep
(0)
$12.69($17.77 CAD)
BW555_ep
(0)
$1.76($2.46 CAD)
BW743_ep
(0)
$2.50($3.50 CAD)
BW1889_ep
(0)
$12.51($17.51 CAD)
BW1889Q_ep
(0)
$14.10($19.74 CAD)
BW1889Q_ep
(0)
$14.10($19.74 CAD)
BW1891_ep
(0)
$12.69($17.77 CAD)
BW1891Q_ep
(0)
$12.69($17.77 CAD)
BW1896_ep
(0)
$13.70($19.18 CAD)
BW1896Q_ep
(0)
$14.27($19.98 CAD)
BW1896Q_ep
(0)
$14.10($19.74 CAD)
BW2056RB_ep
(0)
$27.13($37.98 CAD)
BW2056RB_ep
(0)
$27.13($37.98 CAD)
BW2058_ep
(0)
$19.99($27.99 CAD)
BW699BLK_ep
(0)
$1.76($2.46 CAD)
BW1009-L_ep
(0)
$5.70($7.98 CAD)
BW1895_ep
(0)
$11.27($15.78 CAD)
BWB101_ep
(0)
$21.41($29.97 CAD)
BW1890Q_ep
(0)
$14.10($19.74 CAD)
BW1892_ep
(0)
$12.69($17.77 CAD)
BW1892Q_ep
(0)
$12.69($17.77 CAD)
BW1910_ep
(0)
$12.69($17.77 CAD)
BW1910Q_ep
(0)
$12.69($17.77 CAD)
BW2059Q_ep
(0)
$12.69($17.77 CAD)
OY-9023_ep
(0)
$5.70($7.98 CAD)
OY-H3240-1P_ep
(0)
$9.99($13.99 CAD)
OY-H3470_ep
(0)
$9.99($13.99 CAD)
OY-H3519P_ep
(0)
$9.99($13.99 CAD)
OY-R80877-2P_ep
(0)
$12.84($17.98 CAD)
OY-R80877P_ep
(0)
$12.84($17.98 CAD)
OY-R81057_ep
(0)
$15.70($21.98 CAD)
OY-R81057P_ep
(0)
$17.13($23.98 CAD)
BW1996Q-B_ep
(0)
$22.84($31.98 CAD)
BW2056RBQ_ep
(0)
$28.56($39.98 CAD)
BW1911-RED_ep
(0)
$6.84($9.58 CAD)
BW1912-RED_ep
(0)
$8.93($12.50 CAD)
BW1914-WH_ep
(0)
$8.56($11.98 CAD)
BW1915-RED_ep
(0)
$7.86($11.00 CAD)
BW1915-WH_ep
(0)
$8.93($12.50 CAD)
BW1918-WH_ep
(0)
$7.13($9.98 CAD)
BW1921-WH_ep
(0)
$7.13($9.98 CAD)
BW2044_ep
(0)
$15.87($22.22 CAD)
BW2051Q_ep
(0)
$19.99($27.99 CAD)
BW2165_ep
(0)
$21.41($29.97 CAD)
BW2165Q_ep
(0)
$22.84($31.98 CAD)
BW2167_ep
(0)
$29.99($41.99 CAD)
BW688SL_ep
(0)
$1.76($2.46 CAD)
BW1932-RED_ep
(0)
$8.93($12.50 CAD)
OY-H3240-1_ep
(0)
$8.56($11.98 CAD)
OY-H2133_ep
(0)
$5.70($7.98 CAD)
OY-9023P_ep
(0)
$4.76($6.66 CAD)
OY-H2142_ep
(0)
$7.13($9.98 CAD)
OY-H2144_ep
(0)
$7.13($9.98 CAD)
OY-H3439Q_ep
(0)
$11.41($15.97 CAD)
OY-H3470P_ep
(0)
$11.41($15.97 CAD)
OY-H3520P_ep
(0)
$11.41($15.97 CAD)
OY-R81044_ep
(0)
$11.41($15.97 CAD)
OY-R81044P_ep
(0)
$11.41($15.97 CAD)
BW1988_ep
(0)
$12.69($17.77 CAD)
BW1997_ep
(0)
$12.69($17.77 CAD)
BW2043_ep
(0)
$14.27($19.98 CAD)
BW2043Q_ep
(0)
$17.13($23.98 CAD)
BW2169_ep
(0)
$19.99($27.99 CAD)
BWB125Q_ep
(0)
$12.69($17.77 CAD)
BW738_ep
(0)
$2.73($3.82 CAD)
Displaying 1 to 100 (of 170 products)
WHERE CANADA AND USA BUY THEIR SEX TOYS ONLINE - USA WE SHIP YOUR ORDERS FROM OUR USA WAREHOUSES