ALTA LOMA

1 - 50 of 229

Active

3rd June 2010


87 MEDIA LLC

ALTA LOMA

Inactive

1st September 2008 - 31st December 2013


Active

1st January 2015


ABLE CONTRACTING

ALTA LOMA

Inactive

6th February 2013 - 31st December 2017


Active

10th October 2017


Inactive

1st January 1996 - 1st November 2004


Inactive

23rd July 1997 - 31st December 2007


ALAN HORVATH

ALTA LOMA

Inactive

25th March 2003 - 1st November 2004


ALAN HORVATH

ALTA LOMA

Active

1st February 2011


ALAN RYAN

ALTA LOMA

Inactive

16th June 1998 - 1st November 2004


ALBERT CUEVAS

ALTA LOMA

Inactive

25th February 2003 - 31st December 2004


Inactive

14th March 2008 - 31st December 2010


Active

18th September 2006


Inactive

15th February 2001 - 31st December 2011


ALTA LOMA LLC

LOS ANGELES

Active

1st January 2017


Inactive

21st February 2002 - 1st November 2004


ALVIN D WALKER

ALTA LOMA

Inactive

22nd May 2003 - 31st December 2014


Inactive

20th January 1995 - 1st November 2004


ANDRE MARTIN

ALTA LOMA

Inactive

30th November 1998 - 1st November 2004


Inactive

12th June 2000 - 1st November 2004


ANTHONY L USSERY

ALTA LOMA

Inactive

1st July 1995 - 24th August 1996


Inactive

18th September 2001 - 1st November 2004


ANWAR SAFAWI

ALTA LOMA

Active

10th May 2005


AYALAS MASONRY INC

ALTA LOMA

Inactive

15th April 1994 - 1st November 2004


Inactive

6th March 2003 - 1st December 2008


BERNADETTE BORELLO

ALTA LOMA

Inactive

1st October 1996 - 28th September 2001


Inactive

1st January 1988 - 30th August 1993


BOBBY WINTERS

ALTA LOMA

Inactive

6th October 2003 - 1st November 2004


BRANDON WYSOCKI

ALTA LOMA

Active

14th October 2015


BRIAN PALMER NESS

ALTA LOMA

Active

1st September 2003


BRUCE H MARSHALL

ALTA LOMA

Inactive

21st September 1998 - 1st November 2004


BRYAN COVERT

ALTA LOMA

Inactive

16th September 2010 - 31st December 2013


BRYAN LEE HEBB

ALTA LOMA

Inactive

19th August 2005 - 31st December 2007


Active

1st July 2003


Inactive

29th July 2002 - 31st December 2002


Active

1st January 2015


CAROL L. DIESS

ALTA LOMA

Inactive

31st May 2007 - 31st December 2017


CAROLYN A KIEFER

ALTA LOMA

Inactive

16th May 1991 - 31st December 1993


CARY WILLBORN

ALTA LOMA

Inactive

8th November 1993 - 1st November 2004


Active

22nd July 1996


CHARLES E GALLAND

ALTA LOMA

Inactive

17th June 1998 - 1st November 2004


CHARLES L TARVER

ALTA LOMA

Inactive

3rd February 1994 - 1st November 2004


CHARLES M BREWER

ALTA LOMA

Inactive

26th June 1978 - 1st November 2004


CHRIS BALSERI

ALTA LOMA

Active

10th March 2013


CLAREMONT PFLAG

ALTA LOMA

Inactive

5th June 2000 - 24th August 2002


CLARENCE HOFMANN

ALTA LOMA

Inactive

1st May 1998 - 1st November 2004


Inactive

12th July 2000 - 1st November 2004


Inactive

1st March 1989 - 31st December 1998


Inactive

3rd January 1995 - 31st December 2010


Inactive

28th June 1993 - 23rd August 1997


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