AMSTERDAM

1 - 17 of 17

711 AMSTERDAM INC

LOS ANGELES

Active

1st January 2018


Active

9th August 2011


Inactive

1st January 2008 - 22nd September 2016


AMSTERDAM MODERN

LOS ANGELES

Active

4th January 2013


Inactive

1st July 1956 - 31st December 1997


Inactive

1st September 1975 - 21st December 2001


EYEWORKS BV

1059 CP AMSTERDAM, NETHERLANDS

Inactive

1st January 2011 - 1st January 2012


Inactive

17th January 2017 - 17th January 2017


HOLLAND USA INC

AMSTERDAM

Active

17th November 2009


Inactive

18th February 2005 - 1st November 2005


Inactive

13th September 1985 - 5th August 2011


LISA AMSTERDAM

LOS ANGELES

Active

19th May 2000


Active

21st November 2016


Inactive

30th January 2001 - 11th June 2003


Inactive

20th October 1999 - 26th August 2000


Inactive

1st January 2011 - 31st December 2017


Active

1st January 1999


(default) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`Location_Account`, `Record`.`BUSINESS_NAME`, `Record`.`DBA_NAME`, `Record`.`STREET_ADDRESS`, `Record`.`CITY`, `Record`.`ZIP_CODE`, `Record`.`LOCATION_DESCRIPTION`, `Record`.`MAILING_ADDRESS`, `Record`.`MAILING_CITY`, `Record`.`MAILING_ZIP_CODE`, `Record`.`NAICS`, `Record`.`PRIMARY_NAICS_DESCRIPTION`, `Record`.`COUNCIL_DISTRICT`, `Record`.`LOCATION_START_DATE`, `Record`.`LOCATION_END_DATE`, `Record`.`LOCATION` FROM `la_business`.`records` AS `Record` WHERE MATCH (`Record`.`BUSINESS_NAME`, `Record`.`CITY`, `Record`.`ZIP_CODE`) AGAINST ( '(+AMSTERDAM)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 5017171