1. Home
  2. Sidewalk Cafe
  3. NEW YORK
  4. 1274 AMSTERDAM TRATTORIA INC.

1274 AMSTERDAM TRATTORIA INC.

Sidewalk Cafe NEW YORK NY

1274 AMSTERDAM TRATTORIA INC. is a registered Business operating as a Sidewalk Cafe in NEW YORK. DCA License Number 1073015-DCA is currently Active (expiry date 04/15/2019). Sidewalk Cafe Type: Unenclosed, Square Feet: 314, Tables: 10, Chairs: 25

Telephone: 2122882937.

1274
AMSTERDAM AVE
NEW YORK
NY
10027

 

1274 AMSTERDAM TRATTORIA INC. Data

Dca License Number 1073015-DCA
License Type Business
License Expiration Date 04/15/2019
License Status Active
License Creation Date 01/07/2005
Industry Sidewalk Cafe
Business Name 1274 AMSTERDAM TRATTORIA INC.
Business Name 2
Address Building 1274
Address Street Name AMSTERDAM AVE
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10027
Contact Phone Number 2122882937
Address Borough Manhattan
Borough Code 1
Community Board 109
Council District 9
Bin 1059680
Bbl 1019770036
Nta MN09
Census Tract 211
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 314, Tables: 10, Chairs: 25
Longitude -73.9579291364163
Latitude 40.81111792590417
Location (40.81111792590417, -73.9579291364163)
 
R & R USED CAR AUTO SALES INC BROOKLYN WITMAN LAUNDROMAT INC. BROOKLYN

Have you worked with 1274 AMSTERDAM TRATTORIA INC. 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 27 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` = '1073015-DCA' LIMIT 11125
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` < 123548 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` >= 123547 AND `Record`.`id` != 123548 ORDER BY `Record`.`id` ASC LIMIT 2221