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

> Page 4

Array ( [0] => 2305 [PRODUCT_CATEGORY_ID] => 2305 [1] => New Gifts Under $20 [CATEGORY_NAME] => New Gifts Under $20 [2] => [CATEGORY_HEADER] => [3] => handcrafted beach decor,new items,gifts under $20,life rings,decorative life rings,decorative colored life rings,decorative antique life rings,decorative life ring clocks,decorative life ring mirrors,decorative titanic life rings,new life rings,decorative buoys,decorative glass floats,decorative wooden buoys,decorative lobster buoys,decorative squared buoys,numbered squared buoys,decorative vintage buoys,new decorative buoys,nautical fun for kids,spyglasses,nautical key chains,antique copper key chains,chrome key chains,brass key chains,nautical paperweights,ships in a bottle,pirate ship in bottle,nautical cloth alphabet flags,lighthouse salt & pepper shakers,brass pocket compasses,new gifts under $20,New Gifts Under $20,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => handcrafted beach decor,new items,gifts under $20,life rings,decorative life rings,decorative colored life rings,decorative antique life rings,decorative life ring clocks,decorative life ring mirrors,decorative titanic life rings,new life rings,decorative buoys,decorative glass floats,decorative wooden buoys,decorative lobster buoys,decorative squared buoys,numbered squared buoys,decorative vintage buoys,new decorative buoys,nautical fun for kids,spyglasses,nautical key chains,antique copper key chains,chrome key chains,brass key chains,nautical paperweights,ships in a bottle,pirate ship in bottle,nautical cloth alphabet flags,lighthouse salt & pepper shakers,brass pocket compasses,new gifts under $20,New Gifts Under $20,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => New Gifts Under $20 model ships are fully assembled and in stock. New Gifts Under $20 model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => New Gifts Under $20 model ships are fully assembled and in stock. New Gifts Under $20 model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy New Gifts Under $20 Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy New Gifts Under $20 Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => new-cheap-nautical-decor-gifts.php [FILENAME] => new-cheap-nautical-decor-gifts.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => New Gifts Under $20 [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 5009 [CATEGORY_PICTURE] => 5009 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(1124 Items) Sort:
Page:    4     
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2305' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY PRODUCTS.PRODUCT_ID DESC, PRODUCT_ACTIVE DESC
Show: / page