Stoop Line Stand [Permits for Stoop Line Stand]

551 - 600 of 3412

MEME STORE

Business

Inactive


269 E. 204TH STREET CORP.

Business

Inactive


FRESH FROM THE FARM

Business

Inactive


SING AND SING DELI, INC.

Business

Inactive


ALDO'S DELI & BAGELS CORP

Business

Inactive


POTTED PLANTS, INC.

Business

Inactive


EL CONUCO FAMILIAR CORP

Business

Inactive


TEPEOJUMA DELI GROCERY

Business

Inactive


SHAN FU STORE

Business

Inactive


GREEN 2 GREEN CORP.

Business

Active


GEORGIA KIZIKI

Business

Inactive


R&V DELI & GROCERY INC

Business

Inactive


Q S STATION LLC

Business

Inactive


CUCINA LIBERTA

Business

Inactive


SEVENDAYS DELI & GROCERY

Business

Inactive


EL JARDIN DELI & GROCERY INC.

Business

Inactive


RIVINGTON'S ORCHARD LLC

Business

Inactive


2258 MI PUEBLO GROCERY INC.

Business

Inactive


NOVELTY & GROCERY HALAL MEAT

Business

Inactive



FIRST STOP GROCERY 1 INC

Business

Inactive


HE XING GROCERY INC

Business

Active



31-18 BROADWAY CORP.

Business

Active


CHUCKY FRESH MARKET CORP

Business

Active


GREEN & RED PRODUCE CORP.

Business

Active


COUNTRY BUTCHER CORP.

Business

Active


Clearview Bridge Inc

Business

Inactive


SPICES & GROCERY INC

Business

Active


KEY FOOD

Business

Inactive




HAPPY FRUIT MARKET, INC.

Business

Active


SUPREME CHICKEN MARKET INC.

Business

Active


SAZON NUNEZ CORP

Business

Active




GREEN & RED PRODUCE CORP.

Business

Active


SNJ NY INC

Business

Active


EL CONUCO ACEVEDO CORP

Business

Active


MIRBURGER INC

Business

Active


FREDDY'S FOOD MARKET

Business

Active



90-01 JARABACOA FOOD CORP.

Business

Active



C-TOWN SUPERMARKET

Business

Active


FLOWERS BY RENIA AND GIFTS

Business

Active


ROSS STREET GROCERY INC.

Business

Active


TOP CITY GOURMET & FRUITS

Business

Active


PORTOKALI GOURMET CORP.

Business

Active


(default) 2 queries took 271 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 550, 50505011
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)11260