romantic medieval gothic dresscoat vampire dress #32

this another of my own designs. this gown is made of rich red wine velvet,smooth lining,wine satin and black lace overlay(this style of lace is no longer available),brocade trim, train measures 4 feet long. This gown is hand made by me. If you would like to order this dress and need it for an event, please contact me at least one 3 weeks before the event. This dress can also be made in black too. This is a dress coat and long wine or black satin skirt with lace or without black lace upon request.


  • Model: #32
  • Shipping Weight: 4lbs
  • 1 Units in Stock
  • Manufactured by: Nocturnal Nostalgia
Add to Cart:

This product was added to our catalog on Thursday 21 September, 2006.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'nocturnalnostalgia_com.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[select p.products_id, p.products_image from zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p where opa.products_id = '54' and opa.orders_id = opb.orders_id and opb.products_id != '54' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]