LAUREL [Permits for LAUREL]

1 - 16 of 16

HOLLOWAY, LAUREL

Individual

Active


FINANCIAL RECOVERIES

Business

Active



TAPFAR, KURT

Individual

Active



Penn Credit Corporation

Business

Active


DOUGLAS, LAUREL E

Individual

Active


CHL MORTGAGE

Business

Active


CARDILLO, CHRISTOPHER

Individual

Active



AnnieMac Home Mortgage

Business

Active


CASTLE THE WINDOW PEOPLE

Business

Active



BROWNE LAUNDRY

Business

Inactive


LAUREL WATCH, INC.

Business

Active


RMS

Business

Inactive


(default) 1 query took 252 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 ( '(+LAUREL)' IN BOOLEAN MODE) LIMIT 501616252