Catalogue

SELECT /* MAIN SEARCH QUERY */ pm.name AS manufacturer, pm.name AS manufacturer_name, P.id, P.id AS product_id, P.code, P.cost_price, P.vat_enabled, P.description, P.sold_retail, P.sold_trade, P.sold_wholesale, P.country_origin_code, P.commodity_code, P.price_set, P.width, P.height, P.length, P.product_scale_id, P.reorder_level, P.release_date, P.weight, P.restriction, P.restriction_bit, P.active, P.minimum_level, P.second_hand, P.limited_availability, P.can_reorder, P.warehouse_zone_id, P.wholesale_customers, P.new_price, P.big_postage, P.disable_min_order_amount, P.last_updated, P.notes, P.old_product_scale_txt, P.has_image_200, P.has_image_400, P.last_purchase_order_stock, P.last_purchase_order_date, P.first_delivered_date, P.last_moved, P.scale_string, P.keywords, P.finished_date, P.availability, P.sold, P.sold_total, P.sold_retail, P.sold_trade, P.sold_wholesale, P.base_price, P.base_export_price, P.retail_discount, P.eu_price, P.export_price, P.trade_price, P.trade_export, P.wholesale_price, P.wholesale_export, P.discount, P.backorder_retail_discount, P.backorder_discount, P.trade_discount, P.wholesale_discount, P.product_category_id, P.product_division_id, P.product_type_id, P.product_manufacturer_id, GROUP_CONCAT(DISTINCT ps.scale ORDER BY ps.scale ASC SEPARATOR ', ') AS scale, UNIX_TIMESTAMP(P.date_added) AS date_added, UNIX_TIMESTAMP(P.arrival_date) AS arrival_date , DATE(P.arrival_date) AS real_arrival_date , pt.name AS product_type, pt.name AS type_name, media.filename, IF (pp.id is null,0,1) as pending, if( coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) ) , 0 ) >= 0 , if( coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) >= P.show_stock, P.show_stock , coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) ) , 0 ) as available, COALESCE(sl.count,0) as stock_level, COALESCE(sc.product_quantity,0) AS stock_committed, COALESCE(bv.backorders,0) AS backorders, COALESCE(bv.free_backorders,0) AS free_backorders, pc.id as department_id, pc.name as department, pc.name as department_name, P.show_stock, if( pc.name = 'Future Releases', true, false ) AS future, unix_timestamp(media.date_uploaded) as unixtime FROM product P LEFT JOIN stock_level sl on P.id = sl.product_id LEFT JOIN stock_committed sc on sc.product_id = P.id LEFT JOIN backorder_values bv ON bv.product_id = P.id LEFT JOIN product_category pc on P.product_category_id = pc.id LEFT JOIN product_manufacturer pm ON P.product_manufacturer_id = pm.id LEFT JOIN product_media media ON P.id = media.product_id AND `media`.`order` = 0 JOIN product_scale_map AS psm ON (psm.product_id = P.id) LEFT JOIN product_scale ps ON (psm.scale_id = ps.id) LEFT JOIN product_type pt ON P.product_type_id = pt.id LEFT JOIN pending_product pp ON P.id = pp.id WHERE 1 AND P.restriction_bit & 1 = 1 AND pt.id=1897 AND ps.id = 956 AND P.price_set = 1 AND P.product_category_id = 102 AND pc.show_in_search = 1 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE(P.arrival_date) desc, P.code

Cookie name	Description
existing_user	Stores the email address used to previously log into the site, used to prefill forms like on the reset password screen
authchallenge	Authentication security checks
hcart	Stores the anonymous customer\'s cart token. If items are added to the card while not logged in, if you log in the items will be added to the customer\'s existing cart
hannants	Stores the session information while you remain on the site
pricer	Stores if the export or eu prices is selected on the catalogue page
hidefilter	Stores if the search filter panel is hidden or shown
AWSELB	Stores which server you\'re connected to so to access the same server while you navigate around the site
__utma __utmb __utmc __utmz	Google analytics related cookies

Scale

Description

Type

Department

Price

Watch

Stock

Buy

IBG Models IBG72U029

Bedford QL Wheels (Pattern 1 Good Year TRACTION ) - 3D-Printed (designed to be used with IBG Models kits)

Military vehicle detailing sets (resin)

Catalogue

£8.99

Add to watchlist

IBG Models IBG72U030

Bedford QL Wheels (Pattern 2 AVON) - 3D-Printed (designed to be used with IBG Models kits)

Military vehicle detailing sets (resin)

Catalogue

£8.99

Add to watchlist

CMK/Czech Master Kits CMF72400

1:72

Marder Tank Destroyer Commander and Gunner Two crew figures in this set portray a commander and a gunner of a Marder tank destroyer. Made to fit the Special Armour line Marder II kit made by Special Hobby. In fact, these two can be used with any German WW2 tank destroyers or even another type of military vehicles.

Military vehicle detailing sets (resin)

Catalogue

£8.10

Master GM-72-023

Pz.Kpfw.VI Tiger I - gun mantlets - 3 optional types - to be used with gun barrels from sets GM-72-021 & GM-72-022

Military vehicle detailing sets (resin)

Catalogue

£6.99

Master GM-72-024

MG-34 (7.92mm) - German machine gun barrels - version with drilled cooling jacket - used by infantry and on early tanks (2pcs)

