ANDES

1 - 13 of 13

ALBERT E ANDES

FONTANA

Inactive

26th February 1998 - 1st November 2004


ANDES BY HAND LLC

PORTER RANCH

Inactive

1st July 2008 - 1st February 2011


Inactive

15th February 2015 - 1st May 2015


ANDES CORPORATION

NORTHRIDGE

Inactive

15th February 1998 - 31st December 2008


Inactive

1st March 2011 - 30th November 2011


Inactive

4th November 2001 - 31st December 2008


Inactive

23rd May 2007 - 31st December 2008


ANDES GONZALEZ

LOS ANGELES

Inactive

14th November 2012 - 15th January 2013


ANDES NATURAL, INC

LOS ANGELES

Active

8th May 2014


ANDES TRADING INC.

GRANADA HILLS

Inactive

1st January 2002 - 31st December 2013


Inactive

1st June 2003 - 31st December 2003


Active

12th September 2007


Inactive

8th January 2000 - 31st December 2002


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