Array
(
[0] => 2191
[PRODUCT_CATEGORY_ID] => 2191
[1] => Crab & Lobster
[CATEGORY_NAME] => Crab & Lobster
[2] =>
[CATEGORY_HEADER] =>
[3] => handcrafted beach decor,beach wall decor,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,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,decorative paddles,mounted fish & sealife,beach accents,beach signs,decorative ship wheels,decorative wooden rustic anchors,nautical coasters,shell decorations,nautical art,other beach accents,nautical salt and pepper shakers,signs & flags,brass nautical signs,beach signs,pirate signs,nautical flags,rustic iron signs,chrome nautical signs,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,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,decorative paddles,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,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,sealife decor,seaworn sealife,seashells,dolphins,turtles,seahorses,whales,starfishes,mermaids,crabs/lobsters,Crabs/Lobsters,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats,
[PRODUCT_META_TAG] => handcrafted beach decor,beach wall decor,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,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,decorative paddles,mounted fish & sealife,beach accents,beach signs,decorative ship wheels,decorative wooden rustic anchors,nautical coasters,shell decorations,nautical art,other beach accents,nautical salt and pepper shakers,signs & flags,brass nautical signs,beach signs,pirate signs,nautical flags,rustic iron signs,chrome nautical signs,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,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,decorative paddles,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,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,sealife decor,seaworn sealife,seashells,dolphins,turtles,seahorses,whales,starfishes,mermaids,crabs/lobsters,Crabs/Lobsters,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats,
[4] => Crabs/Lobsters model ships are fully assembled and in stock. Crabs/Lobsters model ships at discounted prices. No assembly required. Lots of models to choose from.
[PRODUCT_META_DESCRIPTION] => Crabs/Lobsters model ships are fully assembled and in stock. Crabs/Lobsters model ships at discounted prices. No assembly required. Lots of models to choose from.
[5] => Buy Crabs/Lobsters Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat
[PRODUCT_PAGE_TITLE] => Buy Crabs/Lobsters Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat
[6] =>
[PRODUCT_SEO] =>
[7] => crab-lobster-decor.php
[FILENAME] => crab-lobster-decor.php
[8] =>
[CATEGORY_FOOTER] =>
[9] =>
[AMAZON] =>
[10] =>
[IMAGE] =>
[11] =>
[H1] => Crab & Lobster
[12] =>
[H2] =>
[13] =>
[POINTS] =>
[14] =>
[CATEGORY_SPLASH] =>
[15] => 10354
[CATEGORY_PICTURE] => 10354
[16] => product
[CATEGORY_TYPE] => product
[17] => 3
[FEATURED] => 3
[18] =>
[EBAY] =>
[19] =>
[BREADCRUMB] =>
[20] => 1
[SHOW_ALL] => 1
[21] =>
[HOME_IMAGE] =>
[22] => HCI
[CATEGORY_SITE] => HCI
[SUPER_NAME] =>
)
(55 Items) Sort:
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE (PRODUCT_BRIDGE.CATEGORY_ID='2191') 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