ALFORD JOHN H #

INCORRECT LICENSE

Permit # issued to ALFORD JOHN H of type INCORRECT LICENSE (INCORRECT LICENSE) dated 31st December 1969 -

284
EAST 163 STREET
BRONX
BRONX
10451

 

ALFORD JOHN H Permit Data

Source DOHMH Permit
License Permit Holder ALFORD JOHN H
Business Description DOH-TRIBUNAL-ENTITY
License/permit Number
Permit Type Description INCORRECT LICENSE
Permit Subtype Description INCORRECT LICENSE
Permit Issuance Date 1900-01-01
Permit Expiration Date 1900-01-01
Permit Status Date 1900-01-01
Permit Status Description N/A
Address 284
Street EAST 163 STREET
City BRONX
Zip Code 10451
Borough BRONX
Building Id No 2001958
Borough Block Lot 2024220015
Latitude Wgs84 40.82682100
Longitude Wgs84 -73.91699100
License/permit Holder Name Unknown
Dob Skilled Trades Lic Num
Dob Skilled Trades Lic Type
 

Have you worked with ALFORD JOHN H or used their services?

Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.

(default) 3 queries took 1 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 `Permit`.`id` = 3376849 LIMIT 1111
2SELECT `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 `Permit`.`id` < 3376849 ORDER BY `Permit`.`id` DESC LIMIT 1110
3SELECT `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 `Permit`.`id` >= 3376848 AND `Permit`.`id` != 3376849 ORDER BY `Permit`.`id` ASC LIMIT 2220