Instyle New York | Cocktail Dresses, Evening Dresses, Special Occassion Dressses, Bridesmaids Dresses, Outerwear, Daywear , Prom Dresses

WOMENS APPAREL

SHOP BY CATEGORIES
- Dresses
- Tops
- Bottoms
- Jumpsuits
- Outerwear
- Accessories
  - Shawls
  - SHOP BY DESIGNERS
    - Basix Black Label
      - Womens Apparel
        Dresses
        Evening Dresses
        Elegant Fully Covered Dresses
        Prom Dresses
        Cocktail Dresses
        MOB Gowns
        Wedding Dresses
        Tops
        Shirts
        Bottoms
        Pants
        Skirts
        Shorts
    - Diana Rosh / Charm Furs
      - Womens Apparel
        Outerwear
        Coats
        Jackets
        Accessories
        Shawls
    - Issue New York
    - Storybook Knits
      - Womens Apparel
        Novelty Sweaters
        Southwest Themes
        Novelty Themes
        Animal Themes
        Fall Themes
        Floral Themes
        Holiday Themes
    - Tempo Paris
      - Womens Apparel
        Dresses
        Daywear Dresses
        Tops
        Blouses
        Shirts
        Sweaters
        Bottoms
        Pants
        Skirts
        Outerwear
        Coats
        Vests
        Jackets

D8257L
D8257L
$650.00
$295.00 $325.00 (≈% OFF)

D8063L
D8063L
$595.00
$195.00 $295.00 (≈% OFF)

D8057L
D8057L
$695.00
$295.00 $345.00 (≈% OFF)

D8045L
D8045L
$595.00
$195.00 $285.00 (≈% OFF)

D8043L
D8043L
$695.00
$295.00 $275.00 (≈% OFF)

D8033L
D8033L
$695.00
$175.00 $425.00 (≈% OFF)

Embroidred cocktail dress by basix black label
D7992A
$395.00
$135.00 $195.00 (≈% OFF)

D7889L
D7889L
$900.00
$495.00 $450.00 (≈% OFF)

D7818L
D7818L
$795.00
$195.00 $395.00 (≈% OFF)

D7763L
D7763L
$695.00
$195.00 $345.00 (≈% OFF)

D7754L
D7754L
$495.00
$195.00 $245.00 (≈% OFF)

D7745A
D7745A
$590.00
$145.00 $295.00 (≈% OFF)

D7733L
D7733L
$595.00
$195.00 $295.00 (≈% OFF)

D7664L
D7664L
$995.00
$195.00 $495.00 (≈% OFF)

D7659L
D7659L
$650.00
$195.00 $325.00 (≈% OFF)

D7618A
D7618A
$490.00
$145.00 $245.00 (≈% OFF)

D7524A
D7524A
$390.00
$125.00 $195.00 (≈% OFF)

D7506A
D7506A
$495.00
$95.00 $245.00 (≈% OFF)

sleeveless cocktail dress by basix black label
D7448A
$395.00
$175.00 $195.00 (≈% OFF)

D7389L
D7389L
$595.00
$195.00 $295.00 (≈% OFF)

D7319L
D7319L
$695.00
$195.00 $345.00 (≈% OFF)

D7292LB
D7292LB
$995.00
$395.00 $495.00 (≈% OFF)

D7278L
D7278L
$795.00
$295.00 $395.00 (≈% OFF)

D7162L
D7162L
$595.00
$195.00 $295.00 (≈% OFF)

D7125LB
D7125LB
$690.00
$195.00 $345.00 (≈% OFF)

Basix Black Label Sleeveless Ballgown
D7079L
$1,190.00
$695.00 $595.00 (≈% OFF)

D6934A
D6934A
$450.00
$145.00 $225.00 (≈% OFF)

D6903L
D6903L
$395.00
$145.00 $195.00 (≈% OFF)

D6898L
D6898L
$595.00
$195.00 $295.00 (≈% OFF)

