OLD BETHPAGE [Permits for OLD BETHPAGE]

101 - 120 of 120

JVAS SOLUTIONS LLC

Business

Inactive


BATHTUB DOCTOR

Business

Inactive


15 X 15 CIRCUS BOUNCE

Business

Active


NYFF EVENTS, LLC

Business

Active


NEW YORK FUN FACTORY

Business

Active


HIPPO SHOW DOWN

Business

Active


NEW YORK FUN FACTORY

Business

Active


NEW YORK FUN FACTORY

Business

Active


PREMIER COUNTY CONSTRUCTION

Business

Inactive


VELCO WALL

Business

Active


WRECKING BALL

Business

Active



ADRENALINE RUSH

Business

Inactive


NEW YORK FUN FACTORY

Business

Active


BEE NEST CONSTRUCTION, CORP.

Business

Inactive


NEW YORK FUN FACTORY

Business

Active


TECHNORAMA PLUS, INC.

Business

Inactive


MILITARY RUSH

Business

Active


NYFF EVENTS. LLC

Business

Active


MECHANICAL BULL

Business

Inactive


(default) 2 queries took 749 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 ( '(+OLD +BETHPAGE)' IN BOOLEAN MODE) LIMIT 100, 502020389
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+OLD +BETHPAGE)' IN BOOLEAN MODE)11360