ENGLEWOOD CLIFFS [Permits for ENGLEWOOD CLIFFS]

1 - 23 of 23

FIRE STATION COMBO

Business

Active


SINGLE LANE SLIDE

Business

Active


FROZEN - C4

Business

Active


GABAY, EYAL

Individual

Active


CAROUSEL BOUNCER 2

Business

Active


OBSTACLE COURSE

Business

Active


LIBERTI, JOSEPH

Business

Active


JUSTICE LEAGUE

Business

Active


DISNEY PRINCESS

Business

Active



GUEST-CONSALES, EMMA T.K.

Individual

Active


Kim, Suntae

Individual

Active


Chinman, Jefferson

Individual

Active



TGI CONSTRUCTION CORP

Business

Active


UCAR, NERMIN

Individual

Active


MARMARA CONSTRUCTION

Business

Active


PALISADES COLLECTION, LLC

Business

Active



CAROUSEL BOUNCER_1

Business

Inactive


4-1 BOUNCE

Business

Inactive


VECTOR BUILDING CORP

Business

Inactive


VECTOR BUILDING CORP

Business

Inactive


(default) 1 query 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 ( '(+ENGLEWOOD +CLIFFS)' IN BOOLEAN MODE) LIMIT 502323272