logo Magic the Gathering, Gathering Yugioh, and Pokemon cards from a Professional UK Supplier
Psisoft Games
HOME    LOGIN    SHOPPING CART    WHAT'S NEW?    a1 AUCTIONS    a4 FAVOURITE    a6 SPECIALS    CONTACT US
a Quick Find b
bg1
 
Show Stock Outs.
Ability Search.
Use keywords to find the product you are looking for.
Advanced Search
bg2
c d
a Categories b
bg1
Accessories->

Bargains

Board Games

Card Games->

Miniatures Games->

Other Games->

View All Products ->

All Products sorted by Categories ->

All Products sorted by Manufacturers ->
bg2
c d
Coldsnap Show:
The Recently discovered legendary Lost Third Set of the Ice Age Block "Coldsnap" will feature 155 all New Cards (65 commons, 50 uncommons, and 40 rares). The card wordings will all be updated to work with current Magic rules (no "interrupts") and will include such modern niceties as expansion symbols color-coded by rarity, collector numbers, and foils. The set becomes legal for Standard constructed tournaments on August 20th 2006.

Available in boosters, theme decks, and a Fat Pack for this release. Since this is the third set of the Ice Age block, the theme decks will include a few cards from the first two sets of the block. For those cards Magic will be updating them to the new card frames (since Coldsnap uses the new card frames), but will be keeping their original art.
a Coldsnap a
box_bg_l.gif.
Displaying 161 to 180 (of 257 products) Result Pages: [<< Prev]   1  2  3  4  5  6  7  8  9  10 ...  [Next >>] 
Checkout
1064 - You have an error in your SQL syntax near 'limit 160, 20' at line 1

select p.products_image, pd.products_name, p.products_rarity, p.products_edition, p.products_quantity, p.products_id, p.products_status, p.manufacturers_id, p.products_price, e.edition_name, r.rarity_desc, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join psi_rarities r on p.products_rarity = r.rarity left join psi_editions e on e.edition_abb = p.products_edition left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '104377' and p.products_status = '1' order by limit 160, 20

[TEP STOP]