AMHERST

1 - 34 of 34

Active

19th August 2014


1427 AMHERST AVE, LLC

LOS ANGELES

Active

1st January 2005


Inactive

24th December 1996 - 27th September 2001


Active

31st May 2016


AMHERST AMT LLC

LOS ANGELES

Inactive

1st July 2007 - 1st June 2009


Active

11th September 2013


AMHERST BELLE LLC

LOS ANGELES

Active

14th June 2011


AMHERST CAPITAL, LLC

LOS ANGELES

Inactive

1st December 2004 - 31st December 2017


AMHERST DIAMOND LLC

LOS ANGELES

Active

7th October 2010


AMHERST EAST

SANTA MONICA

Active

1st February 1973


Active

1st January 2017


Inactive

1st October 2002 - 31st December 2015


Inactive

14th November 1995 - 30th November 1996


AMHERST KITCHEN LLC

LOS ANGELES

Active

1st February 2017


AMHERST PLAZA LLC

LOS ANGELES

Active

1st January 2006


Inactive

17th October 2012 - 12th June 2014


Active

1st April 2001


AMHERST ROCHESTER LLC

LOS ANGELES

Active

1st January 2010


AMHERST SQUARE LLC

LOS ANGELES

Active

16th December 2008


AMHERST TOWERS LLC

LOS ANGELES

Active

1st June 1996


AMHERST WAY LLC

LOS ANGELES

Active

8th April 2009


AMHERST/GRANVILLE LTD

LOS ANGELES

Inactive

1st December 1972 - 18th July 2007


BIRDAIR INC

AMHERST

Active

1st January 2008


Inactive

18th January 2010 - 31st December 2011


Inactive

20th March 2001 - 1st November 2004


ILN AMHERST CORPORATION

WEST HOLLYWOOD

Inactive

24th January 2008 - 31st December 2010


Inactive

1st January 1989 - 23rd August 1997


Active

31st October 2013


Inactive

15th November 1991 - 23rd August 1997


R J AMHERST LLC

LOS ANGELES

Active

4th January 2008


Active

7th April 1995


Inactive

26th December 1995 - 28th August 1999


VALITEK INC

AMHERST

Inactive

26th June 1992 - 30th August 1993


Active

1st August 1993


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