Amusement Device Portable [Permits for Amusement Device Portable]

51 - 100 of 1041

WATERBALL SLIDE

Business

Active


HELICOPTER

Business

Active


HOUSE OF AIR LLC

Business

Inactive


THE WILD ONE

Business

Active


DUAL LANE SLIDE

Business

Active


SESAME STREET 5-1

Business

Active


BOOT CAMP

Business

Active


UPROAR WRECKING BALL

Business

Active


MAZE

Business

Active


ROCKWALL

Business

Active


TIKI ISLAND INFL ROCK WALL

Business

Active


SWING AROUND

Business

Active


WILD RAPIDS WATER SLIDE

Business

Active


WRECKING BALL

Business

Active



LITTLE SWING

Business

Active





SPONGEBOB 5 IN 1 BOUNCE

Business

Active


LIBERTI, JOSEPH

Business

Active



INFLATABLE JOUST

Business

Active


INFLATABLE ROCK WALL

Business

Active


JUSTICE LEAGUE

Business

Active


DISNEY PRINCESS

Business

Active


GLOZAK, REGINA

Business

Inactive


CRASH COURSE

Business

Active



DOUBLE GIANT SLIDE

Business

Active


FLYING DRAGON

Business

Active


5-1

Business

Active


TURBO TUBS

Business

Active


A & C OBSTACLE CHALLENGE

Business

Active


DIXIE TWISTER RIDE

Business

Active


MADAGASCAR 5-1

Business

Active


ADRENALINE RUSH

Business

Active


DISNEY 5 IN 1 BOUNCE

Business

Active


16X16 DELUXE MOONWALK

Business

Active






BILLMAR AMUSEMENTS/BOXING

Business

Active


CAROUSEL BOUNCE

Business

Active


GYROSCOPE

Business

Active


SESAME STREET 5 IN 1

Business

Active


FIRETRUCK SLIDE

Business

Active



EVERYTHING ENTERTAINMENT

Business

Active


(default) 2 queries took 256 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 50, 50505027
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)11229