Summer Sale ends Fri Aug 26th - Free shipping on orders $39 and above

Array ( [0] => 2224 [PRODUCT_CATEGORY_ID] => 2224 [1] => Rustic Oars [CATEGORY_NAME] => Rustic Oars [2] => [CATEGORY_HEADER] => [3] => handcrafted beach decor,beach accents,beach signs,decorative ship wheels,decorative wooden rustic anchors,nautical coasters,shell decorations,nautical art,nautical salt and pepper shakers,coastal furniture,nautical tables & desks,canoe and lifeboat bookcases,nautical themed cabinets,nautical themed chairs,wooden sailors chests,additional nautical furniture,display cases & tables ,display tables,display case & table combinations,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,gifts under $20,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,multi colored life rings,solid colored life rings,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,nautical fun for kids,spyglasses,nautical key chains,antique copper key chains,nautical paperweights,ships in a bottle,pirate ship in bottle,nautical flags,nautical salt and pepper shakers,brass pocket compasses,decorative ship wheels,floating sail boats,chrome plaques,nautical brass signs,nautical bottle openers,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,multi colored life rings,solid colored life rings,lighthouses,lighthouses under $49,wooden lighthouses,lighthouses by name,cape hatteras lighthouses,west quoddy lighthouses,cape lookout lighthouses,cape canaveral lighthouses,cape may lighthouses,cape cod lighthouses,hilton head lighthouses,fenwick lighthouses,old saybrook lighthouses,patriot lighthouses,seul choix lighthouses,tybee island lighthouses,barnegat lighthouses,marblehead lighthouses,fire island lighthouses,oak island lighthouses,bodie island lighthouses,cape henry lighthouses,american lighthouses,st. augustine lighthouses,white shoal lighthouses,assateague lighthouses,montauk lighthouses,split rock lighthouses,oars & paddles,decorative wooden oars,wooden oars w/ hanging hooks,rustic wooden oars,university/collegiate wooden oars,rowing club wooden oars,wooden oars under 50",wooden oars over 50",feathered style rowing oars,rolling pin styled oars,squared style rowing oars,squared rowing oars,touring rowing oars,classic rowing oars,decorative paddles,rustic decor,rustic wooden oars,rustic iron signs,cast iron rustic sealife,cast iron seaworn sealife,decorative wooden rustic anchors,decorative antique life rings,antique copper bells,vintage buoys,rustic oars,Rustic Oars,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => handcrafted beach decor,beach accents,beach signs,decorative ship wheels,decorative wooden rustic anchors,nautical coasters,shell decorations,nautical art,nautical salt and pepper shakers,coastal furniture,nautical tables & desks,canoe and lifeboat bookcases,nautical themed cabinets,nautical themed chairs,wooden sailors chests,additional nautical furniture,display cases & tables ,display tables,display case & table combinations,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,gifts under $20,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,multi colored life rings,solid colored life rings,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,nautical fun for kids,spyglasses,nautical key chains,antique copper key chains,nautical paperweights,ships in a bottle,pirate ship in bottle,nautical flags,nautical salt and pepper shakers,brass pocket compasses,decorative ship wheels,floating sail boats,chrome plaques,nautical brass signs,nautical bottle openers,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,multi colored life rings,solid colored life rings,lighthouses,lighthouses under $49,wooden lighthouses,lighthouses by name,cape hatteras lighthouses,west quoddy lighthouses,cape lookout lighthouses,cape canaveral lighthouses,cape may lighthouses,cape cod lighthouses,hilton head lighthouses,fenwick lighthouses,old saybrook lighthouses,patriot lighthouses,seul choix lighthouses,tybee island lighthouses,barnegat lighthouses,marblehead lighthouses,fire island lighthouses,oak island lighthouses,bodie island lighthouses,cape henry lighthouses,american lighthouses,st. augustine lighthouses,white shoal lighthouses,assateague lighthouses,montauk lighthouses,split rock lighthouses,oars & paddles,decorative wooden oars,wooden oars w/ hanging hooks,rustic wooden oars,university/collegiate wooden oars,rowing club wooden oars,wooden oars under 50",wooden oars over 50",feathered style rowing oars,rolling pin styled oars,squared style rowing oars,squared rowing oars,touring rowing oars,classic rowing oars,decorative paddles,rustic decor,rustic wooden oars,rustic iron signs,cast iron rustic sealife,cast iron seaworn sealife,decorative wooden rustic anchors,decorative antique life rings,antique copper bells,vintage buoys,rustic oars,Rustic Oars,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Rustic Oars model ships are fully assembled and in stock. Rustic Oars model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Rustic Oars model ships are fully assembled and in stock. Rustic Oars model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Rustic Oars Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Rustic Oars Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => rustic-oars.php [FILENAME] => rustic-oars.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Rustic Oar [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 0 [CATEGORY_PICTURE] => 0 [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='2224' 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