SUNNYSIDE [Permits for SUNNYSIDE]

1 - 50 of 443

MINCHIK, JOSEPH

Individual

Inactive


WEBER, BRUCE

Individual

Inactive


FIRU, VICTOR V

Individual

Inactive


YOGI CONVENIENCE

Business

Inactive


HP 42ND FRUIT STORE INC

Business

Inactive


NEW GREENPOINT FARM LLC

Business

Inactive


SCHMOTZR, MELISSA

Individual

Inactive


SUNNYSIDE NATURAL & FRESH

Business

Inactive


SANCHEZ, MIGUEL A

Individual

Inactive


BOJOVIC, SIMON

Individual

Active


REISS, GIOVANNA

Individual

Inactive


HOFFMAN, WALTER

Individual

Active


KABASHI, SOKOL

Individual

Active


RAINWATER, JOEL

Individual

Inactive


NY GREENPOINT FARM INC

Business

Inactive


RODRIGUEZ, SUSAN

Individual

Active


ISRAEL, COLIN

Individual

Active


SECILMIS, DENIZ

Individual

Active


PAUL, MITAN

Individual

Active


JC 1468 LAUNDROMAT INC.

Business

Inactive


WIN MIN THEIN, INC.

Business

Inactive


EMINOGLU, AHMET

Individual

Inactive


TIAN AN LAUNDROMAT, INC.

Business

Inactive


43RD SUPER LAUNDROMAT

Business

Inactive


ESPERANZA LAUNDROMAT, INC.

Business

Inactive



LIPE, ILIR

Individual

Active



LU, YU JI

Individual

Active


SIDETRACKS RESTAURANT

Business

Inactive



SKILLMAN LAUNDRY CENTER INC

Business

Inactive


DERMODY, JOHN

Individual

Active


VILLELLA CLAUSSEN, OCTAVIO

Individual

Inactive


MCBRIDE, ALBERT M

Individual

Inactive


L & Z LAUNDRY

Business

Inactive


GOLDEN SWAN LAUNDROMAT INC.

Business

Inactive


9 KIT INC.

Business

Inactive


WASHETERIA II CORP.

Business

Inactive


YALCIN, ZEKI

Individual

Inactive



MUHAMMAD, SAFDAR

Individual

Active


O'SHEA, PATRICK

Individual

Inactive


SINGH, RATTAN

Individual

Inactive



SUNNY LAUNDROMAT

Business

Inactive


PORTER, ARCHIE L

Individual

Active


DAI LE KANG LAUNDROMAT, INC.

Business

Inactive


HA SUNNYSIDE LAUNDROMAT INC.

Business

Inactive


LIZ ANGELA INT'L CORP.

Business

Inactive


(default) 2 queries took 378 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 50505032
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)11346