Stoop Line Stand [Permits for Stoop Line Stand]

151 - 200 of 3412

O K PUBLIC MARKET INC

Business

Inactive


YOUR CHOICE DELI GROCERY CORP.

Business

Inactive


CAFE DEL SOL INC.

Business

Inactive


HERALD SQUARE MARKET INC.

Business

Inactive


BRAVO SUPERMARKET

Business

Inactive


WG MEAT MARKET INC

Business

Inactive


UTICA FOOD MARKET, CORP.

Business

Inactive


J.M. MORENO CORP

Business

Inactive


EMN EURO MART

Business

Inactive




ASIAN GROCERY INC.

Business

Inactive


PD MARIO 7 DELI GROCERY INC

Business

Inactive


QUISQUEYA DELI & GROCERY

Business

Inactive


38 FRUIT & VEGETABLE CORP

Business

Inactive


ATLANTIC FISHERMAN INC

Business

Inactive


Moca Fruits and Vegetables

Business

Inactive


ARMEND MEAT MARKET CORP.

Business

Inactive


HONG FUNG BAKERY INC.

Business

Inactive


PLAZA PIAXTLA BAKERY INC.

Business

Inactive


KINGS MEATS

Business

Inactive


PATEL BROTHERS

Business

Inactive


HAIM'S INTERNATIONAL

Business

Inactive


SM GROCERY & VARIETY INC

Business

Inactive


OUR DELI CORP

Business

Inactive



Y&Z DELI CORP.

Business

Inactive


SAGAL FOOD

Business

Inactive



SWEET DREAM NY CORP

Business

Inactive


55B MOTT GALLERY

Business

Inactive


LAS JAROCHITAS RESTAURANT

Business

Inactive


REFRESH FRUITS & DELI CORP.

Business

Inactive


SUN VARIETY SHOP

Business

Inactive


PARK SLOPE BEER INC

Business

Inactive


POBY INC

Business

Inactive


ALI BABA ORGANIC, INC.

Business

Active


SHIV DELI & GROCERY, INC.

Business

Inactive


The Standard, High Line

Business

Inactive


765 SIXTH AVENUE MARKET, INC.

Business

Inactive



MUTUAL DELI & GROCERY CORP

Business

Inactive


29 FRUIT MARKET INC.

Business

Inactive


ARMANDO GROCERY & BAKERY INC.

Business

Inactive


5 STAR GROCERY STORE INC

Business

Inactive


MADISON DELI & GRILL CORP

Business

Active


NEW A & J FARM MARKET, INC.

Business

Inactive


POLITO'S PIZZA

Business

Inactive


AL MUATH GROCERY INC.

Business

Inactive


G & K FLORCHID, CORP.

Business

Inactive


(default) 2 queries took 287 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 150, 5050503
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)11284