Amusement Device Portable [Permits for Amusement Device Portable]

251 - 300 of 1041


AIR FAIR ENTERTAINMENT INC.

Business

Active




TOP LINE PARTIES & EVENTS INC.

Business

Inactive


ANY EXCUSE FOR A PARTY INC

Business

Active


PARTY JAM INC.

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


CLIFF HANGER

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active



ANY EXCUSE FOR A PARTY INC

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


ANY EXCUSE FOR A PARTY INC

Business

Active


DALMATION BOUNCE

Business

Active


ROCKY MOUNTAIN

Business

Active


JOE & DONS KING KONG RIDE

Business

Active


ANY EXCUSE FOR A PARTY INC

Business

Active



CARNIVAL GUYS NY, INC.

Business

Active


ANY EXCUSE FOR A PARTY INC

Business

Active


CLOWNS.COM, INC.

Business

Active




ANY EXCUSE FOR A PARTY INC

Business

Active


ANY EXCUSE FOR A PARTY INC

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active



CARNIVAL GUYS NY, INC.

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


ANY EXCUSE FOR A PARTY INC

Business

Active


AIR FAIR ENTERTAINMENT INC.

Business

Active


EVERYTHING ENTERTAINMENT

Business

Active


NY PARTYWORKS

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active



NY PARTYWORKS

Business

Active


A WHOLE LOT OF BOUNCE INC.

Business

Active


PARTY JAM INC.

Business

Active


PARTY PERFECT RENTALS LLC

Business

Active


COTTON CANDY CLOWNS, LLC

Business

Active


PARTY JAM INC.

Business

Active


INFLATABLE BOUNCE

Business

Active


LOONEY TUNES

Business

Active


GLADIATOR JOUST

Business

Active


CAROUSEL BOUNCE

Business

Active


ROCKWALL # 3

Business

Active


INFLATABLE BOUNCE

Business

Active


COTTON CANDY CLOWNS, LLC

Business

Active


CAROUSEL BOUNCE

Business

Active


(default) 2 queries took 273 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 250, 50505041
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)11232