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=8069 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 501 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

Italeri IT1409
1:72
Lockheed-Martin F-35A Lightning II. The JSF Joint Strike Fighter program was set up to develop a new fifth-generation all-weather multirole combat aircraft able to replace the existing United States and NATO strike-fighters. The aerospace industry team led by Lockheed-Martin generated the single-seat, single-engine, F-35 Lightning II. It adopts stealth technology and it is characterized by the trapezoidal wings and by the use ...
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

Italeri IT2514
1:32
Lockheed F-104G Starfighter RF Upgraded Edition. ITALIAN AIR FORCE ORPHEUS RECON POD - BULGED COVER FOR RECON PHOTO SYSTEM - 2 ALE 40 CHAFFS DISPENSERS - FINELY ENGRAVED RECESSED PANEL LINES AND RIVETS - FULLY DETAILED ENGINE , COCKPIT , AND AVIONICS BAY - FULLY DETAILED GUN BAY WITH COMPLETE M-61 VULCAN ASSEMBLY - OPEN OR CLOSED AIR BRAKES - PHOTOETCHED FRET - 325 PARTS - 2 HUGE DECALS SHEETS FOR 8 VERSIONS - INSTRUCTIONS SHE...
Aircraft kits (injection)
Catalogue
£105.00
-
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

Italeri IT3658
1:24
Lancia HF Integrale The Lancia Delta HF four wheels-drive is considered an Icon of the Rally Competitions History. The Delta HF was produced in the second half of the 80s and participated in the World Rally Championship from 1987 to 1988 winning two world titles and achieving important results in a lot of competition as the Rallye de Monte-Carlo and the Rallye San Remo. The Lancia Delta Integrale was the evolution of the Delta...
Car kits (injection)
Catalogue
£36.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

Italeri IT3934
1:24
Iveco E5 Hi-Way "Abarth" Stralis Hi-Way distinguishes itself for a number of important technological and aesthetic differences when compared to the previous versions. The cabin has an updated design and is equipped with integrated electronic systems that optimise comfort on board and provide additional safety. The evolution of Stralis is also distinguished by a "powertrain" that minimises fuel consumption and reduces maintenan...
Truck and trailer kits (injection)
Catalogue
£69.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

Italeri IT6555
1:35
M6 Gun Motor carriage WC-55. The Gun Motor Carriage M6 was developed on the famous 4x4 Dodge WC-52 frame adopting, on the rear deck, a 37 mm. light anti-tank gun. Thanks to its Dodge T-214 6 cylinders engine the M6 was able to reach, on road, the speed of 90 Km/h. The United States Army used GMC M6 from the late 1942 up to the end of World War II on all the operating theaters as the Mediterranean, the European front and the Pa...
Military vehicle kits (injection)
Catalogue
£19.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

Italeri IT3930
1:24
SCANIA R730 STREAMLINE "CHIMERA" The Scania Series R heavy-tractor is available with V8 engine and has been developed according to the current world market requirements. The V8 SCANIA engines are designed to carry out the most demanding tasks and are appreciated for their sturdiness, reactivity, and efficiency. The Scania R Series Streamline version, produced in 2013, is designed to meet the most demanding requirementsn in ter...
Truck and trailer kits (injection)
Catalogue
£69.99
-
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

Italeri IT2785
Saab JA-37/AJ-37 'Viggen' ORIGINAL MOULDS FROM ESCI - COLOR INSTRUCTION SHEET - SUPER DECALS SHEET FOR 4 VERSIONS The Saab 'Viggen' fighter has been, for years, the backbone of the Swedish Air Force. The first AJ 37 'Viggen' has been developed to be a multi-role combat aircraft able to perform air defense, anti-ships and ground attack missions. Later on, in order to increase the effectiveness in the Swedish air defense sys...
Aircraft kits (injection)
Catalogue
£33.99
-
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

Italeri IT3932
1:24
Scania R730 Streamliner Highline Cab. The Scania Series R heavy-tractor is available with V8 engine and has been developed according to the recent World market requirements. The V8 SCANIA engines are designed to carry out the most demanding tasks and are appreciated for their sturdiness, reactivity, and efficiency The continuous evolution of the cabin allowed to reach the highest levels of driving comfort and habitability ev...
Truck and trailer kits (injection)
Catalogue
£57.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

Italeri IT6559
1:35
Leopard 2A4 SUPER DECALS SHEET FOR 5 VERSIONS - COLOR INSTRUCTIONS SHEET - NEW GLUABLE RUBBER TRACKS Entered into service between the late '70s and early' 80s the Leopard 2 is considered one of the best armored vehicles in the world. It has been developed to offer the German "Bundeswehr" a powerful and modern Main Battle Tank able to replace the Leopards 1. The main armament is the 120mm. Rheinmetall L/55 smoothbore gun. De...
Military vehicle kits (injection)
Catalogue
£32.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

Italeri IT6554
1:35
M978 Oshkosh Fuel Servicing Truck
Military vehicle kits (injection)
Catalogue
£46.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

Italeri IT3916
1:24
MAN TGX XXL D38 UPGRADED MOULDS. Number plate decals for 14 different countries! The MAN TGX XXL is recognized by the commercial and industrial vehicles market as a reference point for its style and and its personality. The development of the truck has been done taking in consideration the effectiveness and the performance in long range duties. The aerodynamic design of the truck is able to minimize the fuel consumption. Fu...
Truck and trailer kits (injection)
Catalogue
£59.99
-
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

