Listings for: H

Company Search: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

SELECT DISTINCT dcc.id_company, dc.Organisation, dc.Address1, dc.Address2, dc.Address3, dc.Town, dc.County, dc.PostCode, dc.Tel, dc.countryID, dctry.Country, `enhanced`, `expiry_date`, IF(`expiry_date`>NOW(),'Yes','')AS curExp, du.file_name FROM wp_d_company_category dcc INNER JOIN wp_d_category dct ON dcc.id_category=dct.id_category INNER JOIN wp_d_company dc ON dcc.id_company = dc.id_company LEFT JOIN wp_d_uploads du ON dc.id_company=du.id_company INNER JOIN wp_d_country dctry ON dc.countryID=dctry.ID WHERE `approved` = 'Yes' AND Organisation LIKE 'h%' AND (du.type = 'Logo' || du.type IS NULL) ORDER BY curExp DESC,`Organisation` ASC1 2 3 15

GermanyH. Niehüser Armaturenbau und Vertriebs GmbH

Address: Wankelstraße 3 , 33449 Langenberg

Phone: +49 5248 823 530

Products and Services

SwitzerlandHabasit AG

Address: Roemerstrasse 1 , CH-4153 Reinach-Basel

Phone: +41 6 1715 1515

Products and Services

GermanyHACA-Leitern, L. Hasenbach GmbH u. Co. KG

Address: Dieselstrasse 12 , D-65520 Bad Camberg

Phone: +49 6 4342 5500

Products and Services

United StatesHagerstown Regional Airport

Address: 18434 Showalter Road , Hagerstown , MD 21742

Phone: +1 24 0313 2777

Products and Services

IsraelHaifa Airport

Address: PO Box 10388 , 26110 Haifa Bay

Phone: +97 2 4847 6100

Products and Services

ChinaHaikou Meilan International Airport

Address: , Haikou 571126 , Hainan

Phone: +86 898 6575 1306

Products and Services

JapanHakodate Airport

Address: , Hakodate

Phone: +81 1 3857 8881

Products and Services

United KingdomHalcrow Group Limited

Address: Vineyard House , 44 Brook Green , London , W6 7BY

Phone: +44 20 7602 7282

Products and Services

1 2 3 15