HAIM'S INTERNATIONAL M & J SUPERMARKET INC

Stoop Line Stand FLUSHING NY

HAIM'S INTERNATIONAL is a registered Business operating as a Stoop Line Stand in FLUSHING. DCA License Number 2056080-DCA is currently Inactive (expiry date 03/31/2018). Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 1, 5 foot stands: 0, 5.01 to 10 foot stands: 0

Telephone: 7189694226.

7268
MAIN ST
FLUSHING
NY
11367

 

HAIM'S INTERNATIONAL Data

Dca License Number 2056080-DCA
License Type Business
License Expiration Date 03/31/2018
License Status Inactive
License Creation Date 07/21/2017
Industry Stoop Line Stand
Business Name M & J SUPERMARKET INC
Business Name 2 HAIM'S INTERNATIONAL
Address Building 7268
Address Street Name MAIN ST
Secondary Address Street Name
Address City FLUSHING
Address State NY
Address Zip 11367
Contact Phone Number 7189694226
Address Borough Queens
Borough Code 4
Community Board 408
Council District 24
Bin 4143473
Bbl 4066230033
Nta QN37
Census Tract 77902
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.82092309391557
Latitude 40.72491678197427
Location (40.72491678197427, -73.82092309391557)
 

Have you worked with HAIM'S INTERNATIONAL 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` = '2056080-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` < 1265 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` >= 1264 AND `Record`.`id` != 1265 ORDER BY `Record`.`id` ASC LIMIT 2220