Amusement Device Temporary [Permits for Amusement Device Temporary]

151 - 200 of 276

MCDANIEL BROTHERS SHOWS INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive



WONDERLAND MIDWAY CORP.

Business

Inactive


NEXT MARKETING, INC.

Business

Inactive




WONDERLAND MIDWAY CORP

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


ACE TENTS AMUSEMENTS CORP.

Business

Inactive



WONDERLAND MIDWAY CORP.

Business

Inactive


ACE TENTS AMUSEMENT CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


IDEKO Productions

Business

Inactive



ACE TENTS AMUSEMENT CORP.

Business

Inactive



DREAMLAND AMUSEMENTS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


C & N AMUSEMENTS

Business

Inactive


DREAMLAND AMUSEMENTS, INC.

Business

Inactive


ACE TENTS AMUSEMENTS CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


ALL-COUNTY AMUSEMENTS, INC.

Business

Inactive


ACE TENTS AMUSEMENT CORP.

Business

Inactive



WONDERLAND MIDWAY CORP.

Business

Inactive


ACE TENTS AMUSEMENT CORP.

Business

Inactive


ALL-COUNTY AMUSEMENTS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


MCDANIEL BROTHERS SHOWS INC.

Business

Inactive


ACE TENTS AMUSEMENT CORP

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive



WONDERLAND MIDWAY CORP.

Business

Inactive


MCDANIEL BROTHERS SHOWS INC.

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


TOMMY'S MIDWAY INC.

Business

Inactive


STRATES SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


Imagination The Americas Inc

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


RIVERA, ROBERT

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


(default) 2 queries took 962 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 150, 505050474
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)11488