(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Bridal_Collection&categoryId=484&shop=Products

Bridal Collection

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 ( 484 ) AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
Shop By       
Shop By Colour:
Items 1-16 of 53
    MAIN ITEM
  • Blush Loveswept Lace Slip
    S/M - L/XL
    Checking inventory...
    Blush Loveswept Lace Slip
    $ 54.99
    Blush Loveswept Lace Slip
  • MAIN ITEM
  • Blush Loveswept Lace Bikini
    S - XL
    Checking inventory...
    Blush Loveswept Lace Bikini
    $ 34.99
    Blush Loveswept Lace Bikini
  • MAIN ITEM
  • Felina Conturelle Delicate Underwire
    E - G Cups
    Checking inventory...
    Felina Conturelle Delicate Underwire
    $ 129.99
    Felina Conturelle Delicate Underwire
  • MAIN ITEM
  • Felina Conturelle Delicate Boyshorts
    M - XL
    Checking inventory...
    Felina Conturelle Delicate Boyshorts
    $ 74.99
    Felina Conturelle Delicate Boyshorts
  • MAIN ITEM
  • Felina Conturelle Sentiments Bra
    E - H Cups
    Checking inventory...
    Felina Conturelle Sentiments Bra
    $ 139.99
    Felina Conturelle Sentiments Bra
  • MAIN ITEM
  • Felina Conturelle Sentiments Brief
    M - 3X
    Checking inventory...
    Felina Conturelle Sentiments Brief
    $ 74.99
    Felina Conturelle Sentiments Brief
  • MAIN ITEM
  • Coquette Chiffon Robe
    Regular and Plus Sizing
    Checking inventory...
    Coquette Chiffon Robe
    $ 59.99
    Coquette Chiffon Robe
  • MAIN ITEM
  • Coquette Lace Babydoll
    Checking inventory...
    Coquette Lace Babydoll
    $ 25.00
    Reg. $ 59.99
    Coquette Lace Babydoll
  • MAIN ITEM
  • Fantasie Sofia Brief
    S - 2X
    Checking inventory...
    Fantasie Sofia Brief
    $ 59.99
    Fantasie Sofia Brief
  • MAIN ITEM
  • Cinema Etoile Babydoll & Robe
    1X - 3X
    Checking inventory...
    Cinema Etoile Babydoll & Robe
    $ 134.99
    Cinema Etoile Babydoll & Robe
  • MAIN ITEM
  • Empreinte Maya Underwire Full Cup
    E - G Cups
    Checking inventory...
    Empreinte Maya Underwire Full Cup
    $ 149.99
    Empreinte Maya Underwire Full Cup
  • MAIN ITEM
  • Empreinte Maya Brief
    M - 2X
    Checking inventory...
    Empreinte Maya Brief
    $ 69.99
    Empreinte Maya Brief
  • MAIN ITEM
  • Fantasy Antoinette Pearls & Lace SideTie Panty Set
    One Size Fits Most
    Checking inventory...
    Fantasy Antoinette Pearls & Lace SideTie Panty Set
    $ 45.99
    Fantasy Antoinette Pearls & Lace SideTie Panty Set
  • MAIN ITEM
  • Simone Perele Amour Bra
    D - G Cups
    Checking inventory...
    Simone Perele Amour Bra
    $ 40.00
    Reg. $ 154.99
    Simone Perele Amour Bra
  • MAIN ITEM
  • Simone Perele Amour Brief
    S - 2X
    Checking inventory...
    Simone Perele Amour Brief
    $ 10.00
    Reg. $ 64.99
    Simone Perele Amour Brief
  • MAIN ITEM
  • Leg Avenue Lace Bra Set
    S - L
    Checking inventory...
    Leg Avenue Lace Bra Set
    $ 39.99
    Leg Avenue Lace Bra Set
Items 1-16 of 53