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=339360 AND ps.id = 957 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 74 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
Kits-World KWB144-513
Southend Airport Size 675mm x 675mm Formation and early years Southend Airport can trace its ancestry back to the Great War when it was established by the Royal Flying Corps (RFC) in 1915. It was briefly passed over to the Royal Navy Air Service (RNAS) in the same year with limited flying duties being carried out. In 1916 the airfield passed back to RFC control when it became RFC Rochford and used as a training centre f...
Vinyl Bases
Catalogue
£19.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
Kits-World KWB144-514
Manchester Airport/Manchester International Airport/Ringway Airport Size 675mm x 675mm Beginning and early days What is now Manchester Airport traces its ancestry back to the 1930s. Construction of Ringway Airport as it was formerly known, in 1935, and the site partially opened in June 1937 before becoming fully operational in June 1938, officially opening with an air pageant to mark the occasion. The first scheduled fl...
Vinyl Bases
Catalogue
£19.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
Kits-World KWB144-515
Norwich Airport Size 675mm x 675mm Beginnings and the first Norwich Airport Initially a British Army cavalry training ground, RFC Mousehold Heath was established on the site and was home to a number of Royal Flying Corps units; Nos 18, 37, 85 and 117 Squadrons. In April 1918, RFC Mousehold Heath became RAF Mousehold Heath, and following the war, Boulton & Paul Ltd took over the site as a test facility, although it shou...
Vinyl Bases
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

No Image
Kits-World KWB144-516
London Heathrow Airport Size 675mm x 675mm Early Days and the inter-war period Today, one of the worlds' major airports, and the largest of the six airports surrounding London. Initially the site was located near the village of Heathrow and was known by several titles; the Great West Aerodrome, Heathrow Aerodrome (due to the nearby hamlet of Heathrow), or Harmondsworth Aerodrome (due to it being located in the civil pa...
Vinyl Bases
Catalogue
£19.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
Kits-World KWB144-517
London Gatwick Airport Size 675mm x 675mm Founding and early years Today, Gatwick airport is one of the United Kingdom's major airport hubs, second only to Heathrow. Originally, partially the area now occupied by the airport was a racecourse, and was founded in 1891. From 1907, a golf course was added but this closed shortly after the end of the Great War. During the late 1920's the land adjacent to the course was ...
Vinyl Bases
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

No Image
Kits-World KWB144-481
Soviet Union/Warsaw Pact/People's Republic of China- People's Liberation Army Air Force: Hexagonal slab dispersal/parking area, 1.8 metre radius type, 1950's to early 1970's. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) This model represents the 1.8 metre slab type that replaced the earlier 1.2 metre hexagonal slab in use from the 1930's to the late 1940's, and the 1.5 metre hexagonal slabs in use from the late 1940's to the...
Vinyl Bases
Catalogue
£7.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

No Image
Kits-World KWB144-483
1:144
Soviet Union/Russia/Warsaw Pact/People's Republic of China: PAG-14 pre-stressed concrete slab- early 1970's to present. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) This model represents the 6 metre by 2 metre slab type that replaced the earlier 1.8 metre hexagonal slab in use from the 1950's to the early 1970's. By the 1980's, most Soviet/Russian and WarPac bases had been relaid with this type which provided much better loa...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-491
23rd Air Base (23 Baza Lotnicza), Polish Air Force, Miƒ...aâé-zsk Mazowiecki, Poland, 2001 onwards. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The base was first formed in 2001, with 1 Eskadra Lotnictwa Taktycznego (1.ELT) being the main unit stationed there flying the Mikoyan MiG-29 (9.12A) and MiG-29UB (9.51A). The units primary role is that of air defence covering both Polish and wider NATO airspace, including that of Eston...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-493
Plain Grass (Worn). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) A base of worn grass that can serve a number of functions. Applications could include military and civilian airfields and aerodromes from the dawn of flight to the present day and even bases for vehicle displays. The base can also be used for 1/72nd displays, is large enough to be cut into smaller sections to create a number of separate bases. Suggested subj...
Vinyl Bases
Catalogue
£7.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

