Amusement Device Portable [Permits for Amusement Device Portable]

151 - 200 of 1041

CARNIVAL GUYS NY, INC.

Business

Active



DOUBLE LANE SLIDE

Business

Active


COMPETITION CHALLENGE

Business

Active


THEMED BOUNCE

Business

Active


EVERYTHING ENTERTAINMENT

Business

Active


FLAT ROOF BOUNCE

Business

Active


EVERYTHING ENTERTAINMENT

Business

Active


OBSTACLE

Business

Active



EVERYTHING ENTERTAINMENT

Business

Active


SIT AND SPIN

Business

Active


ADVENTURES IN CLIMBING, LLC

Business

Inactive


CARNIVAL GUYS NY, INC.

Business

Active



BIG SLIDE

Business

Active


3 IN 1 BOUNCE

Business

Active



10X12 BOUNCE

Business

Active


TRAVELING TYKES, LLC

Business

Active


15X15 THEMED BOUNCE

Business

Active




ANY EXCUSE FOR A PARTY INC

Business

Active


UNDER THE SEA

Business

Active


ANY EXCUSE FOR A PARTY INC

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active



CARNIVAL GUYS NY, INC.

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


CARNIVAL GUYS NY, 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



CARNIVAL GUYS NY, INC.

Business

Active


JOUST

Business

Active




TUBS OF FUN

Business

Active


AIR FAIR ENTERTAINMENT INC.

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


ANY EXCUSE FOR A PARTY INC

Business

Active


CLOWNS.COM, INC.

Business

Active


(default) 2 queries took 272 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 150, 50505030
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)11242