ALTADENA

1 - 50 of 909

Active

1st July 2014


Active

23rd February 2016


Inactive

27th January 1994 - 1st November 2004


ABELARDO GARCIA

ALTADENA

Inactive

1st January 2002 - 31st December 2008


Inactive

1st December 1972 - 15th June 2007


Active

29th March 1999


ACSCO INC

ALTADENA

Active

4th October 2010


Inactive

1st April 1978 - 25th March 2006


ACTON INC.

ALTADENA

Active

14th February 2014


Inactive

4th April 2008 - 31st December 2008


ADDI SOMEKH

ALTADENA

Inactive

1st August 2005 - 30th June 2006


Inactive

1st March 1998 - 31st December 2002


ADRIAN MOON

ALTADENA

Inactive

20th August 2000 - 1st November 2004


ADRIAN RIVAS

ALTADENA

Inactive

1st January 2012 - 31st December 2017


Inactive

12th August 2014 - 26th February 2015


Active

21st May 2001


Inactive

1st February 1988 - 24th August 1992


AGOP A KODCHIAN

ALTADENA

Active

11th July 1995


AGUSTIN JAIME

ALTADENA

Inactive

1st January 2001 - 31st December 2008


AHAD K ABDULLAH

ALTADENA

Inactive

19th May 1994 - 1st November 2004


Active

1st May 2005


AKIKO HUNTER

ALTADENA

Inactive

1st January 2014 - 31st December 2017


Active

2nd January 2014


ALA E SALMAN

ALTADENA

Active

1st January 2007


ALAN G COOK

ALTADENA

Inactive

30th July 2002 - 31st December 2011


ALBERT M MORENO

ALTADENA

Active

1st January 2015


Active

6th December 2010


Active

18th November 2006


Active

26th April 2011


Inactive

18th October 2005 - 31st December 2007


ALEXANDRA GILLIS

ALTADENA

Inactive

1st January 1998 - 31st December 2001


ALEXANDRA GILLIS

ALTADENA

Active

1st October 2008


Active

22nd April 2007


Active

9th November 2011


ALEXIS H RIVAS

ALTADENA

Inactive

16th May 1999 - 31st December 2000


Inactive

16th August 1999 - 31st December 1999


ALFRED R PASOS

ALTADENA

Inactive

16th April 1992 - 31st December 2005


ALFRETA L SAILOR

ALTADENA

Inactive

1st May 1990 - 24th August 1996


ALICE KONITZ

ALTADENA

Inactive

24th July 2006 - 1st February 2011


ALICIA W. CLARKE

ALTADENA

Inactive

1st January 2004 - 4th September 2008


ALISON SADLER

ALTADENA

Inactive

1st January 2003 - 27th February 2008


Inactive

1st October 1984 - 31st December 2000


Active

1st January 1992


Active

4th February 2013


Active

2nd October 2015


Active

1st March 2014


Active

1st January 2003


Inactive

16th January 2007 - 31st December 2009


AMY BLACKMAN

ALTADENA

Inactive

1st January 2007 - 31st December 2013


AMY BLEA

ALTADENA

Active

12th August 2004


(default) 2 queries took 35 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 ( '(+ALTADENA)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 50505032
2SELECT COUNT(*) AS `count` FROM `la_business`.`records` AS `Record` WHERE MATCH (`Record`.`BUSINESS_NAME`, `Record`.`CITY`, `Record`.`ZIP_CODE`) AGAINST ( '(+ALTADENA)' IN BOOLEAN MODE)113