Stoop Line Stand [Permits for Stoop Line Stand]

501 - 550 of 3412

DAS GROCERY INC

Business

Inactive


TRADE FAIR

Business

Inactive


7 PARK AVENUE FOOD INC.

Business

Inactive


PENN MARKETPLACE, INC.

Business

Inactive


JED MARKET HEAVEN CORP.

Business

Inactive


48TH STREET GROCERY CORP

Business

Inactive



PAWAN HOLDINGS, INC

Business

Inactive


MIRIAMS FLOWERS LLC

Business

Inactive


G.V. TRADING, INC.

Business

Inactive


AUROURE FLORIST INC.

Business

Inactive


GAGRA

Business

Inactive


JIRETH GROCERY CORP

Business

Inactive


CINCO HERMANOS INC.

Business

Inactive


WILSON FOOD MARKET CORP

Business

Inactive


PARADISE FRUIT MARKET

Business

Inactive



7TH ST VILLAGE FARM INC.

Business

Inactive


URBAN MARKET

Business

Inactive


HUDSON FLOWER SHOP

Business

Inactive


QINGDAO RESTAURANT INC.

Business

Inactive


Brother 4 Pancake Inc

Business

Inactive


NUEVA ERA FLOWERS

Business

Inactive


GUO QING ZHANG

Business

Inactive


#1 MINI MARKET

Business

Inactive


GOURMET GUILD LLC

Business

Inactive


atlas meat market

Business

Inactive


ALLOS SUPERETTE

Business

Inactive


RUMALI BAZAR INC

Business

Inactive


LUCKY ZHANG'S FAMILY II CORP.

Business

Inactive


BK GROCERY DELI

Business

Inactive


EAST RIVER DELI

Business

Inactive


4011 DELI & GROCERY, INC.

Business

Inactive



NATURAL HIGH POINT MARKET INC

Business

Inactive


TAQUERIA EL BUEN GUSTO CORP

Business

Inactive


TIMES SQUARE EATERY 48 CORP.

Business

Inactive


NY GREENPOINT FARM INC

Business

Inactive


14TH ST. FOOD MARKET, INC.

Business

Inactive



DESSYN BAKERY CORP.

Business

Inactive


LONG RIVER TRADING INC.

Business

Inactive


M & A CONVIENIENCE STORE

Business

Inactive


H & Y SUPER 99 INC.

Business

Inactive


17 FOOD MARKET INC

Business

Inactive


CANDY LAND LOS MEZAS INC

Business

Inactive


SEA TOWN INWOOD MARQUETA LLC

Business

Inactive


JUANITO'S GROCERY CORP.

Business

Inactive


CAPELLAN DELI GROCERY CORP.

Business

Inactive


SABOR DELI & FOOD INC

Business

Inactive


(default) 2 queries took 237 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 500, 5050508
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)11229