AMERICAN CANYON

1 - 5 of 5

AIR AMERICAN INC

CANYON COUNTRY

Active

28th November 2012


Active

23rd September 2016


BERNARD JOSEPH ZIPAY

AMERICAN CANYON

Inactive

19th February 2003 - 19th March 2005


NEIL PEDRO COATES

AMERICAN CANYON

Inactive

29th October 2013 - 10th February 2014


Inactive

1st January 2008 - 1st July 2009


(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 ( '(+AMERICAN +CANYON)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 505511