NANCY AND FRIENDS DELI GROCERY SUPERMARKET LLC

Stoop Line Stand BROOKLYN NY

NANCY AND FRIENDS DELI GROCERY SUPERMARKET LLC is a registered Business operating as a Stoop Line Stand in BROOKLYN. DCA License Number 2050102-DCA is currently Inactive (expiry date 03/31/2018). Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 0, 5 foot stands: 4, 5.01 to 10 foot stands: 0

Telephone: 3476736020.

612
HEGEMAN AVE
BROOKLYN
NY
11207

 

NANCY AND FRIENDS DELI GROCERY SUPERMARKET LLC Data

Dca License Number 2050102-DCA
License Type Business
License Expiration Date 03/31/2018
License Status Inactive
License Creation Date 03/27/2017
Industry Stoop Line Stand
Business Name NANCY AND FRIENDS DELI GROCERY SUPERMARKET LLC
Business Name 2
Address Building 612
Address Street Name HEGEMAN AVE
Secondary Address Street Name
Address City BROOKLYN
Address State NY
Address Zip 11207
Contact Phone Number 3476736020
Address Borough Brooklyn
Borough Code 3
Community Board 305
Council District 42
Bin 3097372
Bbl 3043260001
Nta BK82
Census Tract 1104
Detail Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 0, 5 foot stands: 4, 5.01 to 10 foot stands: 0
Longitude -73.88907263968588
Latitude 40.66103297707879
Location (40.66103297707879, -73.88907263968588)
 

Have you worked with NANCY AND FRIENDS DELI GROCERY SUPERMARKET 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 1 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` = '2050102-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` < 309 ORDER BY `Record`.`id` DESC LIMIT 1110
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` >= 308 AND `Record`.`id` != 309 ORDER BY `Record`.`id` ASC LIMIT 2220