Stoop Line Stand [Permits for Stoop Line Stand]

1 - 50 of 3412


ANGELS FLOWER SHOP

Business

Inactive


1623 ST NICHOLAS AVE CORP

Business

Inactive


YASMIN GROCERY CORP

Business

Inactive




JS FRUIT & VEGETABLE CORP.

Business

Inactive


OLGA'S UNISEX

Business

Inactive



M&A Convenience Store

Business

Inactive



MINI BAZAR

Business

Inactive


DITMARS NATURAL CORP

Business

Inactive



HANIF, MOHAMMAD

Business

Inactive


581 A & M FOOD CORPORATION

Business

Inactive


NEW JASON DISCOUNT INC

Business

Inactive


SAGAL FOOD

Business

Inactive


SHRI HARI GROCERY INC.

Business

Inactive


HACHOI CORPORATION

Business

Inactive


FU HAO GIFT SHOP INC.

Business

Inactive


JJ&C SUPERMARKET CORP.

Business

Inactive



MYRTLE AVE SUPER MARKET INC

Business

Inactive


GOOD FOOD FOR LESS, LLC

Business

Inactive


TAYBA HALAL MEAT & GROCERY INC

Business

Inactive


CALIFORNIA DELI GROC, INC.

Business

Inactive



CARIBBEAN GARDEN INC

Business

Inactive


9TH AVE. DELI & GROCERY, INC.

Business

Inactive


785 Grand Food Corp.

Business

Inactive


M & M Natural Fruits

Business

Inactive



SPROUT MARKET

Business

Inactive


K & K DELI & GROCERY INC.

Business

Inactive


MAYAN CONVENIENCE CORP.

Business

Inactive


METRO SATELLITE TV CORP

Business

Inactive


MARIO GOURMET DELI

Business

Active




NEW AGE MARKETS

Business

Inactive


EIGHT JANE FOOD INC.

Business

Inactive


LEUDY DELI GROCERY CORP

Business

Inactive


Lulu Deli Grocery

Business

Inactive


DILLY DELI

Business

Inactive


S.K. DRAGON SUPERMARKET INC

Business

Inactive


JEROME DELI PLAZA CORP.

Business

Inactive


OMALE NEW YORK GROCERY CORP.

Business

Inactive


Tao's Market

Business

Inactive


MAT'S 99 CENTS

Business

Inactive


(default) 2 queries took 250 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 MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Stoop +Line +Stand)' IN BOOLEAN MODE) LIMIT 5050502
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Stoop +Line +Stand)' IN BOOLEAN MODE)11248