ALVARADO

1 - 50 of 1245

Inactive

2nd December 2002 - 23rd March 2016


Active

1st June 2012


1435 ALVARADO TER LLC

LOS ANGELES

Inactive

28th February 2014 - 4th November 2016


1800 ALVARADO GARDENS

LOS ANGELES

Inactive

31st December 1969 - 13th January 2004


223 N ALVARADO LLC

LOS ANGELES

Inactive

1st August 2005 - 25th July 2017


Inactive

9th April 2003 - 31st August 2005


245 N. ALVARADO, LLC

LOS ANGELES

Inactive

1st January 2010 - 30th May 2014


301 N ALVARADO LLC

LOS ANGELES

Inactive

1st March 2006 - 31st July 2017


Active

21st July 2015


320 S ALVARADO LLC

SHERMAN OAKS

Active

15th September 1998


341 ALVARADO LLC

LOS ANGELES

Inactive

12th June 2012 - 31st December 2017


Active

1st January 2017


Active

3rd September 1999


360 ALVARADO LLC

LOS ANGELES

Inactive

1st July 2003 - 1st March 2008


Inactive

1st January 1997 - 23rd July 2008


640 ALVARADO LLC

LOS ANGELES

Inactive

1st September 2004 - 31st August 2005


640 ALVARADO LLC

LOS ANGELES

Inactive

16th March 2004 - 31st December 2004


Active

7th December 1995


Active

1st January 2016


840 S ALVARADO LLC

LOS ANGELES

Inactive

22nd February 2006 - 2nd April 2015


Active

11th September 2014


914 ALVARADO LP

TARZANA

Inactive

26th February 2004 - 1st November 2006


Active

11th November 2002


AARON ALVARADO

LAKE ELSINORE

Active

7th December 2018


ABEL ALVARADO

ARLETA

Active

1st August 2016


Inactive

7th November 2000 - 16th September 2002


ABIGAIL ALVARADO

LOS ANGELES

Active

1st June 2014


ABISAI ALVARADO

COMPTON

Active

24th October 2017


Active

1st January 2011


ADA ALVARADO

LOS ANGELES

Inactive

1st March 2010 - 31st December 2012


ADAN ALVARADO

TUJUNGA

Inactive

1st January 2004 - 31st August 2005


Inactive

3rd November 2010 - 31st December 2012


ADRIAN ALVARADO

VALLEY VILLAGE

Inactive

17th September 2009 - 11th April 2011


Inactive

13th March 2011 - 31st December 2013


ALBERTO ALVARADO

N HOLLYWOOD

Inactive

10th May 2000 - 13th November 2003


ALBERTO ALVARADO

N HOLLYWOOD

Inactive

28th January 1998 - 31st December 1998


ALBERTO ALVARADO

NORTH HOLLYWOOD

Active

1st May 1994


Active

16th January 2013


Active

11th October 2007


Active

24th October 2008


Active

5th February 2005


Inactive

24th June 1997 - 31st December 2001


Inactive

15th July 1993 - 15th March 2000


ALEJANDRA I ALVARADO

LOS ANGELES

Active

1st December 2013


Inactive

1st January 2013 - 31st December 2017


Active

1st January 2015


Inactive

1st January 2003 - 1st October 2006


Active

2nd January 2006


ALFONSO ALVARADO

LOS ANGELES

Inactive

1st January 2004 - 30th May 2008


ALFONSO ALVARADO

GRANADA HILLS

Inactive

15th September 2006 - 31st December 2012


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