Italeri IT2779
Boeing Chinook CH-47F HC.2 The Boeing CH-47 Chinook is one of the most famous heavy-lift helicopters in Military Aviation History. Characteristic for its two engine tandem rotor configuration, one over the cabin and one in the tail section. It was specifically developed to meet the U.S. Army's transportation needs and to replace the obsolete H-21. The CH-47 Chinook has been produced in several versions and it has been adopted ...
Aircraft kits (injection)
Catalogue
£54.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

Italeri IT6549
1:35
Steyr RSO/01 with German Soldiers
Military vehicle kits (injection)
Catalogue
£41.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

Italeri IT6115
Pax Romana Diorama Set + Wargame rules Roman Villa (MDF laser cut) Gauls Warriors (40 figures) Celtic Cavalry (17 figures) Roman Infantry (35 figures) Roman Cavalry (17 figures) Wargame rules
Diorama bases (injection)
Catalogue
£69.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

Italeri IT1405
1:72
Grumman KA-6D Intruder. COLORS INSTRUCTIONS SHEET - SUPER DECALS SHEET FOR 4 VERSIONS The A-6 Intruder entered service in the mid-60s as ground attack carrier based aircraft to replace the outdated planes as the propeller-driven A-1 Skyraider and the A-3 Skywarrior. The Grumman Corporation developed and designed the A-6A, based on U.S. Navy specifications, a twin jet-engine all-weather medium attack aircraft able to operate...
Aircraft kits (injection)
Catalogue
£24.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

Italeri IT7072
1:72
German Sd.Kfz.265 Panzerbefehlswagen. The Sd.Kfz.265 Kleine Panzerbefehlswagen armored command vehicle was born to meet the need of the Wehrmacth Panzer Division Commanders to follow, as close as possible, the tanks and better coordinate them on the battlefield. This armored command vehicle was designed on the Panzer I Ausf. B light tank chassis. To increase the space for the unit commander and his staff, the traditional rotat...
Military vehicle kits (injection)
Catalogue
£12.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

Italeri IT3897
Scania R Black Amber
Truck and trailer kits (injection)
Catalogue
£69.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

Italeri IT4703
1:12
FIAT 500F 1968 100% new moulds - Highly detailed model - Opened or closed top - Opening car doors - Front and rear opening bonnets - Steering wheels - Working suspensions - Rubber tyres - Photoetched and chromed parts The model can be realized in the Anglo-Saxon version with right drive. The "Nuova 500" was produced by Fiat from 1957 to 1975. It is a real icon on four wheels and one of the symbols of "made in Italy". It...
Car kits (injection)
Catalogue
£134.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

Italeri IT3652
1:24
Renault 5 Alpine Rally For the 1977 Rally season the French company Renault developed a racing version of the popular small R5. In spite of the fact that this car was designed for very different scopes, after adequate preparation, the French technicians managed to obtain notable power from the engine: 150CV, and a noteworthy drive ration, which thanks to the contained weight of only 800 Kg. made the R5 a very manoeuvrable and ...
Car kits (injection)
Catalogue
£36.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

Italeri IT3931
1:24
Volvo FH16 XXL 'Viking' ADDITIONAL CHROMED PARTS - NEW TYRES - CHROMED WHEEL RIMS The FH series can be considered a milestone in Volvo industrial vehicle production. Introduced to the market since 2001, it was released in numerous versions and variants. In details, the Volvo FH16 has been the reference version of the Volvo trucks line up. Powered by a 16 liter engine, capable of delivering 610 HP, it was characterized by a ...
Truck and trailer kits (injection)
Catalogue
£69.99
-
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

Italeri IT0405
1:35
Brick Walls
Diorama accessories (injection)
Catalogue
£8.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

Italeri IT6181
El Alamein - Battle At The Railway Staion. Laser Cut MDF Station with etched details and Railway Tracks, DAK/Afrika Korps figures, Pz.Kpfw.IV F-1/F-2, Cannone da 149/40 with Crew, British 8th Army, M4A2 Sherman & Morris Quad Tractor/25lbr Gun. El Alamein is one of the most famous battles in the Second World War fought between the British forces, led by Lieutenant-General Bernard Law Montgomery, and the Axis forces, led by Fi...
Diorama accessories (injection)
Catalogue
£74.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

Italeri IT6547
1:35
M32B1 ARV/Armoured Recovery Vehicle [Sherman M4] The Armored Recovery Vehicles (ARV), were introduced during the Second World War. They were built on the hulls of existing armored vehicles, removing the main armament and the turret and installing of specific equipment for the recovery or repair of armoured fighting vehicles damaged in battle. The American M-32 ARV was based on the chassis of the well-known Sherman A-4 medium t...
Military vehicle kits (injection)
Catalogue
£25.99
-
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

Italeri IT1392
1:72
Grumman A-6E Intruder USN/USMC SUPER DECALS SHEET FOR 2 VERSIONS - COLOR INSTRUCTION SHEET The A-6 Intruder entered service in the mid-60s as ground attack carrier based aircraft to replace the outdated planes as the propeller-driven A-1 Skyraider and the A-3 Skywarrior. The Grumman Corporation developed and designed the A-6A, based on U.S. Navy specifications, a twin jet-engine all-weather medium attack aircraft able to op...
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

Italeri IT2748
1:48
Boeing/Hughes AH-64D Apache Longbow The AH-64 Apache can be considered the most famous attack helicopter in history. It was designed to operate on the front line and to perform anti-tank, anti-helicopter, assault and close support missions in "all weather" conditions and in any operating environments. The AH-64D Longbow is the upgraded version with and increased offensive capability and the adoption of advanced target acquisit...
Aircraft kits (injection)
Catalogue
£34.99
-
In Stock
3

[1]   «      9   |   10   |   11   |   12   |   13      »      [21]
-10

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