CTR MORICHES [Permits for CTR MORICHES]

1 - 15 of 15

RIMI, MICHAEL

Individual

Active


SPIRA, GILBERT W

Individual

Inactive


RRAPI, KORB

Individual

Active



ABDENOUR, JOSEPH S

Individual

Inactive


ORLANDO, ANTHONY

Individual

Active


DWS INTERIORS, INC

Business

Active


BOOTH, JAMIE

Individual

Inactive


MCKEE, CHRISTOPHER

Individual

Active


BROTHER'S PAINTING CORP

Business

Inactive


LIPKIN, LEONARD

Individual

Inactive


EAST END CHIMNEY LTD.

Business

Active


GOMEZ, CLAUDIA

Individual

Inactive


KAISER, TRAVIS

Individual

Active


COHEN, SHAI

Individual

Active


(default) 1 query took 225 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 ( '(+CTR +MORICHES)' IN BOOLEAN MODE) LIMIT 501515225