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

Used for a mutlitude of nautical signals, and now to decorate your home in fabulous seafaring style, Floats & Buoys are sailing classics that are sure to charm even the most sophisticated collector. Perfect for decorating both indoors and out, these brilliant and delightful beauties bring the ambiance of the sea into your life. With a wonderful collection, from petite Wooden Buoys to traditional Iron Navigational Buoys, Handcrafted Nautical Decor is proud to present some of our favorite floating friends.

[CATEGORY_FOOTER] =>

Used for a mutlitude of nautical signals, and now to decorate your home in fabulous seafaring style, Floats & Buoys are sailing classics that are sure to charm even the most sophisticated collector. Perfect for decorating both indoors and out, these brilliant and delightful beauties bring the ambiance of the sea into your life. With a wonderful collection, from petite Wooden Buoys to traditional Iron Navigational Buoys, Handcrafted Nautical Decor is proud to present some of our favorite floating friends.

SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='1057' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' AND PRODUCTS.DISCONTINUED='' and PRODUCTS.ISDELETED='0' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY price ASC,PRODUCTS.PRODUCT_NAME, PRODUCT_ACTIVE DESC

Similar to Lobster Buoys Models

Lobster Buoy Models

Used for a mutlitude of nautical signals, and now to decorate your home in fabulous seafaring style, Floats & Buoys are sailing classics that are sure to charm even the most sophisticated collector. Perfect for decorating both indoors and out, these brilliant and delightful beauties bring the ambiance of the sea into your life. With a wonderful collection, from petite Wooden Buoys to traditional Iron Navigational Buoys, Handcrafted Nautical Decor is proud to present some of our favorite floating friends.