Cliffside Park [Permits for Cliffside Park]

1 - 18 of 18

TOREMIS, MUSTAFA A.

Individual

Inactive


CRETELLA, CLEMENTE

Individual

Active


TUFEKCI, YUSUF CAN

Individual

Active


TACEN, EDGAR

Individual

Inactive


DEMO CONTRACTORS, LLC

Business

Active


HAMOUDEH, MOHAMAD

Individual

Active


TAGHIAN, MEHRAN

Individual

Active


E.R. GENERAL CONTRACTOR CORP.

Business

Inactive



SABAN, IBRAHIM

Individual

Inactive


Onur Cayirli

Business

Inactive


DEJANGOCYAN, ARET

Individual

Inactive


BRICENO, ADRIANA

Individual

Inactive


MARTORI, MILDRED

Individual

Inactive


ASIMAKIS, ELIAS

Individual

Active


BELLOCQ, LUIS H

Individual

Active


LOWELL'S MECHANICAL CORP.

Business

Inactive


YIMAZ, SALIH

Individual

Active


(default) 1 query took 240 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 ( '(+Cliffside +Park)' IN BOOLEAN MODE) LIMIT 501818240