(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=%20SUMMER%20ESSENTIALS&categoryId=952&npage=2

SUMMER ESSENTIALS

SELECT p.*, vo.Item_Price1 as Item_Price1,vo.Item_Price2 ,vo.samefldALU FROM qc_products as p, qc_productInCategories as pc,qc_categories as c, qc_variantOptions AS vo, qc_variants AS v WHERE p.productId = pc.productId AND v.productId = p.productId and pc.categoryId=c.categoryId AND v.variantId = vo.variantId AND c.categoryId IN ( 952 ) AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 16,16
Shop By       
Shop By Colour:
Items 17-32 of 62
    MAIN ITEM
  • Dock & Bay Cooling Towel
    28 x 20"
    Checking inventory...
    Dock & Bay Cooling Towel
    $ 24.99
    Dock & Bay Cooling Towel
  • MAIN ITEM
  • Zone Naturals Chub Rub Stick
    Anti-Chafe Stick
    Checking inventory...
    Zone Naturals Chub Rub Stick
    $ 16.99
    Zone Naturals Chub Rub Stick
  • MAIN ITEM
  • Thigh Society High Rise Cooling Short
    S/M - 5X/6X
    Checking inventory...
    Thigh Society High Rise Cooling Short
    $ 39.99
    Thigh Society High Rise Cooling Short
  • MAIN ITEM
  • Thigh Society Regular Rise Cooling Short
    XS/S - 3X/4X
    Checking inventory...
    Thigh Society Regular Rise Cooling Short
    $ 39.99
    Thigh Society Regular Rise Cooling Short
  • MAIN ITEM
  • Chantelle Soft Stretch Short
    One Size
    Checking inventory...
    Chantelle Soft Stretch Short
    $ 54.99
    Chantelle Soft Stretch Short
  • MAIN ITEM
  • Victoriana Begonia Gown
    S - 2X
    Checking inventory...
    Victoriana Begonia Gown
    $ 49.99
    Reg. $ 69.99
    Victoriana Begonia Gown
  • MAIN ITEM
  • Victoriana Abbie Short Gown
    S - 2X
    Checking inventory...
    Victoriana Abbie Short Gown
    $ 49.99
    Reg. $ 69.99
    Victoriana Abbie Short Gown
  • MAIN ITEM
  • Wick'em Single Bra Liner
    Hot Weather Must Have
    Checking inventory...
    Wick'em Single Bra Liner
    $ 24.99
    Wick'em Single Bra Liner
  • MAIN ITEM
  • Wick'em Bra Liners 2-Pack
    Hot Weather Must Have
    Checking inventory...
    Wick'em Bra Liners 2-Pack
    $ 34.99
    Wick'em Bra Liners 2-Pack
  • MAIN ITEM
  • Wick'em Sensitive Skin Liner
    Sensitive Skin Suitable
    Checking inventory...
    Wick'em Sensitive Skin Liner
    $ 24.99
    Wick'em Sensitive Skin Liner
  • MAIN ITEM
  • UnderSummers AntiChafing Shorts
    S - 3X
    Checking inventory...
    UnderSummers AntiChafing Shorts
    $ 39.99
    UnderSummers AntiChafing Shorts
  • MAIN ITEM
  • Thigh Society Ultra High Rise Microfiber Short
    S/M - 3/4X
    Checking inventory...
    Thigh Society Ultra High Rise Microfiber Short
    $ 39.99
    Thigh Society Ultra High Rise Microfiber Short
  • MAIN ITEM
  • Thigh Society Regular Rise Microfiber Short
    S/M - 3/4X
    Checking inventory...
    Thigh Society Regular Rise Microfiber Short
    $ 39.99
    Thigh Society Regular Rise Microfiber Short
  • MAIN ITEM
  • Blue Sky 'Kitty' Shorts
    S - 2X
    Checking inventory...
    Blue Sky 'Kitty' Shorts
    $ 29.99
    Blue Sky 'Kitty' Shorts
  • MAIN ITEM
  • Blue Sky Hallie Shorts
    S - 2X
    Checking inventory...
    Blue Sky Hallie Shorts
    $ 39.99
    Blue Sky Hallie Shorts
  • MAIN ITEM
  • Nippie Skin Non-Adhesive Nipple Covers
    A - D, DD+
    Checking inventory...
    Nippie Skin Non-Adhesive Nipple Covers
    $ 39.99
    Nippie Skin Non-Adhesive Nipple Covers
Items 17-32 of 62