Amusement Device Temporary [Permits for Amusement Device Temporary]

1 - 50 of 276

NYFF EVENTS, LLC

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


Jack Morton Worldwide Inc.

Business

Inactive


ACE TENTS AMUSEMENTS CORP.

Business

Inactive


DREAMLAND AMUSEMENTS

Business

Active


Imagination The Americas Inc

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Active


NEWTON SHOWS

Business

Inactive


NY PARTYWORKS

Business

Active



REITHOFFER SHOWS, INC.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Active


REITHOFFER SHOWS, INC.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Active


WONDERLAND MIDWAY CORP.

Business

Active


WONDERLAND MIDWAY CORP.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Active


DREAMLAND AMUSEMENTS, INC.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Active


WONDERLAND MIDWAY CORP.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive



WONDERLAND MIDWAY CORP.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Active


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


(default) 2 queries took 278 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 ( '(+Amusement +Device +Temporary)' IN BOOLEAN MODE) LIMIT 50505044
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Amusement +Device +Temporary)' IN BOOLEAN MODE)11234