AMSTERDAM [Permits for AMSTERDAM]

51 - 84 of 84


AMSTERDAM CLEANER CORP.

Business

Active


THE GIN MILL

Business

Active


AMSTERDAM FRESH STORE

Business

Active



AMSTERDAM ALE HOUSE INC

Business

Active


PIZZERIA SIRENETTA

Business

Active


BODRUM

Business

Active


480 REST AMSTERDAM INC.

Business

Inactive


CAFFI NOI

Business

Inactive


DIVE BAR

Business

Active




Amsterdam iPhone Repair inc

Business

Active


AMSTERDAM DELI

Business

Inactive



COCCOLA

Business

Inactive


147 AMSTERDAM CLEANERS INC.

Business

Active


PINKBERRY

Business

Inactive


AMSTERDAM PAWN SHOP CORP.

Business

Active


SPICE

Business

Active


MCALEER'S PUB

Business

Inactive



412 AMSTERDAM CORP.

Business

Active


AMSTERDAM GARAGE LLC

Business

Active


HI-LIFE BAR & GRILL

Business

Active


HUMMUS KITCHEN

Business

Inactive


NIEUW AMSTERDAM KITCHENS

Business

Inactive



983 AMSTERDAM DRY CLEANERS

Business

Active



FUMO ITALIAN FOOD & PIZZA

Business

Active




(default) 2 queries took 499 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 ( '(+AMSTERDAM)' IN BOOLEAN MODE) LIMIT 50, 503434270
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+AMSTERDAM)' IN BOOLEAN MODE)11229