ADELANTO

1 - 38 of 38

Inactive

1st December 2002 - 31st December 2004


Inactive

10th March 1995 - 1st November 2004


Active

1st September 2017


Inactive

1st January 1973 - 1st January 2013


Active

29th September 2017


CWP CABINETS INC

ADELANTO

Active

5th April 2012


DAVID VALADEZ

ADELANTO

Active

13th February 2017


ERIC M REED

ADELANTO

Active

9th August 2016


Active

15th August 2016


Inactive

16th July 2002 - 1st January 2007


Active

1st October 1996


GEERARDO ROJO

ADELANTO

Inactive

1st January 1998 - 1st January 2007


GERALD JORDAN

ADELANTO

Inactive

2nd July 2009 - 1st December 2009


Active

12th June 1992


JANNET URRUTIA

ADELANTO

Inactive

1st February 2011 - 31st December 2014


JESUS TORRES

ADELANTO

Active

15th August 2017


Active

7th December 2005


Active

11th September 2018


LEOBARDO E VILLA

ADELANTO

Inactive

10th February 2001 - 13th November 2003


LEOPOLDO PINA

ADELANTO

Inactive

1st January 2002 - 14th July 2005


LUCIA HINCAPIE

ADELANTO

Inactive

1st January 2010 - 31st December 2010


MARTIN E CRESPO

ADELANTO

Inactive

1st January 2003 - 31st December 2006


Inactive

21st June 2000 - 28th September 2001


Active

11th September 2014


Inactive

1st March 1979 - 30th June 2006


Active

15th March 1992


Inactive

16th October 2015 - 31st December 2017


ROBERT ZAMBRANO

ADELANTO

Inactive

5th January 2010 - 31st December 2010


ROGELIA NINO

ADELANTO

Active

1st January 2017


S E CLEMONS INC

ADELANTO

Active

1st May 1999


Active

1st January 1991


Inactive

1st January 1989 - 1st December 2015


Inactive

25th June 2009 - 1st January 2017


Inactive

15th October 2001 - 31st December 2006


Active

1st January 2013


VANNAK TAING

ADELANTO

Inactive

1st March 2016 - 12th July 2018


Active

20th March 2012


Active

21st February 2000


(default) 1 query took 11 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 ( '(+ADELANTO)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 50383811