You need to install Flash player 8 to view map.
SELECT dbo.fx_Jurisdiction1(country,stateorprovince) as 'jurisdiction',vmcontactid as contactid,companyname,address1,address2,city,stateorprovince,country, mainphone,mainfax,mainemail, companyid,companytype,ziporpostalzone, vmfirst as firstname,vmlast as lastname,vmmiddle as middlename,vmemail as email,vmphone as directdial1, CASE CompanyId WHEN 10014 THEN 'D.C.' ELSE stateorprovince END AS State FROM wsgCompanies left join VMainContacts on vmcompanyid=companyid where typelisting in ('M') and country<>'demoland' and directory=1 and wsgcompanies.companyid not in (7358,76,9771,8296) and companytype not in ('Insurances') and (wsgcompanies.firmid is null or wsgcompanies.firmid<>7358) and len(address1)>0 and (region=6)
|
REGIONAL MEMBER DIRECTORY |
|
|
| | Industry: | Legal Services | | Contact: | Abdullah Kh. Al-Ayoub | | Email: | send an Email | | Address: | Souk Al-Kabir Building, Block 'B' | | | 9th Floor, Fahed Al Salem Street | | | 13018 Safat | | | Kuwait | | Phone: | +965 22464321 | | Fax: | +965 22434711 |
| | |
| | Industry: | Legal Services | | Contact: | Bashir Ahmed | | Email: | send an Email | | Address: | Emirates Towers Offices, Level 35 | | | Sheikh Zayed Road | | | P.O. Box 9371 Dubai | | | United Arab Emirates | | Phone: | +971 4 330 3900 | | Fax: | +971 4 330 3800 |
|
|
| | Industry: | Legal Services | | Contact: | Shahira Khaled | | Email: | send an Email | | Address: | Al Kamel Law Building | | | 17 Nabil El Wakad Street, Dokki | | | Giza | | | Egypt | | Phone: | +202 37615271 | | Fax: | +202 37615272 |
| | |
| | Industry: | Legal Services | | Contact: | Charbel Abi-Antoun | | Email: | send an Email | | Address: | 345 Bikfaya Mainway | | | 1201 Antelias | | | Lebanon | | Phone: | 9614444139 | | Fax: | 9614444239 |
|
|
| | Industry: | Legal Services | | Contact: | Rand Hannun | | Email: | send an Email | | Address: | Riyadh Center, 3rd Circle | | | 35116 Amman | | | Jordan | | Phone: | +962 6 4654411 | | Fax: | +962 6 4657555 |
| | |