Stoop Line Stand [Permits for Stoop Line Stand]

51 - 100 of 3412

GOLDEN FLOWERS INC

Business

Inactive


DJ GROCERY DELI NY INC.

Business

Inactive


COMPARE

Business

Inactive


HAAT BAZAAR

Business

Inactive


R & C FRUIT & VEGETABLE II INC

Business

Inactive


ELIOT CONVENIENCE INC

Business

Inactive


PAO FISH & VEGETABLES CORP

Business

Inactive


RUBENS GLATT MART INC.

Business

Inactive


SUPER DAIRY MILL

Business

Inactive



U FARM LAND

Business

Inactive


RUMALI BAZAR INC

Business

Inactive


ELIZABETH FARM

Business

Inactive


FOOD TRAIN INC.

Business

Inactive


Ahmed Supermarket

Business

Inactive


SALOMON SUPERMARKET

Business

Inactive


8TH AVENUE DELI & GROCERY INC

Business

Inactive


SERAFINA MEAT PACKING

Business

Inactive


LUCKY ZHANG'S FAMILY II CORP.

Business

Inactive


HAVEMEYER DELI STOP ONE. INC

Business

Inactive



TITA MINI MARKET CORP.

Business

Inactive


CHAO HUI GROCERY STORE

Business

Inactive


NATI FOOD CORP.

Business

Inactive


KACHABAZAR

Business

Inactive


ASIAN GROCERY INC.

Business

Inactive


BX-MARKETITA CORP.

Business

Inactive


LEAH FASHIONS & GROCERY, INC.

Business

Inactive



LOHO GOURMET DELI INC

Business

Inactive



GREENBERG, NOEL

Business

Inactive


BLEECKER FINEST CORP.

Business

Inactive


ASSOCIATED SUPERMARKET

Business

Inactive


XIN XIN SHOP

Business

Inactive


AROMA FOOD INC.

Business

Inactive


S & R STORE LTD.

Business

Inactive


SILVER MOON BAKERY INC

Business

Inactive


MOTIN & SONS ASSOCIATES, INC.

Business

Inactive


JACKSON HEIGHTS FLOWERS INC

Business

Inactive


233 CASTILLO MEAT CORP.

Business

Inactive


YAMIN FOOD MART INC

Business

Inactive


GOODLUCK SUPERMARKET

Business

Inactive


M & F FOOD CORP

Business

Inactive


BNR Food Corp.

Business

Inactive



SOUTHERN BLVD MEAT MARKET CORP

Business

Inactive


PAOLA'S FLOWERS & GARDEN CORP

Business

Inactive


CNL FRUIT CORP.

Business

Inactive



(default) 2 queries took 233 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 50, 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)11231