NEW HAPPY DELI & GROCERY, INC.

Stoop Line Stand ASTORIA NY

NEW HAPPY DELI & GROCERY, INC. is a registered Business operating as a Stoop Line Stand in ASTORIA. DCA License Number 1362143-DCA is currently Inactive (expiry date 03/31/2018). Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 2, 5 foot stands: 0, 5.01 to 10 foot stands: 0

Telephone: 646-417-4257.

3202
36TH AVE
ASTORIA
NY
11106

 

NEW HAPPY DELI & GROCERY, INC. Data

Dca License Number 1362143-DCA
License Type Business
License Expiration Date 03/31/2018
License Status Inactive
License Creation Date 07/13/2010
Industry Stoop Line Stand
Business Name NEW HAPPY DELI & GROCERY, INC.
Business Name 2
Address Building 3202
Address Street Name 36TH AVE
Secondary Address Street Name
Address City ASTORIA
Address State NY
Address Zip 11106
Contact Phone Number 646-417-4257
Address Borough Queens
Borough Code 4
Community Board 401
Council District 26
Bin 4007942
Bbl 4006010032
Nta QN68
Census Tract 55
Detail Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 2, 5 foot stands: 0, 5.01 to 10 foot stands: 0
Longitude -73.92882803495084
Latitude 40.756143064898325
Location (40.756143064898325, -73.92882803495084)
 

Have you worked with NEW HAPPY DELI & GROCERY, INC. 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` = '1362143-DCA' LIMIT 1110
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` < 1056 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` >= 1055 AND `Record`.`id` != 1056 ORDER BY `Record`.`id` ASC LIMIT 2220