Stoop Line Stand [Permits for Stoop Line Stand]

301 - 350 of 3412

Jason's Flowers

Business

Inactive


FULTON FISH MEAT MARKET CORP

Business

Inactive


MANGU PATIO INC.

Business

Inactive


SUA MARKET INC

Business

Inactive


AMBE GROCERY CORP.

Business

Inactive


ENG'S FLORIST, INC.

Business

Inactive


Natural Fresh Market Corp

Business

Inactive


GHANSHYAM CORP.

Business

Inactive


C.H. SUPERMARKET, INC.

Business

Inactive


VEKSLERS

Business

Inactive


SEA TOWN CORONA NY LLC

Business

Inactive


SHOP SMART

Business

Inactive


248 SUN FARM CORP

Business

Inactive


P WEST INDIAN MARKET

Business

Inactive


ALVARADO, MAXIMINA

Business

Inactive


BLASHY DELI GROCERY CORP.

Business

Inactive



2451 BROADWAY MARKET, INC.

Business

Inactive


ROCKAWAY GREENS INC

Business

Inactive


PERLA DORADA DELI GROCERY CORP

Business

Inactive


EMPIRE GROCERY STORE INC.

Business

Inactive


SUNNYSIDE NATURAL & FRESH

Business

Inactive


DELHI HEIGHTS RESTAURANT & BAR

Business

Inactive


BAYSIDE GROCERY & DELI, INC.

Business

Inactive


SANTA CATARINA GROCERY LLC

Business

Inactive


EVERYDAY DELI & GROCERY INC

Business

Inactive


XING HUA CONVENIENCE STORE INC

Business

Inactive


A-MART US, CORP.

Business

Inactive


ROOSEVELT FOOD CORP.

Business

Inactive


Mrs. Green's Natural Market

Business

Inactive


APNA SOHNA BAZAR

Business

Inactive


BRIGANTINA INC

Business

Inactive


LA VAQUITA

Business

Inactive



MAGIC GARDEN FLOWER SHOP

Business

Inactive


FIRST STOP GROCERY

Business

Inactive


HOMETOWN FRESH MARKET INC.

Business

Inactive


CHENG FAR ACCESSORIES

Business

Inactive



FOOD FAIR FARM CORP

Business

Inactive


TRADE FAIR

Business

Inactive


CRYSTALS GARDEN INC

Business

Inactive


Bay Mart Supermarket Inc

Business

Inactive


CASTILLO MINI- MALL

Business

Inactive


SEA TOWN CORONA NY LLC

Business

Inactive


BERRY GOODS INC.

Business

Inactive


LA CASA DE LOS ANTOJITOS INC.

Business

Inactive


THE BEST DELI GROCERY

Business

Inactive


17 FOOD MARKET INC

Business

Inactive


TRINI DELITE

Business

Inactive


(default) 2 queries took 258 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 300, 50505016
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)11242