265 LAFAYETTE RISTORANTE LLC

Sidewalk Cafe NEW YORK NY

265 LAFAYETTE RISTORANTE LLC is a registered Business operating as a Sidewalk Cafe in NEW YORK. DCA License Number 2009341-DCA is currently Active (expiry date 04/15/2020). Sidewalk Cafe Type: Small Unenclosed, Square Feet: 188, Tables: 7, Chairs: 14

263
LAFAYETTE ST
NEW YORK
NY
10012

 

265 LAFAYETTE RISTORANTE LLC Data

Dca License Number 2009341-DCA
License Type Business
License Expiration Date 04/15/2020
License Status Active
License Creation Date 06/09/2014
Industry Sidewalk Cafe
Business Name 265 LAFAYETTE RISTORANTE LLC
Business Name 2
Address Building 263
Address Street Name LAFAYETTE ST
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10012
Contact Phone Number
Address Borough Manhattan
Borough Code 1
Community Board 102
Council District 01
Bin 1007524
Bbl 1004950011
Nta MN24
Census Tract 43
Detail Sidewalk Cafe Type: Small Unenclosed, Square Feet: 188, Tables: 7, Chairs: 14
Longitude -73.99662317089374
Latitude 40.723494223396
Location (40.723494223396, -73.99662317089374)
 

Have you worked with 265 LAFAYETTE RISTORANTE LLC 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 2 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` = '2009341-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` < 121401 ORDER BY `Record`.`id` DESC LIMIT 1111
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` >= 121400 AND `Record`.`id` != 121401 ORDER BY `Record`.`id` ASC LIMIT 2220