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=362691 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
Catalogue | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Catalogue



Found 44 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 115
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
Eduard kits EDK7044
Aero L-39C Albatros Profipack. EDUARD-PROFIPACK The ProfiPACK edition kit of the Czechoslovak subsonic jet trainer L-39C Albatros in 1/72 scale.- plastic parts: Eduard- marking options: 6- decals: Eduard- PE parts: yes, pre-painted- painting mask: yes COL A 5254 L-39CM, s/n 915254, 2 Fighter Squadron, 31 Fighter Wing, Slovak Air Force, Slia? AFB, Slovakia, 2022 COL B 0445 L-39C, No. 0445, Pardubice, Czech Republic, 2023...
Aircraft kits (injection)
Catalogue
£12.99
£11.69
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

Eduard kits EDK7071
Nieuport N.17 DUAL COMBO (makes 2 complete kits) SPECIAL LOW PRICE! LIMITED! NO MORE WHEN SOLD!
Aircraft kits (injection)
Catalogue
£9.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
Eduard kits EDK70151
Avia S-199 bubble canopy ProfiPACK edition kit of Czechoslovak single engine fighter Avia S-199 with bubble canopy in 1/72 scale. - plastic parts: Eduard - marking options: 6 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes - resin parts: no
Aircraft kits (injection)
Catalogue
£16.30
-
In Stock
10+

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
Eduard kits EDK2144
GUSTAV pt.1 DUAL COMBO New tool edition! First release! The Limited edition of the kit of the famous German WWII fighter aircraft Bf-109G in 1/72 scale. The kit offers aircraft of G-5 and G-6 versions. Marking selection covers all fronts of WWII where these aâé-l"Gustavsaâé- were fighting including airplanes from the Ilmavoimat (Finish Air Force), Italian Aeronautica Nazionale Repubblicana and Slovak aircraft from National Urprisi...
Aircraft kits (injection)
Catalogue
£25.50
£22.95
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

