ALPINE [Permits for ALPINE]

1 - 19 of 19

ALPINE CLEANERS INC

Business

Inactive


Alpine Cleaners

Business

Inactive


Alpine Cleaners

Business

Inactive


SEEGER, JOHN

Individual

Active




ALPINE GROUP USA INC

Business

Active


ALPINE 53RD STREET INC.

Business

Active



ALPINE 53RD STREET INC.

Business

Inactive


ALPINE 53 STREET INC

Business

Inactive


ALPINE GROUP USA INC

Business

Active


Alpine Cleaners

Business

Active


APPLE RENOVATORS INC.

Business

Active


ALPINE FRENCH CLEANERS

Business

Inactive


ALPINE 53RD STREET INC.

Business

Inactive


ALPINE WOODWORKS

Business

Active


ALPINE FRENCH CLEANERS

Business

Active



(default) 1 query took 214 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+ALPINE)' IN BOOLEAN MODE) LIMIT 501919214