Spring Sale ends Friday, May 6th - Free shipping on orders $39 and above

Array ( [0] => 2100 [PRODUCT_CATEGORY_ID] => 2100 [1] => Decorative Rustic Wooden Oars [CATEGORY_NAME] => Decorative Rustic Wooden Oars [2] => [CATEGORY_HEADER] => [3] => Paddle Oars, boat oars, oars boat, wood paddle, wooden paddle, wood paddles, wooden wall art, rowing oars, wooden oars, wood oars, rowing oar, boats oars, wooden oar, wooden canoe paddles, row boat oars, [PRODUCT_META_TAG] => Paddle Oars, boat oars, oars boat, wood paddle, wooden paddle, wood paddles, wooden wall art, rowing oars, wooden oars, wood oars, rowing oar, boats oars, wooden oar, wooden canoe paddles, row boat oars, [4] => Interested in Oars and Paddles? We have many to choose from, including university and collegiate oars, plus other beach decor ideas and gifts. FREE shipping on orders over $39. [PRODUCT_META_DESCRIPTION] => Interested in Oars and Paddles? We have many to choose from, including university and collegiate oars, plus other beach decor ideas and gifts. FREE shipping on orders over $39. [5] => Rustic Wooden Oars for Wall Hanging - Painted boat and rowing oar, beach decor [PRODUCT_PAGE_TITLE] => Rustic Wooden Oars for Wall Hanging - Painted boat and rowing oar, beach decor [6] => [PRODUCT_SEO] => [7] => rustic-wooden-oar-decor.php [FILENAME] => rustic-wooden-oar-decor.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Decorative Rustic Wooden Oars [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 4822 [CATEGORY_PICTURE] => 4822 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(48 Items) Sort:
Items: 1 to 48
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2100' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY `price` ASC,PRODUCTS.PRODUCT_NAME, PRODUCT_ACTIVE DESC
Show: / page

Similar to Decorative Rustic Wooden Oars