ALHAMBRA

1 - 50 of 1381

168 TRADING LLC

ALHAMBRA

Active

28th July 2010


Active

1st January 1980


24ATYOURDOOR LLC

ALHAMBRA

Inactive

1st November 2004 - 31st December 2006


8.DOTS LLC

ALHAMBRA

Active

1st May 1982


A BEST CORP

ALHAMBRA

Inactive

9th August 2004 - 31st December 2011


Inactive

28th October 2008 - 1st January 2015


Active

17th December 2013


AA IMPORTER INC

ALHAMBRA

Inactive

1st January 2005 - 31st December 2010


Inactive

1st May 1978 - 31st December 2005


Active

1st July 2016


ABA EFFECTS LLC

ALHAMBRA

Active

1st May 2018


Active

29th March 2005


Inactive

11th January 1999 - 1st November 2004


ADAM GALVAN

ALHAMBRA

Active

17th October 2016


Inactive

1st April 2008 - 31st January 2011


Inactive

1st July 1949 - 1st June 2002


Inactive

15th June 1977 - 31st December 2000


Inactive

1st August 1995 - 1st December 2008


Active

1st November 1975


AI YING SUN

ALHAMBRA

Inactive

1st September 2012 - 31st December 2013


AIR BLAST INC.

ALHAMBRA

Active

21st December 2005


Inactive

1st February 1999 - 31st December 2001


Inactive

1st July 2004 - 1st July 2012


Inactive

13th November 2006 - 31st December 2007


Active

5th January 2014


ALAN TABLAS

ALHAMBRA

Active

3rd April 2018


Active

11th February 2011


Inactive

1st August 1998 - 31st December 1998


Inactive

15th January 1995 - 1st November 2004


Inactive

24th April 2009 - 31st December 2013


ALBERTO ZARZA

ALHAMBRA

Inactive

1st July 2003 - 31st December 2004


ALEEN L BROSAMLE

ALHAMBRA

Inactive

24th April 2007 - 31st December 2008


Inactive

15th April 1997 - 31st December 2010


ALEKSA SIMICH

ALHAMBRA

Active

18th July 2008


Inactive

8th February 2008 - 31st July 2008


Inactive

4th June 1997 - 28th August 1999


ALEX LAMDJANI

ALHAMBRA

Active

1st August 2001


Inactive

8th July 1993 - 15th September 2000


Inactive

6th October 2008 - 31st December 2010


ALFRED SAMNIEGO

ALHAMBRA

Inactive

1st June 1997 - 1st November 2004


ALFREDO GONZALEZ

ALHAMBRA

Inactive

2nd August 1993 - 1st November 2004


Inactive

1st July 2009 - 17th December 2013


ALHAMBRA AGORA LLC

LOS ANGELES

Active

14th April 2016


Active

16th March 2010


Active

15th November 1986


Inactive

14th July 2000 - 11th June 2003


Inactive

1st January 1988 - 28th September 2001


Inactive

10th November 2010 - 8th February 2011


Active

1st June 1999


Active

1st September 1987


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