1: 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='2053' AND PRODUCTS.WHOLESALE='1' order by PRODUCT_BRIDGE.ORDER ASC

Dark Blue Whitewashed Cast Iron Propeller Key Chain 5"

This nautical-themed key chain is both adorable and functional, featuring a cast iron propeller key fob. Crafted from cast iron, this key chain is as beautiful as it is durable and functional with a knurled knob that allows you to easily and securely add or remove keys from the ring. These wonderful key chains make ideal gifts for all.

Cast Iron keyring and body

Knurled knob makes changing keys easy and secure

Overall length is total of ring, chain, and symbol length

WARNING: This product can expose you to chemicals including Formaldehyde, and Styrene, which are known to the State of California to cause cancer, and Chromium and Toluene, which are known to the State of California to cause birth defects or other reproductive harm. For more information go to www.P65Warnings.ca.gov