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

Vibrant Red Decorative Lifering with White Bands 15"

The Vibrant Red Lifering with White Bands 15" decorative lifering is a bold beach theme lifering to add to your home, office, or pool area. White canvas straps accent the red lifering, and will make guests and family feel at home and comfortable. Lightweight styrofoam construction makes the 15" lifering easy to hang anywhere so you can bring that coastal ocean feel into the comfort of your own home, office, nautical clubhouse, or poolhouse.

Dimensions: 15" Long x 2" Wide x 15" High

NOTE: For decoration only, this is not a life saving device. Wall mounting hardware not included.