Amusement Device Portable [Permits for Amusement Device Portable]

351 - 400 of 1041

C & N AMUSEMENTS

Business

Active


COTTON CANDY CLOWNS, LLC

Business

Active


SLIDE

Business

Active


SLIP'N' SLIDE RACE WET

Business

Active


C & N AMUSEMENTS

Business

Active


NEW YORK PARTY PEOPLES INC

Business

Active


INFLATABLE BOUNCE

Business

Active



WILD ONE

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


SLIDE DOUBLE LANE

Business

Active


PARTY PERFECT RENTALS LLC

Business

Active


COTTON CANDY CLOWNS, LLC

Business

Active


A WHOLE LOT OF BOUNCE INC.

Business

Active


PARTY JAM INC.

Business

Active


PARTY PERFECT RENTALS LLC

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


JR OLYMPICS

Business

Active


A WHOLE LOT OF BOUNCE INC.

Business

Active


JACOBS LADDER

Business

Active


BERRY GO ROUND

Business

Active


TWINSPIN

Business

Active


INFLATABLE BOUNCE

Business

Active


DRY SLIDE

Business

Active


BUNGEE BASKETBALL

Business

Active



40' OBSTACLE COURSE

Business

Active


A WHOLE LOT OF BOUNCE INC.

Business

Active


A TOTAL JUMP

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


COMBO BOUNCER/SLIDE

Business

Active


JURASSIC ADVENTURE

Business

Active


DEFENDER DOME

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


A WHOLE LOT OF BOUNCE INC.

Business

Active


TRACKLESS TRAIN

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


PARTY JAM INC.

Business

Active


PARTY PERFECT RENTALS LLC

Business

Active


PARTY JAM INC.

Business

Active


NEW YORK PARTY PEOPLES INC

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


PARTY JAM INC.

Business

Active



NEW YORK PARTY PEOPLES INC

Business

Active


PARTY PERFECT RENTALS LLC

Business

Active



SLIDE

Business

Active


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