SUNNYSIDE [Permits for SUNNYSIDE]

51 - 100 of 443

QUINONES, KAREN C

Individual

Active


SIMON, HARVEY L.

Individual

Active


SENECA CRYSTAL CLEANERS

Business

Inactive


VALIEV, SAIDKUDDUS

Individual

Inactive


KALLIOPE'S SUNNY SUDS, LLC

Business

Inactive


HONG GUANG LAUNDROMAT, INC.

Business

Inactive


BAND'S CLEANERS

Business

Inactive


CHOIL WHITE EXPRESS, INC.

Business

Inactive


MARINESCU, JULIANA

Individual

Inactive


VONRITTERN, HANS G.

Individual

Active


EZDAY INC.

Business

Active


E Z PAWN CORP.

Business

Active


SHLOK CORPORATION

Business

Active


SARSHIL TOBACCO SHOP, INC.

Business

Active


RODDEN, FRANK

Individual

Active



TAS, HUSEYIN

Individual

Inactive


CHACA, WILLIAM

Individual

Active


KHUSEYNZODA, BAKHTIYORI

Individual

Inactive


POPA, ADRIAN

Individual

Active


ATES, TOLGAHAN

Individual

Inactive


SENECA CRYSTAL CLEANERS TWO

Business

Active


DEE, DULCIE

Individual

Active


MCEVOY, FRANCIS

Individual

Active


RODRIGUEZ, MARINA

Individual

Active


TELLEZ, MARIA O

Individual

Active


FARNIAN, POURIA

Individual

Inactive


YOGI CONVENIENCE

Business

Active


SMOKE SHOP

Business

Active


LOZANO, SEBASTIAN

Individual

Active


CORMAX CORPORATION

Business

Inactive


HP 42ND FRUIT STORE INC

Business

Active


THE CASE WORLD

Business

Active


RITE AID STORE #3962

Business

Active


RIKO

Business

Active


YOLSAL, EMIRCAN

Individual

Inactive


All In One Express Grocery

Business

Active


J C TOWING

Business

Inactive


KOCAR, CEM

Individual

Active


KOCH, ABRAHAM

Individual

Active



KOCAR, CEM

Individual

Active


KAYA, AYKUT

Individual

Inactive


VOINESCU, GEORGETA

Individual

Active


KOVACS, PAL ZOLTAN

Individual

Active


RITE AID STORE #4858

Business

Active


SPEEDWAY #07817

Business

Active


TASDEMIR, VEYSEL

Individual

Inactive


YAZI, EMRE

Individual

Inactive


WALKER, JOHN J

Individual

Inactive


(default) 2 queries took 314 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 ( '(+SUNNYSIDE)' IN BOOLEAN MODE) LIMIT 50, 50505044
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SUNNYSIDE)' IN BOOLEAN MODE)11270