Join | Find a store

Social Apparel

(0)

looking for a perfect dress?

THE ONE HOT DRESSOur objective is to make sure every lady socializes in style. We want to be your primary destination to find the perfect dress or outfit for all your “Social” needs.
VISIT OUT STORESNew York at heart, Social Apparel opened its first store in 2007 and gradually grew to 7 stores throughout the NY Metro area.
BE A SOCIAL MEMBER Sign up to receive great offers and information on upcoming sales and events.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, price_index.price AS `indexed_price`, `price_index`.`price`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '91' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 ORDER BY `position` ASC

There are no products matching the selection.

There are no products matching the selection.