ALOHA

1 - 50 of 61

Active

13th December 2006


ALOHA APPAREL INC

LOS ANGELES

Inactive

1st August 2004 - 31st December 2007


ALOHA ATHENA

WOODLAND HILLS

Active

1st August 2018


Active

1st April 2014


Active

1st January 2015


Active

1st July 1975


ALOHA CORP

THOUSAND OAKS

Inactive

2nd January 1983 - 23rd May 2007


ALOHA DAY CAMP LLC

WEST HILLS

Active

1st March 2000


Active

15th March 1999


ALOHA FASHION INC

LOS ANGELES

Inactive

2nd February 2005 - 31st December 2011


ALOHA FASHION, INC.

LOS ANGELES

Inactive

1st October 2014 - 30th July 2016


ALOHA FASTENING SYSTEMS

SANTA CLARITA

Inactive

1st August 2006 - 31st December 2011


Inactive

17th June 2003 - 30th November 2005


ALOHA GARMENT INC

LOS ANGELES

Inactive

15th December 2010 - 31st December 2013


ALOHA HOUSING LLC

LOS ANGELES

Active

21st April 2014


Inactive

1st January 2007 - 31st December 2010


ALOHA INVESTMENTS LLC

STUDIO CITY

Inactive

10th September 2007 - 31st December 2008


Active

28th February 1992


ALOHA JACTA EST INC

LOS ANGELES

Active

1st March 2012


ALOHA JOHNSON

LOS ANGELES

Inactive

1st August 2010 - 1st January 2014


ALOHA LAUNDRY

WOODLAND HILLS

Active

3rd March 2015


Inactive

21st August 1997 - 31st December 2006


ALOHA MUSIC GROUP LLC

LOS ANGELES

Active

1st August 2010


ALOHA PACIFIC INC

WOODLAND HILLS

Inactive

1st May 1998 - 1st April 2001


Inactive

2nd January 1975 - 31st December 1995


Inactive

15th August 1978 - 31st December 1995


Inactive

2nd January 1990 - 30th June 1994


Inactive

1st December 1994 - 31st December 1995


Inactive

1st February 1986 - 31st December 1995


Inactive

1st January 1980 - 31st December 1995


Inactive

1st December 1985 - 31st December 1995


Inactive

1st June 1969 - 31st December 1995


Inactive

2nd January 1979 - 31st December 1993


Inactive

1st February 1984 - 31st December 1995


Inactive

22nd July 1994 - 31st December 1995


Inactive

15th August 1978 - 31st December 1995


Inactive

1st December 1986 - 31st December 1995


Inactive

1st January 1989 - 31st December 1995


ALOHA PICTURES LLC

LOS ANGELES

Inactive

3rd September 2003 - 14th November 2013


Active

10th March 2018


ALOHA PRODUCTIONS INC

LOS ANGELES

Inactive

31st December 1969 - 16th April 2008


ALOHA PRODUCTS INC

LOS ANGELES

Inactive

3rd March 1981 - 1st April 1996


Inactive

23rd March 1997 - 1st March 2002


Active

11th September 2015


Active

28th August 2008


ALOHA SCHOOL /C

LOS ANGELES

Active

1st September 1977


ALOHA SIGNS & GRAPHICS

GRANADA HILLS

Inactive

1st January 2002 - 31st December 2010


ALOHA SPIRIT LLC

SANTA MONICA

Inactive

1st February 2008 - 31st December 2014


Inactive

20th June 2008 - 31st December 2010


ALOHA SYSTEMS INC

RIVERSIDE

Inactive

8th January 2004 - 31st December 2011


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