Amusement Device Permanent [Permits for Amusement Device Permanent]

101 - 150 of 171

12TH STREET AMUSEMENTS

Business

Inactive


NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive




GALACTIC ENTERPRISES INC

Business

Active


LUNA PARK

Business

Active


ADVENTURE'S PARK

Business

Active


LUNA PARK

Business

Active


NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive


SCREAM ZONE

Business

Active


ADVENTURE'S PARK

Business

Active


ADVENTURE'S PARK

Business

Active


CAROUSEL

Business

Inactive


VICTORIAN GARDENS

Business

Inactive


ADVENTURE'S PARK

Business

Active



LUNA PARK

Business

Active



DENO'S WONDER WHEEL PARK

Business

Active


FUN STATION USA

Business

Active


LUNA PARK

Business

Active


ADVENTURE'S PARK

Business

Inactive


VICTORIAN GARDENS

Business

Inactive



ADVENTURE'S AMUSEMENT PARK

Business

Active


FUN STATION USA

Business

Active


LUNA PARK

Business

Active


VICTORIAN GARDENS

Business

Inactive


SCREAM ZONE

Business

Active


MINI HIMALAYA

Business

Inactive


ADVENTURE'S AMUSEMENT PARK

Business

Active


LI'L SASSY ANNE INC.

Business

Inactive



12TH STREET AMUSEMENTS

Business

Inactive


VICTORIAN GARDENS

Business

Inactive


NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive


WANNA ANFANG COMPANY

Business

Inactive


ADVENTURE'S PARK

Business

Inactive


CAI FOODS LLC

Business

Active


RIO GRANDE TRAIN

Business

Inactive


NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive



NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive


NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive


ADVENTURE'S PARK

Business

Active


LUNA PARK

Business

Active


FLUSHING MEADOWS PARK

Business

Inactive


12TH STREET AMUSEMENTS

Business

Inactive


DENO'S WONDER WHEEL PARK

Business

Active


LUNA PARK

Business

Active


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