Amusement Device Portable [Permits for Amusement Device Portable]

501 - 550 of 1041

DEFENDER DOME

Business

Inactive


WILD ONE OBSTACLE COURSE

Business

Inactive


BOUNCE

Business

Inactive


MINI OBSTACLE COURSE

Business

Active


JUMP JAM

Business

Inactive


2-4-1 ENTERTAINMENT

Business

Inactive


FUNTIME PARTY EXPRESS LLC

Business

Inactive


KONGO KRAZY SLIDE

Business

Inactive


WATER BALL SLIDE

Business

Inactive


PARTYMASTER

Business

Inactive



30X30 COMBO UNIT

Business

Inactive


COTTON CANDY CLOWNS

Business

Inactive


FOREVER JUMP, CORP

Business

Inactive


NEW YORK INFLATABLES INC.

Business

Inactive


A AARDVARK AMUSEMENT INC

Business

Active


JUNIOR CHALLENGER

Business

Inactive


LEAD DOG MARKETING GROUP, INC

Business

Inactive


ANYTHING AMUSING INC

Business

Inactive


SHOWTIME AMUSEMENTS INC.

Business

Inactive



ROCKY MOUNTAIN

Business

Active


PARTYMASTER

Business

Inactive


CATER PILLAR

Business

Inactive



TOY STORY 3 COMBO

Business

Inactive


ANYTHING AMUSING, INC

Business

Inactive


A AARDVARK AMUSEMENT INC

Business

Active


PARTY JAM INC.

Business

Inactive


BLUE BALLOON INC

Business

Inactive


PREVENT INC.

Business

Inactive


KONGO KRAZY SLIDE

Business

Inactive


BIG SLIDE

Business

Inactive


NEW YORK PARTY PEOPLES INC

Business

Inactive



BOUNCY BLVD CORP

Business

Inactive


NEW YORK INFLATABLES INC.

Business

Inactive


TROPICAL PARADISE COMNO

Business

Inactive



TRACKLESS RACE CAR

Business

Inactive


JACOBS LADDER

Business

Inactive


RAPID SLIDE

Business

Inactive


ANYTHING AMUSING, INC

Business

Inactive


ANYTHING AMUSING, INC

Business

Inactive


A AARDVARK AMUSEMENT INC

Business

Active


PARTY JAM INC.

Business

Inactive


ANY EXCUSE FOR A PARTY INC

Business

Inactive


ANYTHING AMUSING, INC

Business

Inactive


PARTYMASTER

Business

Inactive


PARTY HEADQUARTERS INC.

Business

Inactive


(default) 2 queries took 558 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 500, 505050154
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)11404