D6893L
D6893L
$990.00
$295.00 $495.00 (≈% OFF)

D6886A
D6886A
$295.00
$95.00 $165.00 (≈% OFF)

D6869A
D6869A
$330.00
$145.00 $165.00 (≈% OFF)

D6852A
D6852A
$295.00
$125.00 $145.00 (≈% OFF)

Embroidered cocktail dress by basix II
D6786A
$595.00
$195.00 $295.00 (≈% OFF)

D6658A
D6658A
$695.00
$195.00 $345.00 (≈% OFF)

basix black label sequined nude cocktail dress
D6643A
$595.00
$195.00 $295.00 (≈% OFF)

D6613AS
D6613AS
$395.00
$195.00 $195.00 (≈% OFF)

D6613A
D6613A
$395.00
$95.00 $295.00 (≈% OFF)

D6588L
D6588L
$995.00
$295.00 $495.00 (≈% OFF)

D6545L
D6545L
$395.00
$195.00 $195.00 (≈% OFF)

D6538L
D6538L
$995.00
$195.00 $495.00 (≈% OFF)

D6536LS
D6536LS
$995.00
$195.00 $495.00 (≈% OFF)

D6462L
D6462L
$590.00
$195.00 $295.00 (≈% OFF)

D6459A by basix black label
D6459A
$550.00
$195.00 $275.00 (≈% OFF)

Sequin and beaded cocktail dress by basix black label
D6282A
$650.00
$295.00 $325.00 (≈% OFF)

D6177A
D6177A
$550.00
$195.00 $275.00 (≈% OFF)

D6163A
D6163A
$590.00
$145.00 $295.00 (≈% OFF)

D6090A
D6090A
$450.00
$195.00 $225.00 (≈% OFF)

D6083L
D6083L
$795.00
$195.00 $395.00 (≈% OFF)

D6034LB
D6034LB
$1,190.00
$395.00 $595.00 (≈% OFF)

D6029L
D6029L
$1,190.00
$395.00 $595.00 (≈% OFF)

Basix Black Label Long Sleeve Sequin Dress
D6024L
$1,195.00
$295.00 $595.00 (≈% OFF)

D5983L
D5983L
$595.00
$295.00 $350.00 (≈% OFF)

basix black label sequin evening dress
D5974L
$695.00
$195.00 $295.00 (≈% OFF)

basix chevron cocktail dress
D5972A
$450.00
$195.00 $225.00 (≈% OFF)

D5970LS
D5970LS
$650.00
$195.00 $325.00 (≈% OFF)

Sequin cocktail dress by basix black label
D5783A
$495.00
$145.00 $345.00 (≈% OFF)

D5763A
D5763A
$395.00
$145.00 $195.00 (≈% OFF)

D5662LB
D5662LB
$1,190.00
$395.00 $595.00 (≈% OFF)

Basix black label slip dress
D5662A
$695.00
$195.00 $325.00 (≈% OFF)

D5289A
D5289A
$390.00
$195.00 $195.00 (≈% OFF)

basix black label v neck cocktail dress
D5288A
$395.00
$95.00 $175.00 (≈% OFF)

Basix Black Label Fringed Art Deco Dress
D5115A
$395.00
$145.00 $225.00 (≈% OFF)

D4480A
D4480A
$390.00
$125.00 $195.00 (≈% OFF)

D4126A
D4126A
$590.00
$195.00 $295.00 (≈% OFF)

Basix beaded flare sleeve formal gown
D9905L
$1,090.00
$0.00 $345.00 (≈% OFF)

D1218LR
D1218LR
$1,195.00
$0.00 $595.00 (≈% OFF)

D1201L
D1201L
$995.00
$0.00 $495.00 (≈% OFF)

Basix Black label sequined sleeveless gown
D9817L
$995.00
$0.00 $395.00 (≈% OFF)

D9726L
D9726L
$990.00
$0.00 $495.00 (≈% OFF)

