N CALDWELL [Permits for N CALDWELL]

1 - 10 of 10

CALDWELL, JAMES

Individual

Inactive


Watner, David B.

Business

Active


KLEIN, OREN

Individual

Active


DIAZ, DANIEL

Individual

Inactive


WEINMAN RESTORATION LLC

Business

Active


Pacelli, Richard

Individual

Inactive


Pacelli, Richard

Individual

Active


CALDWELL, DAMEL

Individual

Active


SIDMAN, DAVID A

Individual

Active


CALDWELL DELI CORP.

Business

Active


(default) 1 query took 209 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 ( '(+N +CALDWELL)' IN BOOLEAN MODE) LIMIT 501010209