PALISADES [Permits for PALISADES]

1 - 16 of 16

PETROCELLI, JOHN

Individual

Active


SAPUN, ASTRIT T

Individual

Inactive


MOHAMMAD, AFFAN

Individual

Active


Jung, Jimmy

Individual

Active


ASSET BASED VALUE CORP.

Business

Active


coruk, kevin

Individual

Inactive


KIM, BOONG Y

Individual

Active


BARANEK, MATTHEW

Individual

Active



SERGEYEV, OLEG

Individual

Active


PALISADES COLLECTION, LLC

Business

Active


LEE, YONG WOK

Individual

Inactive


BROWNSTEIN, WILLIAM

Individual

Active



TANENBAUM, ALVIN

Individual

Active


SHIM, BOHYUN

Individual

Active


(default) 1 query took 222 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 ( '(+PALISADES)' IN BOOLEAN MODE) LIMIT 501616222