Amusement Device Temporary [Permits for Amusement Device Temporary]

201 - 250 of 276

WONDERLAND MIDWAY CORP

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


ACE TENTS AMUSEMENTS CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive



WONDERLAND MIDWAY CORP

Business

Inactive


RIVERA, ROBERT

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


ALL-COUNTY AMUSEMENTS, INC.

Business

Inactive


DREAMLAND AMUSEMENTS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive



WONDERLAND MIDWAY CORP.

Business

Inactive


NEWTOWN SHOWS

Business

Active


WONDERLAND MIDWAY CORP

Business

Inactive


TOMMY'S MIDWAY INC.

Business

Inactive



ACE TENTS AMUSEMENTS CORP.

Business

Inactive


Dean and Flynn, Inc.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive



REITHOFFER SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive



REITHOFFER SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


iDEKO Productions LLC

Business

Inactive



DREAMLAND AMUSEMENTS, INC.

Business

Inactive


iDEKO Productions LLC

Business

Inactive


ACE TENTS AMUSEMENTS CORP.

Business

Active


ACE TENTS AMUSEMENT CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


REITHOFFER SHOWS, INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive



ACE TENT AMUSEMENT CORP.

Business

Inactive


WONDERLAND MIDWAY CORP

Business

Inactive


(default) 2 queries took 1270 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 200, 505050701
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)11569