ALISO VIEJO

1 - 50 of 163

21ST CENTURY HVAC INC

ALISO VIEJO

Inactive

1st January 2001 - 31st December 2010


Inactive

12th May 1986 - 11th June 2003


Inactive

1st November 1993 - 1st November 2004


Inactive

8th April 2010 - 31st December 2011


Active

14th June 2017


AIGEN INC

ALISO VIEJO

Inactive

11th July 2002 - 1st January 2007


Active

1st January 2018


Inactive

17th January 2013 - 31st December 2014


AMY PIKULA

ALISO VIEJO

Active

1st December 2009


ARIEL L VALLI

ALISO VIEJO

Active

1st January 2002


ASSURANCE ADVERTISING

ALISO VIEJO

Inactive

1st January 2011 - 31st December 2013


Active

13th January 2011


BAYLEE PARKER

ALISO VIEJO

Active

26th February 2014


Active

21st May 2018


BLAKE CAMPBELL

ALISO VIEJO

Inactive

29th November 2011 - 13th March 2012


Active

17th August 2016


Active

23rd March 2010


BRENT BAILEY

ALISO VIEJO

Inactive

17th November 2014 - 31st December 2014


BRENT BAILEY

ALISO VIEJO

Active

21st February 2017


BRIAN SCHWARTZ

ALISO VIEJO

Active

17th April 2017


BRIAN SCOTT SCHWARTZ

ALISO VIEJO

Inactive

16th April 2008 - 31st December 2011


BRUCE D GILLINGS

ALISO VIEJO

Inactive

1st January 2002 - 31st December 2008


BRUCE DORMANEN

ALISO VIEJO

Inactive

24th June 2002 - 31st December 2007


Inactive

1st June 1981 - 31st December 2002


CARMEN F CICCHETTI

ALISO VIEJO

Inactive

24th July 1995 - 1st November 2004


CARY SPALDING CPA AAC

ALISO VIEJO

Inactive

15th February 2008 - 31st December 2010


Inactive

5th March 2007 - 31st December 2016


Active

31st October 2013


CIRO/ANNETTE DISCALA

ALISO VIEJO

Inactive

18th March 1985 - 31st December 2001


Inactive

1st January 2013 - 31st December 2017


Active

10th September 2014


Active

28th June 2016


COLDWATER STUDIO LLC

ALISO VIEJO

Inactive

16th November 2014 - 31st December 2016


COSTEL POPA

ALISO VIEJO

Inactive

16th March 2012 - 1st October 2012


CRAIG J. PAPERO

ALISO VIEJO

Active

18th January 2015


Inactive

29th September 2006 - 31st December 2011


Active

12th September 2012


DAP WORLD INC

ALISO VIEJO

Inactive

1st July 1998 - 31st July 2009


DELTEL INC

ALISO VIEJO

Inactive

1st January 2004 - 1st March 2011


DENNIS WALLER

ALISO VIEJO

Inactive

10th February 2014 - 1st March 2014


Active

25th July 2015


DJH CONSTRUCTION INC

ALISO VIEJO

Inactive

3rd May 2010 - 31st December 2015


DOLORES VIEIRA

ALISO VIEJO

Inactive

18th January 2013 - 1st January 2016


DONALD W LINDQUIST

ALISO VIEJO

Inactive

3rd August 1988 - 31st December 2002


ECITON NETWORK INC

ALISO VIEJO

Active

26th June 2013


EDGAR S VIADO

ALISO VIEJO

Inactive

29th March 2000 - 31st December 2006


EEYE INC

ALISO VIEJO

Inactive

1st July 2003 - 31st December 2010


Inactive

23rd April 2009 - 31st December 2013


Inactive

1st January 2007 - 1st January 2002


FALK & ASSOCIATES INC

ALISO VIEJO

Inactive

10th September 2009 - 31st December 2009


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