Spring Sale ends Friday, June 3rd - Free shipping on orders $39 and above

Array ( [0] => 2101 [PRODUCT_CATEGORY_ID] => 2101 [1] => Decorative Collegiate Wooden Oars [CATEGORY_NAME] => Decorative Collegiate 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] => University and Collegiate Wooden Oars for Wall Hanging - Painted boat rowing oar [PRODUCT_PAGE_TITLE] => University and Collegiate Wooden Oars for Wall Hanging - Painted boat rowing oar [6] => [PRODUCT_SEO] => [7] => wooden-university-oar-wood-paddle.php [FILENAME] => wooden-university-oar-wood-paddle.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Decorative Collegiate Wooden Oar [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 4212 [CATEGORY_PICTURE] => 4212 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(6 Items) Sort:
Items: 1 to 6
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2101' 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