Eduard kits EDK7059
1:72
Re-released! Mikoyan MiG-15bis ProfiPACK edition kit of Soviet Cold War jet aircraft MiG-15bis in 1/72 scale. - plastic parts: Eduard - marking options: 5 - decals: Eduard - PE parts: yes, pre-painted, - painting mask: yes, - resin parts: no COL 1 flown by Maj. Mikhail Ivanovich Mikhin, 518th IAP, North Korea, May 1953 COL 2 c/n 613234, kpt. Old?ich Paldus, 15th Fighter Regiment, Czechoslovak Air Force, Cottbus Airfield...
Aircraft kits (injection)
Catalogue
£13.99
£12.59
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
Eduard kits EDK7406
Albatros D.V 1/72 Re-released Weekend edition kit of German WWI fighter plane Albatros D.V in 1/72 scale. Plastic parts: Eduard; No. of decal options: 4; decals: Eduard; PE parts: no; painting mask: no; resin parts: no
Aircraft kits (injection)
Catalogue
£10.30
£9.27
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
Eduard kits EDK7472
Avia S-199 ERLA canopy 1/72 The Weekend edition kit of Czechoslovak single engine fighter Avia S-199 with ERLA canopy in 1/72 scale. This type of aircraft was used by the Czechoslovak and Israeli air forces. Plastic parts: Eduard; marking options: 4; decals: Eduard; PE parts: no; painting mask: no; resin parts: no COL A D-121, 101 Squadron (tayeset), Chel Ha Avir, Qastina, Israel, September 1948 COL B D-115, 101 Squadron (...
Aircraft kits (injection)
Catalogue
£11.99
£10.79
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

Eduard kits EDK7039
1:72
Re-released! Fokker Dr.I Triplane 1/72 ProfiPACK edition kit of famous German WWI triplane fighter aircraft Fokker Dr.I in 1/72 scale. Plastic parts: Eduard , Decal options: 5; Decals: Eduard; PE parts: yes, color; Painting mask: yes; Resin parts: no A-450/17, flown by Lt. J. Jacobs, Jasta 7, Rumbeke, Belgium, March 1918 B-545/17, flown by Lt. H. Weiss, Jasta 11, Cappy, France, April 1918 C-425/17, flown by Rittm. Manfred...
Aircraft kits (injection)
Catalogue
£10.30
-
In Stock
6

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
Eduard kits EDK7471
Avia S-199 bubble canopy The Weekend edition kit of Czechoslovak single engine fighter Avia Avia S-199 with bubble canopy in 1/72 scale. Plastic parts: Eduard; marking options: 4; decals: Eduard; PE parts: no, painting mask: no; resin parts: no. 1 / 4 S-199 bubble canopy 1/72 - S-199.444, 2 Squadron, 1 Aviation Regiment, 3 Air Division, Praha-Kbely, Czechoslovakia, April 1951 2 / 4 S-199 bubble canopy 1/72 - S-199.165, 1...
Aircraft kits (injection)
Catalogue
£11.99
-
In Stock
20+

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

Eduard kits EDK70112
1:72
Re-released! Focke-Wulf Fw-190A-8/R2 ProfiPACK edition - plastic parts: Eduard - No. of decal options: 5 - decals: Eduard - PE parts: yes - painting mask: yes - resin parts: no
Aircraft kits (injection)
Catalogue
£11.99
-
In Stock
20+

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

Eduard kits EDK70121
Re-released! Supermarine Spitfire Mk.IXc late version Very first release of kit from Eduard tool made in 2016, decals printed by Eduard kits, PE and mask included, 6 marking options. Full color instructions.
Aircraft kits (injection)
Catalogue
£11.99
-
In Stock
20+

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
Eduard kits EDK70154
Messerschmitt Bf-109F-2 The ProfiPACK edition kit of German WWII fighter plane Messerschmitt Bf-109F-2 in 1/72 scale. - plastic parts:Eduard - marking options: 6 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes A-WNr. 8117, Maj. Gƒ¼nther Lƒ¼tzow, CO of JG 3, Polonnoye, The Soviet Union, Summer 1941 B-WNr. 6720, Oblt. Egon Mayer, CO of 7./JG 2, St. Pol-Brias, France, September 1941 C-WNr. 6797, Hptm. Hartma...
Aircraft kits (injection)
Catalogue
£14.20
-
In Stock
10+

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

Eduard kits EDK70142
1:72
Mikoyan MiG-21MF Fighter Bomber 1/72 ProfiPack edition of 1/72 scale kit of Cold War jet aircraft MiG-21MF. - plastic parts: Eduard - No. of decal options: 5 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes - resin parts: no
Aircraft kits (injection)
Catalogue
£17.20
-
In Stock
10+

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
Eduard kits EDK70155
Messerschmitt Bf-109F-4 1/72 The ProfiPACK edition kit of German WWII fighter plane Messerschmitt Bf-109F-4 in 1/72 scale. - plastic parts:Eduard - marking options: 6 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes
Aircraft kits (injection)
Catalogue
£14.40
-
In Stock
10+

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
Eduard kits EDK7470
Focke-Wulf Fw-190A-5 The Weekend edition kit of German WWII fighter plane Fw-190A-5 in 1/72 scale. - plastic parts: Eduard - marking options: 4 - decals: Eduard - PE parts: no - painting mask: no - resin parts: no
Aircraft kits (injection)
Catalogue
£11.99
-
In Stock
20+

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
Eduard kits EDK2142
Messerschmitt Bf-109F double pack. NEW TOOLING! WUNDERSCHĮ'NE NEUE MASCHINEN part 1, is the 1/72 scale Limited Edition Dual Combo, dedicated to Messerschmitt Bf-109F-2 and Bf-109F-4. The kit includes two sets of frames, containing two fuselage versions and three wing versions, used on different developmental variants of the Bf-109F-1, F-2 and F-4. The kit offers 14 decal options, one F-1, six F-2 and seven F-4, including tr...
Aircraft kits (injection)
Catalogue
£26.50
-
In Stock
14

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
Eduard kits EDK7456
Let Z-37A Cmelak Weekend edition kit of Czechoslovak agricultural aircraft Z-37A Cmelak n scale. - plastic parts: Eduard - marking options: 4 - decals: Eduard - PE parts: no - painting mask: no
Aircraft kits (injection)
Catalogue
£11.99
-
In Stock
10

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

Eduard kits EDK70119
Re-released! Fock-Wulf Fw-190F-8 ProfiPACK edition kit of German WWII fighter aircraft Fw-190F-8 in 1/72 scale. Version F was used for attacks against ground targets. plastic parts: Eduard kits, marking options: 5, decals: Eduard- PE parts: yes, pre-painted- painting mask: yes- resin parts: no
Aircraft kits (injection)
Catalogue
£14.40
-
In Stock
10+

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
Eduard kits EDK7467
1:72
Focke-Wulf Fw-190A-8/R2 Weekend edition kit of German WWII fighter aircraft Fw-190A-8/R2 in 1/72 scale. The kit offers Sturmbocks served in JG 3, JG 4 and JG 300. - plastic parts: Eduard - marking options: 4 - decals: Eduard - PE parts: no - painting mask:no - resin part 1 / 4 Fw-190A-8/ R2 1/72 - WNr. 681382, Hptm. Wilhelm Moritz, Stab IV./JG 3, Schongau, Germany, August 1944 2 / 4 Fw-190A-8/ R2 1/72 - WNr. 680747, Oblt...
Aircraft kits (injection)
Catalogue
£11.99
-
In Stock
20+

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
Eduard kits EDK7469
Mikoyan MiG-21MF Interceptor Weekend edition kit of Soviet Cold war jet fighter aircraft MiG-21MF interceptor in 1/72 scale. - plastic parts: Eduard - No. of decal options: 4 - decals: Eduard - PE parts: no - painting mask: no - resin parts: no 1 / 4 MiG-21MF Interceptor 1/72 - 1 Squadron, 9 Fighter Bomber Air Regiment, Bechyn?, Czech Republic, September 1993 2 / 4 MiG-21MF Interceptor 1/72 - 116 CBP (116 Combat Training...
Aircraft kits (injection)
Catalogue
£13.30
-
In Stock
18

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

Eduard kits EDK7055
1:72
Re-released! Mikoyan MiG-15UTI 1/72 ProfiPACK edition kit of Soviet two-seat jet trainer aircraft UTI MiG-15 in 1/72 scale. plastic parts: Eduard- marking options: 5 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes - resin parts: no
Aircraft kits (injection)
Catalogue
£16.30
-
In Stock
7

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
Eduard kits EDK7033
Messerschmitt Bf-109E-4 1/72 kits) ProfiPACK edition kit of German WWII fighter plane Messerschmitt Bf-109E-4 in 1/72 scale. - plastic parts: Special Hobby - marking options: 6 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes - resin parts: no 1 / 6 Bf-109E-4 1/72 - WNr. 2060, Lt. Hans Guse, 2.(J)/LG 2, Tudora, Soviet Union (Republic of Moldova today), July 1941 2 / 6 Bf-109E-4 1/72 - WNr. 5901, Oblt. W...
Aircraft kits (injection)
Catalogue
£16.30
-
In Stock
20+

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
Eduard kits EDK7468
Messerschmitt Bf-110G-2 1/72 kits) Weekend edition kit of German WWII twin-engine multi role aircraft Messerschmitt Bf-110G-2 in 1/72 scale. This version of the Messerschmitt Bf-110 was used in the role fighter-bomber, fast bomber and destroyer, often used against Allied heavy bombers, equ 1 / 4 Messerschmitt Bf-110G-2 1/72 - Messerschmitt Bf-110G-2/R7/M2, 6./ZG 1, Brest, France, August 1943 2 / 4 Messerschmitt Bf-110G-2 1/7...
Aircraft kits (injection)
Catalogue
£27.70
-
In Stock
20+

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
Eduard kits EDK7012
North-American B-25J Mitchell STRAFER 1/72 ProfiPACK edition kit of US WWII medium bomber B-25J Mitchell with solid nose in 1/72 scale. The kit is focused on planes used in attack on ground targets from low level sky on the battlefields of the Pacific and Southeast Asia. Plastic parts: Hasegawa, marking: 5, PE parts, painting mask. 1 / 5 B-25J Mitchell STRAFER 1/72 - B-25J-30, 44-30934, 1/Lt Charles E. Rice, Jr., 449th BS, ...
Aircraft kits (injection)
Catalogue
£40.99
-
In Stock
9

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

Eduard kits EDK7083
Messerschmitt Bf-110E ProfiPACK edition kit of German WWII twin-engine heavy fighter aircraft Messerschmitt Bf-110E in 1/72 scale. plastic parts: Eduard- marking options: 5- decals: Eduard- PE parts: yes, pre-painted- painting mask: yes- resin parts: no 1 / 4 G9+JM, 4./NJG 1, St. Trond, France, February 1942 2 / 4 S9+NN, 5./ZG "Wespen", Lt. Herbert Kutscha, Russia, 1942 3 / 4 LN+LR, 1.(Z)/JG 77, Lt. Felix-Maria Brandi...
Aircraft kits (injection)
Catalogue
£23.60
-
In Stock
10+

   1   |   2      »      [2]

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