ALTURAS

1 - 7 of 7

AL/ANNA MAZET

ALTURAS

Inactive

1st January 1987 - 30th August 1993


ALTURAS FILMS, LLC

SANTA MONICA

Inactive

1st June 2004 - 1st December 2011


ALTURAS INC

MONTEBELLO

Active

30th March 2017


Inactive

6th December 1995 - 26th August 2000


Inactive

1st September 1999 - 28th September 2001


Inactive

1st January 2007 - 29th May 2008


Inactive

10th January 2000 - 25th July 2003


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