Permit # issued to WHITE PLAINS RD. BURGERS CO., INC. of type MANUF FROZEN DESSERT (MANUF FROZEN DESSERTRETAIL) -
2177
WHITE PLAINS ROAD
BRONX
BRONX
10462
| Source | DOHMH Permit |
| License Permit Holder | WHITE PLAINS RD. BURGERS CO., INC. |
| Business Description | N/A |
| License/permit Number | 4055 |
| Permit Type Description | MANUF FROZEN DESSERT |
| Permit Subtype Description | MANUF FROZEN DESSERTRETAIL |
| Permit Issuance Date | 0000-00-00 |
| Permit Expiration Date | 0000-00-00 |
| Permit Status Date | 1900-01-01 |
| Permit Status Description | |
| Address | 2177 |
| Street | WHITE PLAINS ROAD |
| City | BRONX |
| Zip Code | 10462 |
| Borough | BRONX |
| Building Id No | 2095032 |
| Borough Block Lot | 2043170056 |
| Latitude Wgs84 | 40.85599500 |
| Longitude Wgs84 | -73.86800500 |
| License/permit Holder Name | TUMMINELLO, FRANK |
| Dob Skilled Trades Lic Num | |
| Dob Skilled Trades Lic Type |
Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `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` = 2603853 LIMIT 1 | 1 | 1 | 11 | |
| 2 | SELECT `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` < 2603853 ORDER BY `Permit`.`id` DESC LIMIT 1 | 1 | 1 | 5 | |
| 3 | SELECT `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` >= 2603852 AND `Permit`.`id` != 2603853 ORDER BY `Permit`.`id` ASC LIMIT 2 | 2 | 2 | 11 |