ALLENTOWN

1 - 11 of 11

Active

1st January 2001


Active

14th April 1998


DAY TIMERS INC

ALLENTOWN

Inactive

11th June 1992 - 30th August 1993


Inactive

29th June 1993 - 1st September 1994


Inactive

20th January 2010 - 1st January 2016


Inactive

27th April 1993 - 1st September 1994


SPIRAX SARCO INC

ALLENTOWN

Inactive

21st April 1983 - 31st December 2000


Active

19th December 1991


Active

5th June 1995


Active

21st November 2011


Active

1st January 1996


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