Home |  Log In
Latin Dance fashions

Short Dresses

salsa dress

What do you look for in the perfect dance dress, ballroom dress or latin dress? Style, movement, comfort, or versatility? We're sure you'll agree that all of these factors are equally important when it comes to latin dance wear or ballroom dance wear. Our collection of discount dance wear including dance dresses, latin dresses, ballroom dresses and salsa dresses have been selected and approved by professional dancers who understand and appreciate the importance of fine dance wear.

Looking for a salsa dance dress or latin ballroom dress to wear to your favorite nightclub? A Tango dress for the upcoming Milonga? A latin ballroom dress for this weekend's ballroom social? Don't forget to take a look at our selection of ballroom dance shoes to pair with your favorite salsa dancing dress or latin ballroom dresses! We guarantee that our latin ballroom dresses and dancing dresses will allow you to look and feel your best on the dance floor!

1030 Got error 122 from storage engine
in:
[select p.products_image, pd.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 from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '162' order by p.products_sort_order, pd.products_name]