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 P.product_manufacturer_id=362578 AND ps.id = 954 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
Catalogue | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Catalogue



Found 75 results
| View per page
Refine your search

Deprecated: Creation of dynamic property Hannants\SearchFilters::$searchDirection is deprecated in /mnt/vault/Sync/Dessol/Sites/hannants.co.uk/php_includes/classes/SearchFilters.php on line 113
Manufacturer & Catalogue No ASC DESC
Scale ASC DESC
Description ASC DESC
Type ASC DESC
Department ASC DESC
Price ASC DESC
Watch
Stock ASC DESC
Buy

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK08007
Ersatz M7 2 in 1 German Sturmgeschutz/StuG.III Ausf.G self-propelled assault gun disguised as an American M7 'Priest' to infiltrate Allied positions during the Battle of the Bulge in the Ardennes in late 1944. Hatches can be fitted opened or closed, Link & Length tracks with track assembly jig, photo-etch parts. Two styles of engine cover. Markings for 150th Panzer Brigade (Kampfgruppe Y), Ardennes December 1944. Figures no...
Military vehicle kits (injection)
Catalogue
£44.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Takom TAK02096
1:35
Pz.Kpfw.VI King Tiger Initial Production 4 in 1 German Heavy Tank Hatches can be fitted opened or closed aâé-¢ Workable tracks aâé-¢ Choice of four markings aâé-¢ PE parts.
Military vehicle kits (injection)
Catalogue
£69.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02159
German Typ 205 Mƒ¤uschen concept Super Heavy Tank Little Mouse "Paper Panzer". Hatches can be fitted opened or closed, one-piece tracks, moveable suspension & road wheels. Choice of 4 markings.
Military vehicle kits (injection)
Catalogue
£57.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02158
German Vk 168.01(p) concept Super Heavy Tank A "Paper Panzer" that never progressed beyond blueprints. Hatches can be fitted opened or closed, one-piece tracks, moveable suspension & road wheels. Choice of 4 markings.
Military vehicle kits (injection)
Catalogue
£57.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02156
German VK 100.01 (p) Mammut, WWII Super-heavy Concept Tank 2-in-1 Another of the Third Reich's "what if?" tanks that was never built. Designs for the Versuchskampffahrzeug (VK) 'Mammut' (Mammoth) 120-ton super-heavy tank were drawn up in 1942, and while of massive proportions it was somewhat smaller than the 'Maus' super-heavy tank. Popularised in the online multiplayer video game 'World of Tanks'. Hatches can be fitted ope...
Military vehicle kits (injection)
Catalogue
£57.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02141
1:35
T3 + FeldUmschlagGerƒ¤t FUG 2.5t Military Fork Lift Truck and Minibus 2 in 1
Military vehicle kits (injection)
Catalogue
£65.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Takom TAK02001
Re-release! Object 279 Soviet Heavy Tank (3 in 1) Soviet experimental heavy tank developed in the late 1950s. Too expensive to produce, too complex to maintain and less mobile than other tanks, Object 279 was never put into production. One prototype was built and retained for display at Kubinka Tank Museum. Choice of 3 builds. Optional turret parts for 2 versions. Coloured photo-etch & figure included.
Military vehicle kits (injection)
Catalogue
£54.99
£49.49
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Takom TAK02062
Re-issue! AMX-13/105 Light Tank Dutch Army 2 in 1 French built light tank modified with a large calibre gun for the Koninklijke Landmacht (Royal Netherlands Army) in the early 1960s.
Military vehicle kits (injection)
Catalogue
£49.99
£44.99
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Takom TAK02066
Limited Re-issue! British APC FV432 Mk 2/1 with interior Armoured personnel carrier (APC) introduced in the 1960s. It is the most common armoured vehicle in the British Army and has been used in the Falklands War, the Gulf War and the War in Afghanistan. Hatches can be fitted opened or closed, Link & length tracks with jig assembly, photo-etch parts. Choice of 4 markings: (1) Berlin Brigade 1980; (2) Royal Scots Dragoon Guar...
Military vehicle kits (injection)
Catalogue
£49.99
£44.99
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02177
1:35
Swiss Panzerjƒ¤ger G 13 ca.1946-72 Post-war version of the German Jagdpanzer 38(t) Hetzer developed during World War II. 158 Hetzers were ordered by the Swiss Army in 1946/47 as type Panzerjƒ¤ger G 13. Improvements included StuK 40 gun with muzzle brake, AA gun, and revised position for the tank commander. Retired by the army in the early 1970s many of these tanks have since been preserved in museums, often disguised as WWII ...
Military vehicle kits (injection)
Catalogue
£37.99
£34.19
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02608
Bell/Boeing AH-64D Apache Longbow Attack Helicopter Block II Late.US-built AH-64A & AH-64D rotorcraft remanufactured and converted to enhanced "Block II" specification including new avionics, digital enhancements and communications upgrades, first delivered in early 2003 New parts, blade fold kit, photo-etch. Two pilot figures included. Choice of 4 markings.
Aircraft kits (injection)
Catalogue
£94.99
£85.49
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK08015
1:35
German StuG III Ausf.F Late Production with 7.5cm L48, ca.1942 Improved version of the StuG III Ausf.F assault gun. Changes included a longer 7.5cm StuK 40 L/48 gun which had a higher muzzle velocity and improved armour penetration. Takom Blitz series. Metal barrel included. Hatches can be fitted opened or closed. Link & Length tracks, photo-etch parts. Choice of 4 markings. (Figure not included).
Military vehicle kits (injection)
Catalogue
£49.99
£44.99
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK08016
German 10.5cm StuH 42 Ausf.E/F, ca.1942-43 Sturmhaubitze 42 (StuH 42) assault howitzer was a variant of the Sturmgeschutz/StuG.III assault gun armed with a 10.5 cm leFH 18 howitzer instead of the standard 7.5 cm Sturmpanzerkanone 40 (StuK 40) L/48 gun. Takom Blitz series. Metal barrel included. Hatches can be fitted opened or closed. Link & Length tracks, photo-etch parts. Choice of 4 markings. (Figure not included).
Military vehicle kits (injection)
Catalogue
£49.99
£44.99
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02170
Jagdpanzer 38(t) Hetzer with interior, Early Production The Hetzer was a German light tank destroyer of the Second World War. It was based on the of the Panzer 38(t) light tank chassis and armed with a 75mm PaK 39 L/48 gun. The low-profile, heavily armoured tank destroyer could be used to ambush enemy tanks and is acknowledged as one of the most successful tank destroyers of WWII, destroying hundreds of enemy tanks. Full int...
Military vehicle kits (injection)
Catalogue
£52.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02171
Jagdpanzer 38(t) Hetzer with interior, Mid Production The Hetzer was a German light tank destroyer of the Second World War. It was based on the of the Panzer 38(t) light tank chassis and armed with a 75mm PaK 39 L/48 gun. The low-profile, heavily armoured tank destroyer could be used to ambush enemy tanks and is acknowledged as one of the most successful tank destroyers of WWII, destroying hundreds of enemy tanks. Full inter...
Military vehicle kits (injection)
Catalogue
£52.99
-
In Stock
3

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02173
Russian KamAZ Typhoon K w/ RP-377VM1 & Arbalet-DM RCWS module Russian mine resistant ambush protected (MRAP) 6x6 based on KamAZ-63968 chassis. Roof-mounted radio fuse jammer type RP-377VM1 and remote controlled weapon station (RCWS) type Arbalet-DM with 12.7mm machine gun are the distinguishing features of this version. 2 in 1 kit with new parts for RP-377VM1 & Arbalet-DM RCWS. Detailed interior (excluding engine). Ha...
Military vehicle kits (injection)
Catalogue
£54.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02174
Pz.Kpfw.V Ausf.A Panther Early The Panzerkampfwagen Pz.Kpfw.V Ausf.A Panther was the first production variant of the German Panther tank. It was introduced in 1943 and was used on the Eastern and Western Fronts until the end of the war in May 1945. Hatches can be fitted open or closed, link & length tracks, photo-etch parts. Choice of 4 markings. (Interior parts & Zimmerit not included).
Military vehicle kits (injection)
Catalogue
£49.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02175
1:35
Pz.Kpfw.V Ausf.A Panther Early/Mid The Panzerkampfwagen Pz.Kpfw.V Ausf.A Panther was the first production variant of the German Panther tank. It was introduced in 1943 and was used on the Eastern and Western Fronts until the end of the war in May 1945. Optional build as early or medium version. Hatches can be fitted open or closed, link & length tracks, photo-etch parts. Choice of 3 markings. (Interior parts, Zimmerit & figu...
Military vehicle kits (injection)
Catalogue
£49.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02176
Pz.Kpfw.V Ausf.A Panther Late Sd.Kfz.171/268 2 in 1 The Panzerkampfwagen Pz.Kpfw.V Ausf.A Panther was the first production variant of the German Panther tank. It was introduced in 1943 and was used on the Eastern and Western Fronts until the end of the war in May 1945. Optional build as command or non-command version. Hatches can be fitted open or closed, link & length tracks, photo-etch parts. Choice of 4 markings. (Interio...
Military vehicle kits (injection)
Catalogue
£49.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02607
JGSDF AH-64D Apache Longbow Attack Helicopter Japan Ground Self-Defense Force Apache helicopter licence-built by Fuji Heavy Industries. Photo-etch & clear parts included. Choice of 3 markings. (Figure not included).
Aircraft kits (injection)
Catalogue
£89.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02139
US M103A1 Heavy Tank c.1959 America's last heavy tank, a large-turreted tracked platform for the long-range 120mm cannon developed during the Cold War. Derived from the late WW2 T29/T34 heavy tank, type T43E1 built in 1953/54 was modified in 1956/57 to serve with the US Army in overwatch role redesignated M103. Upgraded type M103A1 was preferred by the US Marine Corps for infantry support in amphibious campaigns. The Army rec...
Military vehicle kits (injection)
Catalogue
£62.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02169
US MQ-8B Fire Scout with missile & Blade Fold kit US Navy Unmanned Autonomous Helicopter (UAH) with 4-blade rotor & stub wings. Rotor-fold version with alternative nose sections, APKWS guided rocket pods & twin Hellfire missiles, photo-etch parts. Choice of 4 markings. L: 265mm. (Figure not included).
Aircraft kits (injection)
Catalogue
£31.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02605
IAF AH-64DI Saraf (Saraph) Longbow Attack Helicopter The Israeli Air Force operates modified AH-64D helicopters. This new kit from Takom provides the necessary parts to build an Israeli Apache. New parts include Rokar helicopter Countermeasures Dispensing System (CMDS); On-the-Move Satellite Communication (EL/K SATCOM); Reduced Size Crashworthy External Fuel System (RCEFS). Photo-etch parts. Choice of 3 markings.
Aircraft kits (injection)
Catalogue
£99.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK02606
D of the World AH-64D Apache Longbow (Limited Edition) Other US-built Apache Longbow helicopters in service with overseas nations. Limited edition release. Choice of 5 markings for Hellenic Army, Kuwait Air Force; Royal Netherlands Air Force, Republic of Singapore Air Force, United Arab Emirates Air Force.
Aircraft kits (injection)
Catalogue
£99.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Takom TAK08012
German Jagdtiger Sd.Kfz.186 Porsche turret with Zimmerit New Takom BLITZ series model kit of the heaviest armoured fighting vehicle of World War II based on a lengthened Tiger II chassis. 2Upper hull moulded with anti-tank mine 'Zimmerit' coating. Metal barrel included. Hatches can be fitted opened or closed. Moveable suspension & road wheels, workable tracks, photo-etch parts. Markings for one tank.
Military vehicle kits (injection)
Catalogue
£51.99
-
In Stock
5+

   1   |   2   |   3      »      [3]

Search Area Manufacturer Item Type Search

Part Number Scale Keywords Results per Page
Exact Match
Sort by:
Sort Direction:
Added Within last week
last 2 weeks
last month
last 6 months
last year