ANAHEIM HLS

1 - 50 of 2391

1010 ANAHEIM LLC

WILMINGTON

Inactive

2nd June 1997 - 14th December 2001


Inactive

19th May 2014 - 18th July 2014


1223 ANAHEIM ST LLC

HARBOR CITY

Active

11th February 2002


Inactive

10th May 2010 - 31st December 2013


1311 ANAHEIM, LLC

HARBOR CITY

Active

20th April 2017


1345 ANAHEIM LLC

LOS ANGELES

Active

30th November 2012


Inactive

18th December 2012 - 31st December 2017


Inactive

12th November 2014 - 11th September 2015


Inactive

23rd November 1992 - 1st November 2004


Active

12th November 1992


Active

26th July 2018


Inactive

17th June 2004 - 31st December 2005


Active

5th November 2015


2523 E ANAHEIM INC

WILMINGTON

Active

6th January 2003


Inactive

3rd May 2002 - 31st December 2004


Inactive

31st March 2007 - 31st December 2010


Inactive

4th August 2003 - 1st November 2004


Active

11th April 2014


Inactive

31st August 2005 - 31st December 2010


Active

17th April 2017


A BENNER CORP

ANAHEIM

Inactive

1st June 1997 - 1st November 2004


Inactive

1st February 1996 - 1st November 2004


Inactive

1st January 1995 - 1st November 2004


Inactive

19th October 2010 - 31st December 2012


Active

28th November 2018


Inactive

2nd June 2011 - 1st December 2011


Inactive

8th September 1989 - 30th June 2005


A&D SIGNS CORP

ANAHEIM

Active

1st January 2017


Active

1st September 1996


Inactive

15th September 2000 - 1st November 2004


Inactive

1st January 1987 - 24th August 1992


Active

25th May 2000


Inactive

1st January 2011 - 31st December 2014


AARON HAMILTON

ANAHEIM

Active

4th October 1995


Active

17th October 2013


Inactive

1st January 2007 - 31st December 2007


Inactive

25th January 1996 - 1st November 2004


Inactive

24th August 2006 - 19th October 2006


ABEL TREJO

ANAHEIM

Active

26th January 2018


Inactive

9th April 1997 - 31st December 2000


Active

10th January 2015


ABL SIGNS INC

ANAHEIM

Inactive

25th September 2001 - 1st November 2004


Inactive

30th October 2001 - 31st December 2001


AC ALL STAR

ANAHEIM

Active

25th February 2017


Inactive

13th April 2001 - 30th September 2003


Active

4th June 2007


Inactive

19th June 2000 - 31st December 2017


Active

8th December 2010


Active

4th December 2008


Active

10th January 2005


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