//SELECT DISTINCT vw_RetailPromos.advert_id, vw_RetailPromos.county, vw_RetailPromos.cost, COALESCE (vw_ActiveDiscounts.elb_disc, 0) AS elb_disc, vw_RetailPromos.cost - COALESCE (vw_ActiveDiscounts.elb_disc, 0) AS price, vw_ActiveDiscounts.expires, vw_RetailPromos.duration, vw_RetailPromos.tot_duration, vw_RetailPromos.school_id, tblSchools.name FROM vw_RetailPromos INNER JOIN tblSchools ON vw_RetailPromos.school_id = tblSchools.school_id LEFT OUTER JOIN vw_ActiveDiscounts ON vw_RetailPromos.advert_id = vw_ActiveDiscounts.promo WHERE (vw_RetailPromos.venue = N'North Weald') AND (vw_RetailPromos.school_id <> 1638) ORDER BY price
Flying lessons and pleasure flights at North Weald in Essex
Flying adventures across the UK with YOU in the cockpit!
#43058
20 Minute BESPOKE Flight at North Weald, Essex
Southeast
Climb aboard your VIP private helicopter for up to 4 passengers in total to enjoy a bespoke 20 minute pleasure flight over the area you would like to see from the air (within the time limit and local airspace regulations).
45 minutes, with 20 minutes in the air. £389.99 ..more details
Climb aboard your VIP private helicopter for up to 4 passengers in total to enjoy a bespoke 20 minute pleasure flight over the area you would like to see from the air (within the time limit and local airspace regulations).