Stoop Line Stand [Permits for Stoop Line Stand]

451 - 500 of 3412

SHANGERILA RESTAURANT INC

Business

Inactive


K & J SUPERMARKET, INC.

Business

Inactive


ORTIZ, JOHNNY

Business

Inactive


VIA QUADRONNO

Business

Inactive


MI BARRIO MEAT MARKET INC.

Business

Inactive


RAINFOREST GROUP, LLC

Business

Inactive



KEY FOOD

Business

Inactive


R.Y. BUBBLE TEA CORP.

Business

Inactive



TRIANGLE DELI CORP

Business

Inactive


LA OTRA GROCERY CORP

Business

Inactive


NATURAL GREEN MARKET

Business

Inactive


MARIAH GROCERY

Business

Inactive


EL JALAPENO FOOD MARKET INC

Business

Inactive


YONG LONG SUPERMARKET, INC.

Business

Inactive



LA HERRADURA GROCERY LLC

Business

Inactive


37TH AVE. GROCERY DELI, INC.

Business

Inactive


LA FINCA FRUITS & VEGETABLES

Business

Inactive


WATKINS HEALTH FOODS

Business

Inactive


RAINBOW CONVENIENT SHOP INC

Business

Inactive


GREEN DOT MARKETPLACE CORP.

Business

Inactive


POLLOS Y MAS CORP

Business

Inactive



GIFTS & ELECTRONICS SHOP

Business

Inactive


AROMA A MEXICO INC

Business

Inactive


CORTELYOU BAZAAR INC

Business

Inactive


AF RIVERDALE MEAT MARKET CORP

Business

Inactive


WILLIAMSBURG BOUQUETS

Business

Inactive


CHAN'S LAUNDROMAT

Business

Inactive



ANYUTA'S FLOWERS INC.

Business

Inactive


CYJ ENTREPRENEUR

Business

Inactive


G & A DESIGNS CORP.

Business

Inactive


T.D. CARIBBEAN SUNSHINE CORP.

Business

Inactive


MENDOZA FLOWERS AND GIFT SHOP

Business

Inactive


SUBZI MANDI

Business

Inactive


GENUINE SUPRETTE

Business

Inactive


COMPARE FOODS

Business

Inactive



GUIAS Y ANGELES CORP.

Business

Inactive


GOLDEN FOOD MARKET, INC.

Business

Inactive



45TH STREET SUPERMARKET INC.

Business

Inactive


L & J GROCERY & DELI INC

Business

Inactive


PLANT PLAN GARDENING INC

Business

Inactive


LUPITA LAUNDROMAT INC

Business

Inactive


DUDDY'S CORNER INC

Business

Inactive


SPRING DELI & TOBACCO INC

Business

Inactive


(default) 2 queries took 247 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 450, 50505015
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)11232