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=4)
|
REGIONAL MEMBER DIRECTORY |
|
|
| | Industry: | Legal Services | | Contact: | Alejandro Cofino | | Email: | send an Email | | Address: | Diagonal 6, 10-01 Zona 10 | | | Las Margaritas, Torre II, Oficina 302A | | | 01010 Guatemala | | | Guatemala | | Phone: | +502 2327 4646 | | Fax: | +502 2327 4613 |
| | |
| | Industry: | Legal Services | | Contact: | David Gutierrez | | Email: | send an Email | | Address: | Via Lindora Business Center | | | Radial Santa Ana � Belen, Km 3 | | | 10903 San Jose | | | Costa Rica | | Phone: | 506-2205-3939 | | Fax: | 506-2205-3940 |
|
|
| | Industry: | Legal Services | | Contact: | Diego Martin | | Email: | send an Email | | Address: | Edificio Avante Local 3-13, Urbanizacion Madre Selva III | | | Calle Llama del Bosque pte. Antiguo Cuscatlan | | | Antiguo Cuscatlan | | | El Salvador | | Phone: | +503 2209 1600 | | Fax: | +503 2298 3939 |
| | |
| | Industry: | Legal Services | | Contact: | Jose Evenor Taboada | | Email: | send an Email | | Address: | Antiguo Hospital Militar, 1c al norte, Avenida Bolivar. | | | 12066 Managua | | | Nicaragua | | Phone: | +505 2254 5454 | | Fax: | +505 2254 5295 |
|
|
| | Industry: | Legal Services | | Contact: | Gustavo Leon-Gomez | | Email: | send an Email | | Address: | Primera Calle # 304 Torre Consortium I | | | Colonia La Estancia Final del Bulevar Morazan | | | Tegucigalpa | | | Honduras | | Phone: | +504 2221 1002 | | Fax: | +504 2221 0535 |
| | |
| | Industry: | Legal Services | | Contact: | Luis G. Manzanares Sanchez | | Email: | send an Email | | Address: | MMG Tower | | | 23rd Floor, Avenida Paseo del Mar, Costa del Este | | | Panama | | | Panama | | Phone: | +507 265 7777 |
|