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 = 955 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 119 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 EDK11170
GUADALCANAL DUAL COMBO Limited edition kit of US carrier based fighter Grumman F4F-4 Wildcat early and late production in 1/48 scale. Kit presents Wildcats from United States Navy and Marine Corps participating in the fighting for Guadalcanal. - plastic parts:Eduard - marking option 1 / 12 GUADALCANAL DUAL COMBO 1/48 - Lt. Stanley W. Vejtasa, VF-10, USS Enterprise, April 1943 2 / 12 GUADALCANAL DUAL COMBO 1/48 - BuNo. 5192, ...
Aircraft kits (injection)
Catalogue
£59.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

Eduard kits EDK8148
RE-RELEASED!!! Polikarpov I-16 type 10 RELEASE EXPECTED LATE JANUARY!!! EDUARD-PROFIPACK. The ProfiPACK edition kit of Soviet pre-war and WWII fighter plane I-16 Type 10 in 1/48 scale. - plastic parts: Eduard- marking options: 4- decals: Eduard- PE parts: yes, pre-painted- painting mask: yes- resin parts: no
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

No Image
Eduard kits EDK8208
Messerschmitt Bf-110G-4 Profipack edition kit of German night fighter Bf-110G-4 in 1/48 scale. Focused on machine with FuG 202 radar. - plastic parts: Eduard - marking options: 5 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes Limited re-release!
Aircraft kits (injection)
Catalogue
£36.30
£32.67
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 EDK82161
Messerschmitt Bf-109G-10 WNF/Diana ProfiPACK edition kit of German WWII fighter aircraft Messerschmitt Bf-109G-10 in scale. The kit is focused on 109s produced by Wiener Neustƒ¤dter Flugzeugwerke / Diana. Plastic parts: Eduard kits, No. of decal options: 5, decals: Eduard kits, PE parts: yes, pre-painted, painting mask: yes, resin parts: no RE-RELEASED! Bf-109G-10 WNF/ Diana 1/48 - Bf-109G-10/U4, Jasta 5 der ROA, Nemecky Br...
Aircraft kits (injection)
Catalogue
£28.60
£25.74
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 EDK84198
Supermarine Spitfire Mk.Vb early Weekend Series The Weekend edition kit of British WWII fighter plane Spitfire Mk.Vb in 1/48 scale. All Spitfires are early version with armor glass before the windshield and have under the wings symetrical bulges. plastic parts: Eduard- marking options: 4- decals: Eduard COL A W3312, S/Ldr James Rankin, No. 92 Squadron, RAF Biggin Hill, Velkƒi Britƒinie, ?ervensrpen 1941 COL B W3312, W/C...
Aircraft kits (injection)
Catalogue
£19.60
£17.64
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 EDK8483
Fokker D.VIIF Weekend Series The Weekend edition kit of German WWI fighter aircraft Fokker D.VIIF in 1/48 scale. These Fokker D.VIIs are manufactured at the Fokker factory in Schwerin and were powered by BMW IIIa engines.- plastic parts: Eduard- marking options: 4- decals: Eduard COL A Lt. Olivier Freiherr von Beaulieu-Marconnay, Jasta 19, Stenay, Francie, zƒi?ƒ 1918 COL B 378/18, Lt. Ernst Udet, Jasta 4, Monthussart Ferm...
Aircraft kits (injection)
Catalogue
£19.60
£17.64
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 EDK8114
Albatros D.III New edition The ProfiPACK edition kit of German WWI fighter aircraft Albatros D.III in 1/48 scale. - plastic parts: Eduard - marking options: 6 - decals: Eduard - PE parts: yes, pre-painted - painting mask: yes - resin parts: no COL A Oblt. Rudolf Berthold, Jasta 18, Harelbeke, Belgium, September 1917 COL B D.2006/16, Lt. Lothar & Rtm. Manfred Freiherr von Richthofen, Jasta 11, La Brayelle, France, Marchaâé-...
Aircraft kits (injection)
Catalogue
£17.20
£15.48
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 EDK84124
Mikoyan MiG-21PFM SPECIAL LOW PRICE! LIMITED! NO MORE WHEN SOLD!
Aircraft kits (injection)
Catalogue
£14.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 EDK84172
Re-released! North-American P-51D-5 Mustang Weekend edition kit of US WWII fighter P-51D-5 in 1/48 scale. The kit is focused on aircraft without the dorsal fin assembly. - plastic parts: Eduard - marking options: 4 - decals: Eduard - PE parts: no - painting mask:no - resin parts: no COL 1 44-13761, Capt. Jack M. Ilfrey, 79th FS, 20th FG, 8th AF, USAAF Station 367 Kings Cliffe, Northamptonshire, Great Britain, autumn 1944 ...
Aircraft kits (injection)
Catalogue
£19.60
£17.64
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 EDK84197
Messerschmitt Bf-109K-4 The Weekend edition kit of German WWII fighter aircraft Bf-109K-4 in 1/48 scale. - plastic parts: Eduard - marking options: 4 - decals: Eduard - PE parts: no - painting mask: no - resin parts: no COL A WNr. 332529, Stab JG 52, Deutsch Brod, Protectorate of Bohemia and Moravia, May 1945 COL B WNr. 330204, Hptm. Franz Mentzel, 9./JG 77, Neuruppin, Germany, November 1944 COL C WNr. 330255, Stab I...
Aircraft kits (injection)
Catalogue
£19.60
£17.64
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 EDK8438
Albatros D.III SPECIAL LOW PRICE! LIMITED! NO MORE WHEN SOLD! Eduard plastic, decals printed by Eduard kits, 2 marking options. NO PE, NO mask, NO resin included, full color instructions
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

