AMSTERDAM FRESH STORE ZUNIGA, LUIS ENRIQUE & SUQUINAGUA CARMEN CECILIA

Stoop Line Stand NEW YORK NY

AMSTERDAM FRESH STORE is a registered Business operating as a Stoop Line Stand in NEW YORK. DCA License Number 2029636-DCA is currently Active (expiry date 03/31/2020). Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 1, 5 foot stands: 0, 5.01 to 10 foot stands: 0

1701
AMSTERDAM AVE
STORE # 4-C
NEW YORK
NY
10031

 

AMSTERDAM FRESH STORE Data

Dca License Number 2029636-DCA
License Type Business
License Expiration Date 03/31/2020
License Status Active
License Creation Date 10/19/2015
Industry Stoop Line Stand
Business Name ZUNIGA, LUIS ENRIQUE & SUQUINAGUA CARMEN CECILIA
Business Name 2 AMSTERDAM FRESH STORE
Address Building 1701
Address Street Name AMSTERDAM AVE
Secondary Address Street Name STORE # 4-C
Address City NEW YORK
Address State NY
Address Zip 10031
Contact Phone Number
Address Borough Manhattan
Borough Code 1
Community Board 109
Council District 07
Bin 1061300
Bbl 1020590032
Nta MN04
Census Tract 227
Detail Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 1, 5 foot stands: 0, 5.01 to 10 foot stands: 0
Longitude -73.94795166553575
Latitude 40.824744130243054
Location (40.824744130243054, -73.94795166553575)
 

Have you worked with AMSTERDAM FRESH STORE 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 7 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` = '2029636-DCA' LIMIT 1115
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` < 99752 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` >= 99751 AND `Record`.`id` != 99752 ORDER BY `Record`.`id` ASC LIMIT 2221