Amusement Device Portable [Permits for Amusement Device Portable]

101 - 150 of 1041


CARNIVAL GUYS NY, INC.

Business

Active


BILLMAR AMUSEMENTS/JOUST

Business

Active



CARNIVAL GUYS NY, INC.

Business

Active


INFLATABLE WRECKING BALL

Business

Active



20X20 CASTLE BOUNCE

Business

Active


TRAVELING TYKES, LLC

Business

Active


CLUB HOUSE

Business

Active


SLIDE WET OR DRY

Business

Active


EVERYTHING ENTERTAINMENT

Business

Active




CARNIVAL GUYS NY, INC.

Business

Active


PRINCESS PLAY BOUNCE

Business

Active




ADRENALINE RUSH

Business

Active



TRAVELING TYKES, LLC

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


VELCRO WALL

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


15X15 THEMED BOUNCE

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


A AARDVARK AMUSEMENT INC

Business

Active


DREAM CASTLE

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active




THE BULL

Business

Active


VELCRO WALL

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


BOXING

Business

Active



FUN HOUSE BOUNCE

Business

Active





A AARDVARK AMUSEMENT INC

Business

Active


EVERYTHING ENTERTAINMENT

Business

Active


CARNIVAL GUYS NY, INC.

Business

Active


OBSTACLE BOUNCE

Business

Active




CARNIVAL GUYS NY, INC.

Business

Active



CARNIVAL GUYS NY, INC.

Business

Active



(default) 2 queries took 268 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 100, 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)11238