No Image
Kits-World KWB144-495
Korat Royal Thai Air Force Base, Thailand, 1972. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Korat can trace its ancestry back to the days of the Japanese Occupation of Thailand when a small airfield was built for use by the Japanese Imperial Army. After the end of the war, the airfield was passed to the Thai government who continued its use as a base for the Royal Thai Air Force. During the early 1960's, the United Sta...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-496
1st Strategic Air Depot, USAAF, (RAF Honington) Suffolk, England, 1942-46. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Honington was established in 1937 as a Royal Air Force base operating under RAF Bomber Command. It was passed over to the USAAF in June 1942 as Station 375. Stationed at the base were the 383rd, 384th and 385th Fighter Squadrons of the 364th Fighter Group, which arrived in early 1944 operating P-51 Mustangs...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-497
Aalborg Air Base (Flyvestation Aalborg), Royal Danish Air Force, 1983-2001. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Aalborg Airport was opened in 1938. In April 1940, the base was captured by Fallschirmjƒ¤ger during Operation Weserƒ¼bung, the German invasion of Denmark and Norway. Once captured, the Germans used the airport as a main location for troops and equipment for the invasion of Norway and also as a refuelling b...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-498
Eighth Air Force, England 1942-45. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The Eighth Air Force started offensive operations against German targets in July 1942 when crews of the 15th Bombardment Squadron (Light) flying RAF Douglas A-20 Bostons attacked targets in the Netherlands. The 'Mighty Eighth' commenced operations with the Boeing B-17E Flying Fortress in August of the same year, flying from RAF Grafton Underwood ...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-506
Great War Battlefield. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The war witnessed an unprecedented horror never before seen and bought war on an industrial scale to mankind. The trench system came into effect as early as September 1914, when the Allied and Central Powers Commands began to realise that war would not be the short-term battle they had initially envisioned. As the war drew on, the trench system expanded, eve...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-508
PAG-14 Pre-Stressed Concrete Slab- Blurred 225mm(W) x 225mm(H) 9inches(W) x 9inches(H)
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-482
'Marston Mat' Pierced Steel Plank (PSP). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) 'Marston Mat', was a very common covering used for makeshift runways, parking areas and other military uses where rough ground was prevalent. Each panel measured 1 ft 7.5 in by 11 ft 9.75 in, and interlocked with its neighbour by a series of flat 'T' hooks and slots along each of the longest sides, which allowed a degree of flexibility of m...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-484
RAF Coningsby, Lincolnshire, United Kingdom, 2005-2021. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RAF Coningsby was built in the late 1930's and after officially opening in November 1940, became operational in February 1941. No. 106 Squadron was the first unit to begin offensive operations from the base flying Handley Page Hampden's. A second unit, No. 97 Squadron, arrived in April equipped with Avro Manchester's, and in ...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-485
Wood Planked Revetment, Great War and Second World War 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Wooden planked revetments were used by all sides during the Great War and Second World War, but were most notably common in Luftwaffe use. Quickly laid down, they did not follow a standardised pattern, size, shape or design. Sometimes, they consisted of simple planked hard standings as in this set, or more elaborate affairs wi...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-486
Fliegerhorst Grove, Denmark- 1.(F)/33 (possibly transited through the base), Danish units post-war. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Located near the Danish town of Karup, the construction of Grove was commenced shortly after the German occupation of Denmark in 1940, with the base becoming operational later that year. By 1945, the base had grown with the addition of command bunkers, aircraft revetments, anti-airc...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-487
RAF Lakenheath- 1990 to 2021. (Main) USAF Units- 48th Fighter Wing (492nd, 493rd, 494th Fighter Squadrons, 495th Fighter Squadron- (due to reactivate in 2021)). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Located near the town of Lakenheath in Suffolk, United Kingdom, the base can date its roots back to the Great War when it was named Lakenheath Warren and used as a bombing range. It fell into disrepair after 1918, but was ...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-488
Tyndall Air Force Base, Florida- 2021. (Main) USAF Units- 325th Fighter Wing/325th Operations Group (2nd Flying Training Squadron, 43rd and 95th Fighter Squadrons). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Tyndall Field as it was previously known was activated as a USAAC gunnery range in 1941. It was deactivated at the end of World War 2 and became a training airfield under Air Training Command. In 1948, the base was ren...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-489
Royal Naval Air Station Yeovilton (H.M.S. Heron), 1990's onwards. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RNAS Yeovilton was built in 1939, with 750 NAS commencing operations from the base in the same year, and followed by 751 and 752 NAS shortly afterwards. 794 NAS was formed in 1940 and 827 NAS started operations from the base in 1943. This unit was the first to receive the Fairy Barracuda torpedo bomber. Yeovilton un...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-490
Four single parking areas. Suitable for Great War onwards. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The four bases in this set are suitable for both 1/48th and 1/72nd aircraft, and are ideal for types operating from rough terrain from the Great War onwards. Usable for any type of aircraft of relevant type, size and scale.
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-492
USS Nimitz (CVN-68), No. 2 Elevator, 2020 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Named after Chester W. Nimitz, the ship was launched in May 1972 and commissioned in May 1975, originally as CVAN-68 and thereafter CVN-68. Her first deployment was to the Mediterranean in July 1976 and she returned to the United States in February the following year. This was followed by further deployments to the Mediterranean, firstly i...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-494
Plain Grass (Solid). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) A base of solid grass that can serve a number of functions. Applications could include military and civilian airfields and aerodromes from the dawn of flight to the present day and even bases for vehicle displays. The base can also be used for 1/72nd displays, is large enough to be cut into smaller sections to create a number of separate bases and as it's seam...
Vinyl Bases
Catalogue
£7.99
-
In Stock
3

   1   |   2   |   3      »      [3]

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