ACCORD

1 - 33 of 33

Active

1st May 2006


A H ACCORD GROUP INC

SAN GABRIEL

Active

7th June 1999


Active

5th November 2015


ACCORD DESIGN LLC

LOS ANGELES

Inactive

1st March 2011 - 1st June 2012


ACCORD ELECTRIC CORP

HUNTINGTON BEACH

Active

14th April 1992


Inactive

10th January 2012 - 31st December 2017


Inactive

1st June 1994 - 24th November 1998


Active

1st January 2005


ACCORD INC

LOS ANGELES

Inactive

1st July 1984 - 31st December 2004


Inactive

10th December 1997 - 31st December 2010


Inactive

1st October 2002 - 18th December 2003


ACCORD PAC MEMBERS LLC

SAN FERNANDO

Active

17th September 2010


ACCORD PARTNERS LLC

LOS ANGELES

Active

15th July 2013


Inactive

15th January 1993 - 24th August 2002


Active

11th June 2003


Active

1st January 2015


Inactive

1st April 2005 - 31st October 2011


Inactive

24th March 2000 - 31st December 2010


Active

23rd May 2008


Inactive

1st February 2003 - 31st January 2005


Inactive

1st June 2003 - 9th March 2006


ACCORD/NEW LLC

LOS ANGELES

Inactive

5th September 2002 - 9th February 2006


ACCORD/SHO MEMBERS LLC

SAN FERNANDO

Inactive

1st March 2004 - 31st December 2010


Inactive

30th December 2002 - 30th September 2004


Inactive

1st September 2004 - 1st January 2007


Inactive

28th August 2013 - 31st December 2014


Inactive

1st May 2009 - 31st December 2014


Active

29th June 2012


JAMES ERNEST ACCORD

WEST HILLS

Inactive

1st May 2000 - 31st December 2010


ONE ACCORD INC

VALENCIA

Active

1st January 2011


Inactive

5th June 2001 - 31st December 2003


Inactive

5th June 2001 - 31st December 2010


Active

14th December 2009


(default) 1 query took 2 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 ( '(+ACCORD)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 5033332