All models fully assembled -  Free Shipping over $199

Array ( [0] => 2098 [PRODUCT_CATEGORY_ID] => 2098 [1] => Decorative Wooden Oars [CATEGORY_NAME] => Decorative 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] => Decorative Wooden Oars for Decoration - Paddle oars, boat oars boat oars wooden [PRODUCT_PAGE_TITLE] => Decorative Wooden Oars for Decoration - Paddle oars, boat oars boat oars wooden [6] => [PRODUCT_SEO] => [7] => wooden-decorative-oar-decor.php [FILENAME] => wooden-decorative-oar-decor.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Decorative Wooden Oar [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 4254 [CATEGORY_PICTURE] => 4254 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [22] => HBD [CATEGORY_SITE] => HBD [SUPER_NAME] => )
(42 Items) Sort:
Items: 1 to 39
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2098' 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 LIMIT 0,48

Similar to Decorative Wooden Oars Models