Military vehicle detailing sets (resin)

Catalogue

£6.60

JKT JKT72009

1:72

German WWII Flak 20mm ammo - 140 pcs (PUR parts) (designed to be used with Ace and MAC Distribution kits) [20mm Flak 38]

Military vehicle detailing sets (resin)

Catalogue

£6.30

JKT JKT72011

1:72

Vickers 7,7 mm for the WWI tank Mk.I Female (designed to be used with Masterbox kits)

Military vehicle detailing sets (resin)

Catalogue

£5.85

JKT JKT72029

1:72

10.5cm StuH.42 Ausf.E/F with Saukopfblende early version (designed to be used with Dragon kits)

Military vehicle detailing sets (resin)

Catalogue

£8.50

JKT JKT72059

Zimmerit for Pz.Kpfw.VI Ausf.B Konigstiger/King Tiger (designed to be used with FLYHAWK kits)

Military vehicle detailing sets (resin)

Catalogue

£11.99

CMK/Czech Master Kits CMB72107

15cm Nebelwerfer 41 / 3,7 cm PaK 36 wheels (designed to be used with Special Armour kits)

Military vehicle detailing sets (resin)

Catalogue

£3.60

CMK/Czech Master Kits CMB72106

Sd.Kfz.250/1 and Sd.Kfz.10 tracks (designed to be used with Special Armour kits)

Military vehicle detailing sets (resin)

Catalogue

£8.99

CMK/Czech Master Kits CMB72105

Sd.Kfz.250 / Sd.Kfz.10 Wheels 1/72 / (designed to be used with Special Armour kits). Our detailed wheels with patterned tires are intended for the Sd.Kfz.10 and Sd.Kfz.250 half trucks from Special Armour.

Military vehicle detailing sets (resin)

Catalogue

£3.60

Blackdog BDT72131

Crusader accessories set (designed to be used with IBG Models kits)[Mk.I Mk.II Mk.III]

Military vehicle detailing sets (resin)

Catalogue

£16.10

Master GM-72-009

1:72

Polish tankette TKS - Hotchkiss wz.25 with mount (resin and turned parts)

Military vehicle detailing sets (resin)

Catalogue

£7.10

Master GM-72-011

1:72

Bofors 40mm Anti-Aircraft gun barrel - for Crusader Mk. III AA from IBG and other Bofors 40mm kits (e.g. Zvezda, FTF, CMK) (designed to be used with CNK, IBG and Zvezda kits)

Military vehicle detailing sets (resin)

Catalogue

£8.30

CMK/Czech Master Kits CMB72104

Sd.Ah 115 Wheels. The new Special Armour's Sd.Ah 115 kit will benefit from using this set of finely detailed resin cast wheels which, compared with the styrene items, brings substantially higher levels of detail and much nicer tyre tread pattern. (designed to be used with Special Armour kits)

Military vehicle detailing sets (resin)

Catalogue

£8.60

CMK/Czech Master Kits CMB72103

Sd.Kfz.131 Marder II This set has been designed for Special Armour Marder II kit SA72001. It contains wood crates which the crews placed on top of the vehicle body on the fenders. Crew helmets were usually carried hung on the armour plates. This set can be used for almost any German WW2 military vehicle. (designed to be used with Special Hobby kits)

Military vehicle detailing sets (resin)

Catalogue

£4.50

CMK/Czech Master Kits CMB72102

1:72

'Biber' German Midget Submarine Trailer wheels (designed to be used with Special Navy kits)

Military vehicle detailing sets (resin)

Catalogue

£8.60

Blackdog BDT72112

Universal (Bren) Gun Carrier Mk.II accessories set (designed to be used with IBG Models kits)

Military vehicle detailing sets (resin)

Catalogue

£10.65

CMK/Czech Master Kits CMB72100

1:72

Meillerwagen A4/V-2 transporter wheel set. Nine new and detailed wheels (eight + one spare) that offer more details and have tyres with sharply rendered tread pattern. To be used with your Meillerwagen A4/V2 missiles transporter. (designed to be used with Special Armour kits)

Military vehicle detailing sets (resin)

Catalogue

£9.70

Schatton Modellbau SCH72011

1:72

Cover for Mercedes MB L-4500 or trailer (designed to be used with Schatton Modellbau kits)

Military vehicle detailing sets (resin)

Catalogue

£6.99

Add to watchlist

CMK/Czech Master Kits CMK2025

1:72

Pz.Kpfw.VI Tiger I Late version interior set (designed to be used with Revell kits)

Military vehicle detailing sets (resin)

Catalogue

£14.60

CMK/Czech Master Kits CMK2026

1:72

Pz.Kpfw.VI Tiger I Later version road wheels/torque arems (designed to be used with Revell kits)

Military vehicle detailing sets (resin)

Catalogue

£3.80

Planet Models PLAMV064

1:72

equipment for M1A1 Abrams Iraq war

Military vehicle detailing sets (resin)

Catalogue

£13.30

Planet Models PLAMV065

equipment for British Challenger 1

Military vehicle detailing sets (resin)

Catalogue

£13.30

Search Area	Manufacturer		Item Type

Part Number	Scale	Keywords	Results per Page	Only discounted retail price
		Exact Match
Only Show Items In Stock	Only Show Items With Pictures	Sort by: Sort Direction:

Cookies