Basix Black Label Velvet Top Gown
D9660L
$995.00
$0.00 $375.00 (≈% OFF)

D9272L
D9272L
$450.00
$195.00 $225.00 (≈% OFF)

D9134L
D9134L
$395.00
$145.00 $185.00 (≈% OFF)

D8948L
D8948L
$590.00
$195.00 $295.00 (≈% OFF)

D8719L
D8719L
$550.00
$195.00 $275.00 (≈% OFF)

D8700L
D8700L
$895.00
$345.00 $295.00 (≈% OFF)

Basix Black label three quarter sleeve floral motif gown with pockets
D8527LR
$1,295.00
$795.00 $550.00 (≈% OFF)

D8497L
D8497L
$490.00
$145.00 $245.00 (≈% OFF)

Basix Black Label hand painted ball gown
D8404L
$795.00
$0.00 $395.00 (≈% OFF)

D8398L
D8398L
$630.00
$195.00 $315.00 (≈% OFF)

D8025L
D8025L
$995.00
$195.00 $495.00 (≈% OFF)

D7985L
D7985L
$990.00
$495.00 $495.00 (≈% OFF)

D6780L
D6780L
$1,190.00
$495.00 $595.00 (≈% OFF)

Basix Black Label Laser Cut Floral Short Sleeve Dress
D5788L
$1,195.00
$0.00 $595.00 (≈% OFF)

D1223LR
D1223LR
$1,195.00
$0.00 $595.00 (≈% OFF)

D1222LR
D1222LR
$895.00
$0.00 $395.00 (≈% OFF)

D1221LR
D1221LR
$1,190.00
$0.00 $595.00 (≈% OFF)

D1220LR
D1220LR
$1,050.00
$0.00 $525.00 (≈% OFF)

D1219LR
D1219LR
$995.00
$0.00 $445.00 (≈% OFF)

