VALHALLA HOBBIES Your source for 1:6 scale 12" military action figures and toys from Dragon Models, DID Dragon In Dream, BBI Elite Force, Sideshow Collectibles and others

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_variants.avail > 0 LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hussar7/public_html/xcart/include/func.php on line 102
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_variants.avail > 0 WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_products.avail>0 AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
VALHALLA HOBBIES Your source for 1:6 scale 12" military action figures and toys from Dragon Models, DID Dragon In Dream, BBI Elite Force, Sideshow Collectibles and others


	DRAGON ALLIED FIGURE LIST


	DRAGON GERMAN FIGURE LIST


	DID (DRAGON IN DREAM) FIGURE SALE LIST


	CYBERHOBBY SALE FIGURES LIST


	BBI ELITE FORCE FIGURE SALE


	MISCELLANEOUS FIGURES SALE LIST


	Contact RIC

Search:

Advanced search

Help

Contact us
Privacy statement
Terms & Conditions
DID FIGURE SALE LIST
DRAGON ALLIED FIGURE LIST
CYBERHOBBY SALE FIGURES LIST
DRAGON GERMAN FIGURE LIST
BBI ELITE FORCE FIGURE SALE
MISCELLANEOUS FIGURES SALE LIST

VALHALLA HOBBIES

Ignore this mumble jumble up at the top of this screen. Since I'm closing down the shop, I'm not going to invest fixing something that is for the disabled shopping cart system. Unprofessional looking? Yes, but it adds a little personality, don't you think?

WELCOME TO VALHALLA HOBBIES' CLOSING UP SHOP SALE
(I know some of you are saying " I thought Ric was already out of business).
Well, I have taken the past year or so off to take care of some personal issues in my life and it is now time to start the long process of clearing out close to 1000 figures and accessory sets as well as countless parts.
If you look on the following pages, you will see various items, many of them rare or hard to find as well as many figures at or below cost. I'd prefer to make these available to fellow collectors first before I go the complete Ebay route.
As long as there is interest in the sale I will keep the site open.
More items will be appearing in the next few days and weeks as I get around to rebuilding the site's inventory (That's what I get for being a stupid webmaster and not selecting a website host that does daily backups.)

HOW TO ORDER
Take a look at the items in the categories. I will try to update them as often as possible.
You may contact me to order in 1 of 3 ways, email, text or phone call
1.) Email me your desired figures sales@valhallahobbies.com or my personal email hussar7@valhallahobbies.com
2.)contact me by text message at my cell # of 7174067690
3.)Call me at 7174067690, free to fellow AT&T cell phone customers. It may take me a little bit of time to get back to you by phone as I'm working extra hours and my bosses frown on cell calls during the day, though I can get away with texting at various intervals.

Methods of payment:
I currently accept money orders or Paypal payments. Sorry, those are the only 2 methods I currently use.

Shipping prices are easy:
$100 and less, $5 flat shipping fee
Over $100, shipping is free.

Thanks and I hope I we can do some business together,
-RIC DULL-

VALHALLA HOBBIES

NEW ARRIVALS

There are no available featured products...

Users online

7 unregistered customer(s)

Your cart

	Cart is empty

View cart
Checkout

Authentication

Username

Password

Recover password

If Javascript is disabled in your browser click here

Powered by MJOLNIR, THE HAMMER OF THOR, THE GOD OF THUNDER!!

Copyright © 2004-2012 VALHALLA HOBBIES