2: select PRODUCTS.PRODUCT_ID from PRODUCTS join PRODUCT_BRIDGE on PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID join CATEGORY_BRIDGE on CATEGORY_BRIDGE.CATEGORY_ID=PRODUCT_BRIDGE.CATEGORY_ID join PRODUCT_CATEGORIES on PRODUCT_CATEGORIES.PRODUCT_CATEGORY_ID=CATEGORY_BRIDGE.CATEGORY_ID where PRODUCTS.PRODUCT_ACTIVE='1' and PRODUCTS.DISCONTINUED='' and CATEGORY_BRIDGE.SUPER_ID='2196' order by PRODUCT_BRIDGE.ORDER ASC

Rustic Cast Iron Mermaid Wall Decor 13"

This Rustic Cast Iron Mermaid Wall Decor 13" is the perfect addition for any beach themed home. Handcrafted from cast iron, this mermaid is durable, decorative and charming. Use our rustic cast iron mermaid to show those who visit your home your affinity for the sea.