Amusement Device Permanent [Permits for Amusement Device Permanent]

1 - 50 of 171

DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Inactive


DENO'S WONDER WHEEL PARK

Business

Inactive


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Inactive


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Inactive


DENO'S WONDER WHEEL PARK

Business

Inactive


DENO'S WONDER WHEEL PARK

Business

Active


VODOU FOOD CORP

Business

Active






LASER BOUNCE

Business

Active




LASER BOUNCE

Business

Active


CAROUSEL

Business

Active


FUN STATION USA

Business

Active


MINER MIKE ROLLER COASTER

Business

Active


ADVENTURE'S PARK

Business

Active


VICTORIAN GARDENS

Business

Inactive


ADVENTURE'S PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active




LUNA PARK

Business

Active


LUNA PARK

Business

Active


LI'L SASSY ANNE INC.

Business

Inactive


LUNA PARK

Business

Active


FUN STATION USA

Business

Active


BUMPER CARS

Business

Inactive


12TH STREET AMUSEMENTS

Business

Inactive


KID'S PLAY LTD.

Business

Active



LUNA PARK

Business

Inactive



FUN STATION USA

Business

Active


(default) 2 queries took 349 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 505050119
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)11230