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='2247' order by PRODUCT_BRIDGE.ORDER ASC

Antique Brass Port and Starboard Electric Lantern 12"

This Antique Brass Port and Starboard Electric Lantern 12" is an authentic and functional ship lantern set. Handcrafted from solid brass to create realistic antique port and starboard replica lanterns as used onboard tall ships, this ship lantern is true to the original design of period lamps. Each lamp can be idenified by the words "Port" and "Starboard" at the top of each lantern. In addition the port lantern displays a green stained glass, while the starboard lantern has a red stained glass. Our boat lantern is fully functional and simply plug into the nearest power source to produce light.

This electric lamp is handcrafted from solid brass by our master artisans