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=85838
		 AND P.product_category_id = 108 
		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
Limited Availability | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Limited Availability



Found 87 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 Big-Ed EBIG49274
Sukhoi Su-27UB (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets..... ED481037 Sukhoi Su-27UB exterior ED491130 Sukhoi Su-27UB interior DEFE1131 Sukhoi Su-27UB seatbelts STEEL EDEX733 Sukhoi Su-27UB canopy and wheels paint mask
Aircraft detailing sets (etched)
Limited Availability
£38.30
-
In Stock
2

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 Big-Ed EBIG33138
Bell AH-1G Cobra (designed to be used with ICM and Revell kits) This BiG-Ed set includes all these Eduard sets..... ED32990 AH-1G 1/32 ED33287 AH-1G seatbelts STEEL 1/32 EDJX279 AH-1G canopy frame paint mask 1/32 (Eduard sold out April 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£20.40
-
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

Eduard Big-Ed EBIG3589
1:35
Sd.Kfz.166 Sturmpanzer IV Brummbar (designed to be used with Tamiya kits) This Big-Ed set includes all these Eduard sets.... ED36363 Sd.Kfz.166 Brummbar ED36364 Sd.Kfz.166 Brummbƒ¤r schƒ¼rzen ED36365 Sd.Kfz.166 Brummbƒ¤r zimmerit
Military vehicle detailing sets (etched)
Limited Availability
£55.80
-
In Stock
2

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 Big-Ed EBIG3592
1:35
Pz.Kpfw.VI King Tiger Initial Production (designed to be used with Takom kits) This BiG-Ed set includes all these Eduard sets.... ED36386 King Tiger initial ED36387 King Tiger initial zimmerit ED36388 King Tiger fenders
Military vehicle detailing sets (etched)
Limited Availability
£55.50
-
In Stock
2

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 Big-Ed EBIG49313
Boeing F/A-18E Hornet (designed to be used with Hobby Boss kits) This BiG-Ed set includes all these Eduard sets..... ED491227 F/A-18E 1/48 EDFE1228 F/A-18E seatbelts STEEL EDEX811 F/A-18E (Eduard sold out March 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£23.60
-
In Stock
4

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 Big-Ed EBIG5367
1:350
USS Constellation CV-64 PART II (designed to be used with Trumpeter kits) This BiG-Ed set includes all these Eduard sets..... ED53180 USN ensign flag modern STEEL 1/350 ED53233 Aircraft Carrier figures USN present 3D 1/350 ED53284 USS Constellation CV-64 part 4 - hull & deck 1/350 ED53285 USS Constellation CV-64 part 5 - island 1/350 (Eduard sold out February 2024 part 2)
Ship detailing sets (etched)
Limited Availability
£64.99
-
In Stock
2

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 Big-Ed EBIG33125
Dassault-Mirage 2000D (designed to be used with Kitty Hawk Model kits) (delivered February 18th 2021) This BiG-Ed set includes all these Eduard sets..... ED32976 Dassault-Mirage 2000D ED33269 Dassault-Mirage 2000D/N seatbelts steel EDJX263 Dassault-Mirage 2000D/N (Eduard sold out February 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£36.70
-
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
Eduard Big-Ed EBIG49252
Hawker Hunter F.4 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... ED491082 Hawker Hunter F.4 ED481014 Hawker Hunter F.4/F.5 landing flaps EDFE1084 Hawker Hunter F.4/F.5 seatbelts EDEX696 Hawker Hunter F.4/F.5 paint mask (Eduard sold out February 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£30.60
-
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 Big-Ed EBIG72161
Shorts Sunderland Mk.III (designed to be used with Special Hobby kits) This BiG-Ed set includes all these Eduard sets..... ED72707 Sunderland Mk.III exterior 1/72 ED72708 Sunderland Mk.III bomb bay 1/72 ED72709 Sunderland Mk.III maintenance platforms 1/72 ED73721 Sunderland Mk.III interior 1/72 EDCX582 Sunderland Mk.III 1/72 (Eduard sold out February 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£71.80
-
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

Eduard Big-Ed EBIG3591
1:35
Pz.Kpfw.IV Ausf.H (designed to be used with Academy kits) ED36382 Pz.Kpfw.IV Ausf.H ED36383 Pz.Kpfw.IV Ausf.H Schurzen/Schƒ¼rzen ED36384 Pz.Kpfw.IV Ausf.H zimmerit
Military vehicle detailing sets (etched)
Limited Availability
£66.80
-
In Stock
2

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 Big-Ed EBIG35100
IDF Shot Kal (designed to be used with Amusing Hobby kits) This BiG-Ed set includes all these Eduard sets..... ED36415 Israeli flags 1/35 ED36468 IDF Shot Kal 1/35 ED36469 IDF Shot Kal turret boxes 1/35 (Eduard sold out January 2024 part 1)
Military vehicle detailing sets (etched)
Limited Availability
£42.99
-
In Stock
1

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 Big-Ed EBIG49251
1:48
North-American P-51D-5 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... EDEX689 P-51D-5 ED481013 P-51D-5 exterior ED491074 P-51D-5 interior EDFE1075 P-51D-5 seatbelts STEEL (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£25.50
-
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 Big-Ed EBIG49253
Hawker Hunter F.5 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... ED491083 Hawker Hunter F.5 ED481014 Hawker Hunter F.4/F.5 landing flaps EDFE1084 Hawker Hunter F.4/F.5 seatbelts EDEX696 Hawker Hunter F.4/F.5 paint mask (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£30.60
-
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 Big-Ed EBIG49262
Messerschmiit Bf-110D 1/48 (designed to be used with Dragon kits) [Bf-110D-1/R1 Bf-110D-3] This BiG-Ed set includes all these Eduard sets..... EDEX710 Bf-10D TFace canopy frame paint mask (inside & outside) ED481022 Bf-110D exterior ED491106 Bf-110D interior EDFE1107 Bf-110D seatbelts STEEL (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£32.70
-
In Stock
2

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 Big-Ed EBIG49318
Grumman F-14A Tomcat late (designed be used with Tamiya kits) This BiG-Ed set includes all these Eduard sets..... ED48910 F-14A engines ED481075 F-14A late exterior 1/48 ED49806 F-14A seatbelts STEEL ED491239 F-14A late interior 1/48 EDEX540 F-14A 1/48 (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£49.30
-
In Stock
4

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 Big-Ed EBIG33134
Curtiss P-40M part II (designed to be used with Trumpeter kits) This BiG-Ed set includes all these Eduard sets..... ED32465 P-40M exterior ED32466 P-40M landing flaps ED32467 P-40M gun bays
Aircraft detailing sets (etched)
Limited Availability
£52.40
-
In Stock
1

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 Big-Ed EBIG49333
Lockheed F-104A Starfighter (designed to be used with Kinetic Model kits) This BiG-Ed set includes all these Eduard sets..... ED49103 Remove Before Flight STEEL ED491266 F-104A 1/48 EDFE1270 F-104A/C seatbelts STEEL 1/48 EDEX850 F-104A/C
Aircraft detailing sets (etched)
Limited Availability
£25.50
-
In Stock
2

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 Big-Ed EBIG49334
Ilyushin Il-2 Stormovik mod. 1943 (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... EDE481085 Il-2 mod. 1943 landing flaps ED491271 Il-2 mod. 1943 1/48 EDFE1272 Il-2 mod. 1943 seatbelts STEEL EDEX856 Il-2 mod. 1943
Aircraft detailing sets (etched)
Limited Availability
£49.30
-
In Stock
2

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 Big-Ed EBIG33119
1:32
Douglas A-26B Invader part I (designed to be used with Hobby Boss kits) This BiG-Ed set includes all these Eduard sets..... ED33259 A-26B Invader seatbelts STEEL 1/32 ED32970 A-26B Invader cockpit interior 1/32 ED32972 A-26B rear interior 1/32 (Eduard sold out September 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£46.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
Eduard Big-Ed EBIG49291
Mikoyan MiG-15bis (designed to be used with Bronco Models and Hobby 2000 kits) This BiG-Ed set includes all these Eduard sets..... ED481046 MiG-15bis landing flaps 1/48 ED491178 MiG-15bis 1/48 EDFE1179 MiG-15bis seatbelts STEEL 1/48 EDEX775 MiG-15bis 1/48 (Eduard sold out September 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£32.70
-
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

Eduard Big-Ed EBIG49184
Sukhoi Su-35 Flanker-E (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets.... EDEX562 Su-35 Flanker E ED48934 Su-35 Flanker E exterior ED49858 Su-35 Flanker E interior EDFE859 Su-35 Flanker E seatbelts STEEL (Eduard sold out August 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£32.70
-
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
Eduard Big-Ed EBIG49285
Sukhoi Su-30SM (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets..... ED491150 Su-30SM 1/48 EDFE1151 Su-30SM seatbelts STEEL 1/48 EDEX743 Su-30SM 1/48 (Eduard sold out August 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£29.70
-
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
Eduard Big-Ed EBIG49315
Grumman TBF-1C Avenger (designed to be used with Academy kits) This BiG-Ed set includes all these Eduard sets..... ED481071 TBF-1C exterior ED481072 TBF-1C landing flaps ED491232 TBF-1C interior 1/48 EDEX819 TBF-1C 1/48 EDFE1233 TBF-1C seatbelts STEEL
Aircraft detailing sets (etched)
Limited Availability
£59.99
-
In Stock
2

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 Big-Ed EBIG72160
Grumman F-14A Tomcat (designed to be used with Great Wall Hobby kits) This BiG-Ed set includes all these Eduard sets..... ED73715 F-14A 1/72 EDSS719 F-14 F.O.D. 1/72 ED73044 Remove Before Flight STEEL EDCX577 F-14A 1/72 (Eduard sold out August 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£27.70
-
In Stock
2

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 Big-Ed EBIG49158
Sukhoi Su-33 Sea Flanker D (designed to be used with Kinetic Model kits) This Big-Ed set includes these Eduard sets.... EDEX521 Su-33 ED48891 Su-33 exterior ED49778 Su-33 interior (Eduard sold out July 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£29.70
-
In Stock
2

   1   |   2   |   3   |   4      »      [4]

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