CARMEL

151 - 200 of 292

CARMEL CEMETERY MOUNT

#

WELL WATER


STATEN ISLAND

STATEN ISLAND



CARMEL SIRAGUSA

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


NEW YORK

MANHATTAN


MONT CARMEL BAKERY INC

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


CARMEL CEMETERY MOUNT

#

WELL WATER


CARMEL BARRETT

#

INCORRECT LICENSE

BRONX

BRONX


CARMEL REAL ESTATE EQ

#

INCORRECT LICENSE

BRONX

BRONX


JAMAICA

QUEENS


CARMEL HALL

#

TEMP FOOD SERV ESTAB


CHALAK REALTY CORP: MT CARMEL STA

#

INCORRECT LICENSE

BRONX

BRONX


OUR LADY OF MT. CARMEL CHURCH

#

FOOD SERVICE ESTAB

NEW YORK

MANHATTAN


CARMEL PALACE, INC.

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


CARMEL PALACE, INC.

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


CARMEL EQUITIES LLC

#

INCORRECT LICENSE

NEW YORK

MANHATTAN


OUR LADY OF MT CARMEL CHURCH

#

TEMP FOOD SERV ESTAB


CARMEL REAL ESTATE EQ

#

INCORRECT LICENSE

BRONX

BRONX


CARMEL CEMETERY MOUNT

#

WELL WATER


COLLINS III, CARMEL P.

#

FOOD VENDOR LICENSE

NEW YORK

MANHATTAN


CARMEL, HALL

#

TEMP FOOD SERV ESTAB


CARMEL HALL

#

TEMP FOOD SERV ESTAB



HALL, CARMEL

#

TEMP FOOD SERV ESTAB


MT CARMEL BAPTSIST CHURCH

#

INCORRECT LICENSE


HALL, CARMEL

#

TEMP FOOD SERV ESTAB



CARMEL CEMETERY MOUNT

#

WELL WATER


CARMEL PALACE, INC.

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


CARMEL CEMETERY MOUNT

#

WELL WATER


CARMEL CEMETERY MOUNT

#

WELL WATER


CARMEL ENTERPRISES

#

INCORRECT LICENSE

NEW YORK

MANHATTAN


MT. CARMEL BAPT CHURCH

#

INCORRECT LICENSE


MT. CARMEL BAPTIST CHURCH

#

AFTER SCHOOL

BRONX

BRONX


CARMEL BAKERY, INC.

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


HALL CARMEL-W.I. DAY FESTIVAL

#

TEMP FOOD SERV ESTAB


BRONX

BRONX


REDDINGTON CARMEL

#

INCORRECT LICENSE

STATEN ISLAND

STATEN ISLAND


CARMEL - MD DONOVAN

#

PHYSICIAN

NEW YORK

MANHATTAN


MT CARMEL BAPTISH CHURCH

#

INCORRECT LICENSE

BRONX

BRONX


CARMEL/HOLY ROS MT

#

FOOD SVC ESTAB. NON


OUR LADY OF MT.CARMEL

#

INCORRECT LICENSE


DESIR MARIE CARMEL

#

INCORRECT LICENSE

JAMAICA

QUEENS


MARIE CARMEL HOUANCHE

#

INCORRECT LICENSE


CARMEL DONOVAN DR.

#

PHYSICIAN

NEW YORK

MANHATTAN


CARMEL-YORK INC

#0007078

EQUIPMENT WORK

BRONX

BRONX


CARMEL-YORK INC

#0007078

EQUIPMENT WORK

BRONX

BRONX


CARMEL - MD DONOVAN

#

PHYSICIAN




(default) 2 queries took 37 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Permit`.`id`, `Permit`.`Source`, `Permit`.`License_Permit_Holder`, `Permit`.`Business_Description`, `Permit`.`License/Permit_Number`, `Permit`.`Permit_Type_Description`, `Permit`.`Permit_Subtype_Description`, `Permit`.`Permit_Issuance_Date`, `Permit`.`Permit_Expiration_Date`, `Permit`.`Permit_Status_Date`, `Permit`.`Permit_Status_Description`, `Permit`.`Address`, `Permit`.`Street`, `Permit`.`City`, `Permit`.`Zip_Code`, `Permit`.`Borough`, `Permit`.`Building_ID_No`, `Permit`.`Borough_Block_Lot`, `Permit`.`Latitude_WGS84`, `Permit`.`Longitude_WGS84`, `Permit`.`License/Permit_Holder_Name`, `Permit`.`DOB_Skilled_Trades_Lic_Num`, `Permit`.`DOB_Skilled_Trades_Lic_Type` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+CARMEL)' IN BOOLEAN MODE) LIMIT 150, 50505023
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+CARMEL)' IN BOOLEAN MODE)1114