ALAMEDA

1 - 50 of 124

1135 N ALAMEDA LLC

LOS ANGELES

Active

1st October 2013


Active

8th August 2012


Active

1st January 2018


Active

4th January 2005


Inactive

25th October 2007 - 23rd September 2008


Active

5th September 2017


Active

23rd April 2007


3 ALAMEDA PLAZA LLC

LOS ANGELES

Active

13th May 2008


330 ALAMEDA LLC

LOS ANGELES

Active

10th January 2000


Inactive

9th November 2000 - 15th August 2008


Active

1st December 2014


Active

30th November 2000


Active

1st August 2015


Active

1st January 2004


516 S ALAMEDA LLC

LOS ANGELES

Inactive

19th May 2004 - 31st December 2006


540 ALAMEDA LLC

LOS ANGELES

Active

14th February 2006


788 ALAMEDA LLC

LOS ANGELES

Inactive

1st January 2007 - 9th October 2014


940 ALAMEDA LLC

LOS ANGELES

Active

10th May 2017


Inactive

29th August 1982 - 31st December 1994


Inactive

2nd January 1981 - 31st December 1996


Active

6th June 2014


AC3 /C

ALAMEDA

Active

21st August 1995


ALAMEDA & 15TH LLC

LOS ANGELES

Active

1st January 2012


Active

17th February 2011


ALAMEDA & FOURTH, LLC

LOS ANGELES

Active

8th August 2005


Inactive

15th February 2006 - 23rd December 2015


Active

1st March 2008


ALAMEDA 41 LLC

LOS ANGELES

Active

1st January 2012


ALAMEDA AND 25TH LLC

LOS ANGELES

Inactive

15th June 1999 - 31st December 2005


ALAMEDA APPAREL INC

LOS ANGELES

Inactive

1st August 1993 - 31st December 1998


ALAMEDA APPAREL INC

LOS ANGELES

Inactive

1st April 2003 - 31st December 2005


Active

1st August 1992


Active

15th April 2017


ALAMEDA BOOKS INC

LOS ANGELES

Inactive

1st August 1993 - 30th September 2002


Active

18th June 2014


Active

1st September 2015


Active

1st February 2000


Inactive

1st February 1998 - 1st November 2004


Inactive

29th October 1998 - 31st December 1998


ALAMEDA FABRICS, INC.

LOS ANGELES

Active

28th January 2015


Active

1st March 1992


Inactive

1st April 2003 - 31st December 2006


Active

14th December 1979


Inactive

13th April 1985 - 30th June 1994


Active

1st May 2008


ALAMEDA MAIN LLC

LOS ANGELES

Inactive

25th July 2000 - 31st December 2006


Inactive

19th May 1986 - 28th July 1990


Inactive

8th August 2013 - 31st January 2015


Inactive

5th May 2009 - 31st December 2011


Inactive

1st May 2000 - 31st December 2000


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