Array ( [__ci_last_regenerate] => 1615186892 [thumbs_uri_string] => shop/womens_apparel/dresses/4 [__ci_vars] => Array ( [thumbs_uri_string] => new [browse_by] => new [prod_list_last_query] => 1615188692 ) [browse_by] => sidebar_browse_by_category [prod_list_last_query] => SELECT SQL_CALC_FOUND_ROWS tbl_product.prod_id, `tbl_product`.`prod_id`, `tbl_product`.`prod_no`, `tbl_product`.`prod_name`, `tbl_product`.`prod_desc`, `tbl_product`.`prod_date`, `tbl_product`.`categories`, `tbl_product`.`seque`, `tbl_product`.`options`, `tbl_product`.`clearance`, `tbl_product`.`less_discount`, `tbl_product`.`less_discount` AS `retail_price`, `tbl_product`.`catalogue_price`, `tbl_product`.`catalogue_price` AS `on_sale_price`, `tbl_product`.`wholesale_price`, `tbl_product`.`wholesale_price_clearance`, `designer`.`des_id`, `designer`.`designer`, `designer`.`url_structure` as `d_url_structure`, `vendors`.`vendor_id`, `vendors`.`vendor_name`, `vendors`.`vendor_code`, `vendor_types`.`type`, `c2`.`category_name` AS `subcat_name`, `tblcolor`.`color_code`, `tblcolor`.`color_name`, `tbl_stock`.`st_id`, `tbl_stock`.`color_facets`, `tbl_stock`.`color_publish`, `tbl_stock`.`custom_order`, `tbl_stock`.`new_color_publish`, `tbl_stock`.`primary_color`, `tbl_stock`.`options` as `color_options`, `tbl_stock`.`options` as `stocks_options`, `tbl_stock`.`size_sxs`, `tbl_stock`.`size_ss`, `tbl_stock`.`size_sm`, `tbl_stock`.`size_sl`, `tbl_stock`.`size_sxl`, `tbl_stock`.`size_sxxl`, `tbl_stock`.`size_sxl1`, `tbl_stock`.`size_sxl2`, `tbl_stock`.`size_0`, `tbl_stock`.`size_2`, `tbl_stock`.`size_4`, `tbl_stock`.`size_6`, `tbl_stock`.`size_8`, `tbl_stock`.`size_10`, `tbl_stock`.`size_12`, `tbl_stock`.`size_14`, `tbl_stock`.`size_16`, `tbl_stock`.`size_18`, `tbl_stock`.`size_20`, `tbl_stock`.`size_22`, `tbl_stock`.`size_sprepack1221`, `tbl_stock`.`size_ssm`, `tbl_stock`.`size_sml`, `tbl_stock`.`size_sonesizefitsall`, `tsav`.`size_ss` AS `available_sxs`, `tsav`.`size_ss` AS `available_ss`, `tsav`.`size_sm` AS `available_sm`, `tsav`.`size_sl` AS `available_sl`, `tsav`.`size_sxl` AS `available_sxl`, `tsav`.`size_sxxl` AS `available_sxxl`, `tsav`.`size_sxl1` AS `available_ssl1`, `tsav`.`size_sxl2` AS `available_sxl2`, `tsav`.`size_0` AS `available_0`, `tsav`.`size_2` AS `available_2`, `tsav`.`size_4` AS `available_4`, `tsav`.`size_6` AS `available_6`, `tsav`.`size_8` AS `available_8`, `tsav`.`size_10` AS `available_10`, `tsav`.`size_12` AS `available_12`, `tsav`.`size_14` AS `available_14`, `tsav`.`size_16` AS `available_16`, `tsav`.`size_18` AS `available_18`, `tsav`.`size_20` AS `available_20`, `tsav`.`size_22` AS `available_22`, `tsav`.`size_sprepack1221` AS `available_sprepack1221`, `tsav`.`size_ssm` AS `available_ssm`, `tsav`.`size_sml` AS `available_ssm`, `tsav`.`size_sonesizefitsall` AS `available_sonesizefitsall`, `tso`.`size_ss` AS `onorder_sxs`, `tso`.`size_ss` AS `onorder_ss`, `tso`.`size_sm` AS `onorder_sm`, `tso`.`size_sl` AS `onorder_sl`, `tso`.`size_sxl` AS `onorder_sxl`, `tso`.`size_sxxl` AS `onorder_sxxl`, `tso`.`size_sxl1` AS `onorder_ssl1`, `tso`.`size_sxl2` AS `onorder_sxl2`, `tso`.`size_0` AS `onorder_0`, `tso`.`size_2` AS `onorder_2`, `tso`.`size_4` AS `onorder_4`, `tso`.`size_6` AS `onorder_6`, `tso`.`size_8` AS `onorder_8`, `tso`.`size_10` AS `onorder_10`, `tso`.`size_12` AS `onorder_12`, `tso`.`size_14` AS `onorder_14`, `tso`.`size_16` AS `onorder_16`, `tso`.`size_18` AS `onorder_18`, `tso`.`size_20` AS `onorder_20`, `tso`.`size_22` AS `onorder_22`, `tso`.`size_sprepack1221` AS `onorder_sprepack1221`, `tso`.`size_ssm` AS `onorder_ssm`, `tso`.`size_sml` AS `onorder_ssm`, `tso`.`size_sonesizefitsall` AS `onorder_sonesizefitsall`, `tsa`.`size_ss` AS `admin_sxs`, `tsa`.`size_ss` AS `admin_ss`, `tsa`.`size_sm` AS `admin_sm`, `tsa`.`size_sl` AS `admin_sl`, `tsa`.`size_sxl` AS `admin_sxl`, `tsa`.`size_sxxl` AS `admin_sxxl`, `tsa`.`size_sxl1` AS `admin_ssl1`, `tsa`.`size_sxl2` AS `admin_sxl2`, `tsa`.`size_0` AS `admin_0`, `tsa`.`size_2` AS `admin_2`, `tsa`.`size_4` AS `admin_4`, `tsa`.`size_6` AS `admin_6`, `tsa`.`size_8` AS `admin_8`, `tsa`.`size_10` AS `admin_10`, `tsa`.`size_12` AS `admin_12`, `tsa`.`size_14` AS `admin_14`, `tsa`.`size_16` AS `admin_16`, `tsa`.`size_18` AS `admin_18`, `tsa`.`size_20` AS `admin_20`, `tsa`.`size_22` AS `admin_22`, `tsa`.`size_sprepack1221` AS `admin_sprepack1221`, `tsa`.`size_ssm` AS `admin_ssm`, `tsa`.`size_sml` AS `admin_ssm`, `tsa`.`size_sonesizefitsall` AS `admin_sonesizefitsall`, `tsao`.`size_ss` AS `admin_onorder_sxs`, `tsao`.`size_ss` AS `admin_onorder_ss`, `tsao`.`size_sm` AS `admin_onorder_sm`, `tsao`.`size_sl` AS `admin_onorder_sl`, `tsao`.`size_sxl` AS `admin_onorder_sxl`, `tsao`.`size_sxxl` AS `admin_onorder_sxxl`, `tsao`.`size_sxl1` AS `admin_onorder_ssl1`, `tsao`.`size_sxl2` AS `admin_onorder_sxl2`, `tsao`.`size_0` AS `admin_onorder_0`, `tsao`.`size_2` AS `admin_onorder_2`, `tsao`.`size_4` AS `admin_onorder_4`, `tsao`.`size_6` AS `admin_onorder_6`, `tsao`.`size_8` AS `admin_onorder_8`, `tsao`.`size_10` AS `admin_onorder_10`, `tsao`.`size_12` AS `admin_onorder_12`, `tsao`.`size_14` AS `admin_onorder_14`, `tsao`.`size_16` AS `admin_onorder_16`, `tsao`.`size_18` AS `admin_onorder_18`, `tsao`.`size_20` AS `admin_onorder_20`, `tsao`.`size_22` AS `admin_onorder_22`, `tsao`.`size_sprepack1221` AS `admin_onorder_sprepack1221`, `tsao`.`size_ssm` AS `admin_onorder_ssm`, `tsao`.`size_sml` AS `admin_onorder_ssm`, `tsao`.`size_sonesizefitsall` AS `admin_onorder_sonesizefitsall`, `tsap`.`size_ss` AS `admin_physical_sxs`, `tsap`.`size_ss` AS `admin_physical_ss`, `tsap`.`size_sm` AS `admin_physical_sm`, `tsap`.`size_sl` AS `admin_physical_sl`, `tsap`.`size_sxl` AS `admin_physical_sxl`, `tsap`.`size_sxxl` AS `admin_physical_sxxl`, `tsap`.`size_sxl1` AS `admin_physical_ssl1`, `tsap`.`size_sxl2` AS `admin_physical_sxl2`, `tsap`.`size_0` AS `admin_physical_0`, `tsap`.`size_2` AS `admin_physical_2`, `tsap`.`size_4` AS `admin_physical_4`, `tsap`.`size_6` AS `admin_physical_6`, `tsap`.`size_8` AS `admin_physical_8`, `tsap`.`size_10` AS `admin_physical_10`, `tsap`.`size_12` AS `admin_physical_12`, `tsap`.`size_14` AS `admin_physical_14`, `tsap`.`size_16` AS `admin_physical_16`, `tsap`.`size_18` AS `admin_physical_18`, `tsap`.`size_20` AS `admin_physical_20`, `tsap`.`size_22` AS `admin_physical_22`, `tsap`.`size_sprepack1221` AS `admin_physical_sprepack1221`, `tsap`.`size_ssm` AS `admin_physical_ssm`, `tsap`.`size_sml` AS `admin_physical_ssm`, `tsap`.`size_sonesizefitsall` AS `admin_physical_sonesizefitsall`, `tbl_product`.`size_mode`, `tbl_product`.`primary_img`, `tbl_product`.`primary_img_id`, `tbl_product`.`publish`, `tbl_product`.`public`, `tbl_product`.`view_status`, `tbl_product`.`styles`, `tbl_product`.`events`, `tbl_product`.`trends`, `tbl_product`.`materials`, `tbl_product`.`seasons`, `media_library_products`.`media_path`, `media_library_products`.`media_name`, `media_library_products`.`upload_version`, `c1`.`category_slug` as `c_url_structure`, (CASE WHEN c1.category_slug = "apparel" THEN "WMANSAPREL" ELSE c1.category_slug END) AS cat_folder, (CASE WHEN c2.category_slug = "cocktail-dresses" THEN "cocktail" WHEN c2.category_slug = "evening-dresses" THEN "evening" ELSE c2.category_slug END) AS sc_url_structure, (CASE WHEN c2.category_slug = "cocktail-dresses" THEN "cocktail" WHEN c2.category_slug = "evening-dresses" THEN "evening" ELSE c2.category_slug END) AS subcat_folder, (CASE WHEN tbl_stock.custom_order = "3" THEN tbl_product.catalogue_price ELSE tbl_product.less_discount END) AS net_price, (CASE WHEN (tbl_product.size_mode = '1' AND (tbl_stock.size_0 > '0' OR tbl_stock.size_2 > '0' OR tbl_stock.size_4 > '0' OR tbl_stock.size_6 > '0' OR tbl_stock.size_8 > '0' OR tbl_stock.size_10 > '0' OR tbl_stock.size_12 > '0' OR tbl_stock.size_14 > '0' OR tbl_stock.size_16 > '0' OR tbl_stock.size_18 > '0' OR tbl_stock.size_20 > '0' OR tbl_stock.size_22 > '0')) OR (tbl_product.size_mode = '0' AND (tbl_stock.size_sxs > '0' OR tbl_stock.size_ss > '0' OR tbl_stock.size_sm > '0' OR tbl_stock.size_sl > '0' OR tbl_stock.size_sxl > '0' OR tbl_stock.size_sxxl > '0' OR tbl_stock.size_sxl1 > '0' OR tbl_stock.size_sxl2 > '0')) OR (tbl_product.size_mode = '2' AND (tbl_stock.size_sprepack1221 > '0')) OR (tbl_product.size_mode = '3' AND (tbl_stock.size_ssm > '0' AND tbl_stock.size_sml > '0')) OR (tbl_product.size_mode = '4' AND (tbl_stock.size_sonesizefitsall > '0')) THEN '1' ELSE '0' END) AS with_stocks FROM `tbl_product` LEFT JOIN `designer` ON `designer`.`des_id` = `tbl_product`.`designer` LEFT JOIN `vendors` ON `vendors`.`vendor_id` = `tbl_product`.`vendor_id` LEFT JOIN `vendor_types` ON `vendor_types`.`id` = `vendors`.`vendor_type_id` LEFT JOIN `categories` `c1` ON `c1`.`category_id` = `tbl_product`.`cat_id` LEFT JOIN `categories` `c2` ON `c2`.`category_id` = `tbl_product`.`subcat_id` LEFT JOIN (SELECT * FROM tbl_stock ORDER BY primary_color DESC) as tbl_stock ON `tbl_stock`.`prod_no` = `tbl_product`.`prod_no` LEFT JOIN `tbl_stock_available` `tsav` ON `tsav`.`st_id` = `tbl_stock`.`st_id` LEFT JOIN `tbl_stock_onorder` `tso` ON `tso`.`st_id` = `tbl_stock`.`st_id` LEFT JOIN `tbl_stock_admin` `tsa` ON `tsa`.`st_id` = `tbl_stock`.`st_id` LEFT JOIN `tbl_stock_admin_onorder` `tsao` ON `tsao`.`st_id` = `tbl_stock`.`st_id` LEFT JOIN `tbl_stock_admin_physical` `tsap` ON `tsap`.`st_id` = `tbl_stock`.`st_id` LEFT JOIN `tblcolor` ON `tblcolor`.`color_name` = `tbl_stock`.`color_name` LEFT JOIN `media_library_products` ON `media_library_products`.`media_id` = `tbl_stock`.`image_url_path` WHERE `designer`.`url_structure` <> 'tempoparis' AND `tbl_product`.`categories` LIKE '%"161"%' ESCAPE '!' AND ( ( tbl_product.publish = '1' OR `tbl_product`.`publish` = '11' OR tbl_product.publish = '12' ) AND ( tbl_stock.new_color_publish = '1' OR `tbl_stock`.`new_color_publish` = '11' OR tbl_stock.new_color_publish = '12' ) AND ( tbl_stock.color_publish = 'Y' ) ) AND ( ( (tbl_product.size_mode = '1' AND (`tsav`.`size_0` > '0' OR `tsav`.`size_2` > '0' OR `tsav`.`size_4` > '0' OR `tsav`.`size_6` > '0' OR `tsav`.`size_8` > '0' OR `tsav`.`size_10` > '0' OR `tsav`.`size_12` > '0' OR `tsav`.`size_14` > '0' OR `tsav`.`size_16` > '0' OR `tsav`.`size_18` > '0' OR `tsav`.`size_20` > '0' OR tsav.size_22 > '0')) OR (`tbl_product`.`size_mode` = '0' AND (`tsav`.`size_sxs` > '0' OR `tsav`.`size_ss` > '0' OR `tsav`.`size_sm` > '0' OR `tsav`.`size_sl` > '0' OR `tsav`.`size_sxl` > '0' OR `tsav`.`size_sxxl` > '0' OR `tsav`.`size_sxl1` > '0' OR tsav.size_sxl2 > '0')) OR (`tbl_product`.`size_mode` = '2' AND (tsav.size_sprepack1221 > '0')) OR (`tbl_product`.`size_mode` = '3' AND (`tsav`.`size_ssm` > '0' AND tsav.size_sml > '0')) OR (`tbl_product`.`size_mode` = '4' AND (tsav.size_sonesizefitsall > '0')) ) OR ( ( (tbl_product.size_mode = '1' AND (`tsav`.`size_0` = '0' AND `tsav`.`size_2` = '0' AND `tsav`.`size_4` = '0' AND `tsav`.`size_6` = '0' AND `tsav`.`size_8` = '0' AND `tsav`.`size_10` = '0' AND `tsav`.`size_12` = '0' AND `tsav`.`size_14` = '0' AND `tsav`.`size_16` = '0' AND `tsav`.`size_18` = '0' AND `tsav`.`size_20` = '0' AND tsav.size_22 = '0')) OR (`tbl_product`.`size_mode` = '0' AND (`tsav`.`size_sxs` = '0' AND `tsav`.`size_ss` = '0' AND `tsav`.`size_sm` = '0' AND `tsav`.`size_sl` = '0' AND `tsav`.`size_sxl` = '0' AND `tsav`.`size_sxxl` = '0' AND `tsav`.`size_sxl1` = '0' AND tsav.size_sxl2 = '0')) OR (`tbl_product`.`size_mode` = '2' AND (tsav.size_sprepack1221 = '0')) OR (`tbl_product`.`size_mode` = '3' AND (`tsav`.`size_ssm` > '0' AND tsav.size_sml = '0')) OR (`tbl_product`.`size_mode` = '4' AND (tsav.size_sonesizefitsall = '0')) ) AND ( (tbl_stock.custom_order = '3' AND `tbl_product`.`catalogue_price` >= '695') OR tbl_product.less_discount >= '695' ) ) ) AND `designer`.`view_status` = 'Y' ORDER BY `seque` ASC, `tbl_product`.`prod_no` DESC )

Blank Page

DRESSES

DRESSES

You have 0 Items in you cart

You have 0 Items in you cart

Blank Page

DRESSES

DRESSES