Eduard kits EDK8453
Royal_Aircraft_Factory SE.5a Hispano Suiza SPECIAL LOW PRICE! LIMITED! NO MORE WHEN SOLD! 1/48) Weekend Edition kit of British WWI fighter aircraft SE.5a in 1/48 scale. The kit is focused on aircraft powered by Hispano Suiza engine. - plastic parts: Eduard - No. of decal options: 2 - decals: Eduard - PE parts: no, - painting mask: no - resin
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 EDK8067
Bell P-39N Airacobra 1/48 The ProfiPACK edition kit of US WWII fighter aircraft P-39N Airacobra in 1/48 scale. Kit offers P-39 from service with the American, Italian and Soviet air forces. Plastic parts: Eduard; marking options: 6; decals: Eduard; PE parts: yes, pre-painted; painting mask: ano; resin parts: no COL A P-39N-1, 42-9385, Lt. Kirby F. Smith, 346th FS, 350th FG, Reghaia, Algeria, September 1943 COL B P-39N-5, 4...
Aircraft kits (injection)
Catalogue
£22.80
£20.52
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 EDK8079
1:48
Re-released! Bell X-1 Mach Buster The ProfiPACK edition kit of famous rocket engine-powered aircraft Bell X-1 in 1/48 scale. Plastic parts: Eduard; marking options: 4; decals: Eduard; PE parts: yes, pre-painted; painting mask: yes; resin parts: yes, wheels
Aircraft kits (injection)
Catalogue
£22.80
£20.52
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 EDK82117
Re-released! Messerschmitt Bf-109G-4 1/48 ProfiPACK edition of German fighter aircraft Bf-109G-4 in 1/48 scale. Plastic parts: Eduard; No. of decal options: 5 ;decals: Eduard; PE parts: yes, color; painting mask: yes; resin parts: no
Aircraft kits (injection)
Catalogue
£28.70
£25.83
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 EDK82204
General-Motors FM-1 Wildcat Fleet Air Arm x 2 and US Navy x 4. New tool kit! First edition. The ProfiPACK kit of US WWII aircraft carrier-based fighter FM-1 Wildcat in 1/48 scale.Kit presents FM-1 Wildcats from US Navy combat over the Pacific and the Atlantic, and also from the British FAA. Plastic parts: Eduard; marking options:6; decals: Eduard;PE parts; painting masks: yes; resin parts: no COL A VC-1, USS Block Island (C...
Aircraft kits (injection)
Catalogue
£28.70
£25.83
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 EDK84196
Messerschmitt Bf-109E-4 1/48 The Weekend edition kit of German WWII fighter aircraft Bf-109E-4 in 1/48 scale. Plastic parts: Eduard; marking options: 4; decals: Eduard; PE parts: no; painting mask: no; resin parts: no COL A Oblt. Gerhard SchĦpfel, III./JG 26, Caffiers, France, August 1940 COL B WNr. 1433, Hptm. Hans von Hahn, CO of I./JG 3, Grandvillers, France, September 1940 COL C WNr. 5375, Hptm. Wilhelm Meyerweissfl...
Aircraft kits (injection)
Catalogue
£19.60
£17.64
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 EDK11177
Messerschmitt Bf-109K-4 KURFURST The Limited edition kit of the German WWII fighter plane Messerschmitt Bf-109K-4 in 1/48 scale. The TWIN DECAL sheet included. Allows to build models in any two marking otions with the use of OVERTREES plastic parts and accessories. - plastic parts:Eduard - marking A -Fw. Hans Strebel, 11./JG 3, Franzfelde airfield near Pasewalk, Germany, March 1945 B - 9./JG 4, Flensburg airfield, Germany, M...
Aircraft kits (injection)
Catalogue
£29.20
-
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
Eduard kits EDK82138
1:48
Focke-Wulf Fw-190A-7 First edition of this kit. The ProfiPACK edition kit of German WWII fighter aircraft Fw-190A-7 in 1/48 scale. Kit presents Focke-Wulfs from the JG 1, JG 11, JG 54, JG 300, Fƒ¼hrerjƒ¤gerstaffel and Sturmstaffel 1. Plastic parts: Eduard; marking options: 6; decals: Eduard; PE parts: yes, pre-painted; Painting mask: yes COL A WNr. 431007, Maj. Heinz Bƒ¤r, CO of II./JG 1, Stƒ¶rmede, Germany, April 1944 CO...
Aircraft kits (injection)
Catalogue
£28.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

Eduard kits EDK82163
Re-released! Messerschmitt Bf-109G-6/AS re-release ProfiPACK edition kit of German WWII fighter plane Messerschmitt Bf-109G-6/AS in 1/48 scale. Plastic parts: Eduard; marking options: 5; decals: Eduard; PE parts: yes, pre-painted; painting mask: yes COL 1 WNr. 110087, Hptm. Horst Carganico, CO of I./JG 5, Herzogenaurach, Germany, May 1944 COL 2 WNr. 412807, Uffz. Heinz Zimmermann, 6./JG 27, Fels am Wagram, Austria, July ...
Aircraft kits (injection)
Catalogue
£28.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 EDK84194
1:48
Grumman F6F-3 Hellcat 1/48 The Weekend edition kit of US naval fighter aircraft F6F-3 in 1/48 scale. The kit offers machines used by units from land bases and aircraft carriers of the US Navy and the British Royal Navy. Plastic parts: Eduard; marking options: 4; decals: Eduard; PE parts: no; painting mask: no; resin parts: no COL A VF-34, Green Island (Nissan Island), Papua New Guinea, March"April 1944 COL B VF-27, USS ...
Aircraft kits (injection)
Catalogue
£19.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 EDK84195
Hawker Tempest Mk.V Series 1 1/48 The Weekend edition kit of British WWII fighter aircraft Hawker Tempest Mk.V in 1/48 scale. The kit offers the aircraft manufactured within Series 1 and feautures all three variants of the legendary W/Cdr R.P. Beamont's JN 751. Plastic parts: Eduard; marking options: 6; - decals: Eduard; PE parts: no; painting mask: no; resin parts: no; 3D decals: yes, reinforcing fish plates COL 1 JN751, ...
Aircraft kits (injection)
Catalogue
£23.20
-
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 EDK82185
Zlin Z-526 Trenƒ©r Master The ProfiPACK edition kit of Czechoslovak single-engine two-seat training and aerobatic aircraft ZLƒn Zlin Z-526 Trenƒ©r Master, including Zlin Z-526M and Zlin Z-526F versions in 1/48 scale. Kit presents markings selection including Czech and foreign users. Plastic parts: Eduard; marking options: 6; decals: Eduard; PE parts: yes, pre-painted; painting mask: yes. 1 / 6 Z-526 Trenƒ©r Master 1/48 - Z...
Aircraft kits (injection)
Catalogue
£25.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
Eduard kits EDK84181
Re-released! Grumman F6F-5 Hellcat 1/48 Weekend edition kit of US naval fighter aircraft F6F-5 in 1/48 scale. - plastic parts: Eduard - marking options: 4 - decals: Eduard - PE parts: no - painting mask: no - resin parts: no Decals... F6F-5 1/48 - F6F-5, LV Gĩrard de Castelbajac, Flottile 11F, Haiphong Cat Bi, Indochina, March 1954 F6F-5 1/48 - F6F-5K, Detroit Air Races, 1951 F6F-5 1/48 - F6F-5, Lt. Daniel A. Carmichael, ...
Aircraft kits (injection)
Catalogue
£19.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 EDK84193
Grumman F4F-3 Wildcat he Weekend edition kit of US carrier-based fighter Grumman F4F-3 Wildcat Wildcat in 1/48 scale. Plastic parts: Eduard; marking options: 4; decals: Eduard; PE parts: no; painting mask: no; resin parts: no. 1 / 5 F4F-3 WILDCAT 1/48 - BuNo. 1883, VF-72, USS Wasp (CV-7), December 1940
Aircraft kits (injection)
Catalogue
£19.99
-
In Stock
20+

   1   |   2   |   3   |   4   |   5      »      [5]

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