ALFORD

1 - 42 of 42


ALFORD WILLIAM

#

INCORRECT LICENSE


WILLIAM ALFORD

#

INCORRECT LICENSE


ALFORD WILLIAM H

#

INCORRECT LICENSE


WILLIAM H. ALFORD

#

INCORRECT LICENSE


WILLIAM ALFORD

#

INCORRECT LICENSE


ALFORD, DENNIS

#

FOOD SERVICE EST.

FAR ROCKAWAY

QUEENS


CLAYTON ALFORD

#

INCORRECT LICENSE

BRONX

BRONX


CLAXTON ALFORD A

#

INCORRECT LICENSE

BRONX

BRONX


ALFORD EDWARDS

#

FOOD SERVICE ESTAB

BROOKLYN

BROOKLYN


JAMES C. ALFORD

#

BARBER SHOP


CLAXTON ALFORD

#

INCORRECT LICENSE


CLAXTON ALFORD

#

INCORRECT LICENSE


EDWARDS, ALFORD

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


ALFORD EDWARDS

#

FOOD SERVICE ESTAB

BROOKLYN

BROOKLYN


ALFORD, TAHIRA

#

TEMP FOOD SERV ESTAB


CLAXTON ALFORD A

#

INCORRECT LICENSE

BRONX

BRONX


CLAXTON ALFORD

#

INCORRECT LICENSE


WILLIAM ALFORD

#

INCORRECT LICENSE


ALFORD SERVICE

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


ALFORD, TAHIRA

#

TEMP FOOD SERV ESTAB


MCBEAN, ALFORD

#

FOOD SERVICE EST.


EDWARDS, ALFORD

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


TINA ALFORD

#

DOHMH permit not required

SAINT ALBANS

QUEENS


MCBEAN, ALFORD

#

FOOD SERVICE EST.


MCBEAN, ALFORD

#

FOOD SERVICE EST.


GEORGE M. ALFORD

#

FOOD VENDOR LICENSE


WILLIAM H. ALFORD

#

INCORRECT LICENSE


VERONICA ALFORD

#

INCORRECT LICENSE


CLAYTON ALFORD

#

INCORRECT LICENSE

BRONX

BRONX


CLAXTON ALFORD

#

INCORRECT LICENSE


ALFORD JOHN H

#

INCORRECT LICENSE

BRONX

BRONX


ALFORD W.

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


ALFORD JOHN

#

INCORRECT LICENSE


MARTHA ALFORD

#

INCORRECT LICENSE


ALFORD, TAHIRA

#

TEMP FOOD SERV ESTAB


MCBEAN, ALFORD

#

FOOD SERVICE EST.


MCBEAN, ALFORD

#

FOOD SERVICE EST.


MCBEAN, ALFORD

#

FOOD SERVICE EST.


MCBEAN, ALFORD

#

FOOD SERVICE EST.


MCBEAN, ALFORD

#

FOOD SERVICE EST.


MCBEAN, ALFORD

#

FOOD SERVICE EST.


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