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 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 164 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
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

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 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

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 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 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

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+

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

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