1. Home
  2. Sidewalk Cafe
  3. NEW YORK
  4. PIZZETTERIA BRUNETTI

PIZZETTERIA BRUNETTI PB HUDSON LLC

Sidewalk Cafe NEW YORK NY

PIZZETTERIA BRUNETTI is a registered Business operating as a Sidewalk Cafe in NEW YORK. DCA License Number 2023400-DCA is currently Active (expiry date 07/12/2018). Sidewalk Cafe Type: Unenclosed, Square Feet: 54, Tables: 4, Chairs: 8

626
HUDSON ST
NEW YORK
NY
10014

 

PIZZETTERIA BRUNETTI Data

Dca License Number 2023400-DCA
License Type Business
License Expiration Date 07/12/2018
License Status Active
License Creation Date 05/27/2015
Industry Sidewalk Cafe
Business Name PB HUDSON LLC
Business Name 2 PIZZETTERIA BRUNETTI
Address Building 626
Address Street Name HUDSON ST
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10014
Contact Phone Number
Address Borough Manhattan
Borough Code 1
Community Board 102
Council District 03
Bin 1011647
Bbl 1006260022
Nta
Census Tract
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 54, Tables: 4, Chairs: 8
Longitude -74.00555712857506
Latitude 40.73829934754088
Location (40.73829934754088, -74.00555712857506)
 
JEON, HYE SOON BROOKLYN LARBI, MARTIN BRONX

Have you worked with PIZZETTERIA BRUNETTI or used their services?

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

© 2024 NYCbizdatabase.com | Search | Privacy
(default) 3 queries took 10 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 `Record`.`DCA_License_Number` = '2023400-DCA' LIMIT 1111
2SELECT `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 `Record`.`id` < 5279 ORDER BY `Record`.`id` DESC LIMIT 1119
3SELECT `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 `Record`.`id` >= 5278 AND `Record`.`id` != 5279 ORDER BY `Record`.`id` ASC LIMIT 2220