SUNNYSIDE [Permits for SUNNYSIDE]

201 - 250 of 443

CASQUINO, MOISES

Individual

Active


HAIN PRADA, CRISTOPHER

Individual

Active


SANCHEZ, MIGUEL A

Individual

Active


SCHWARZ, GABRIELE

Individual

Active


Ernst, Joseph

Individual

Active


DENNEHY, SEAN

Individual

Active


Mellott, Sean

Individual

Active


CARLSEN, DEAN S

Individual

Active



JHILAM INC

Business

Active


H.T.F USA INC

Business

Inactive


SUNNYSIDE FLORIST

Business

Active


JD & R CORP.

Business

Active


KHUSEYNZODA, BAKHTIYORI

Business

Active


QUEENSBORO PARKING CORP.

Business

Inactive


7 Eleven Store #35495B

Business

Active


BAR 43

Business

Inactive


GREENPOINT DRY CLEANERS

Business

Inactive


MP SUNNYSIDE UP LLC

Business

Active


RAFAEL GOURMET DELI

Business

Inactive


E Z PAWN CORP.

Business

Active


KPM GOLD & GEM LLC

Business

Inactive


ORCHID CONSTRUCTION CORP

Business

Active


RadioShack

Business

Active




ECUAMEX TIRE SHOP INC

Business

Active


KENNEY, STEFFEN

Individual

Active




HIGH SKILLED BUILDERS, INC.

Business

Inactive


148 LAUNDRY, INC.

Business

Inactive


RADIOSHACK CORPORATION

Business

Inactive


ADL JEWELRY INC

Business

Active



HANNA, NEHMI

Business

Active


BLISS DELI & GROCERY CORP

Business

Active


E & S COMPUTERS, INC.

Business

Active


SSS DVD VIDEO CORP.

Business

Inactive


BAND'S CLEANERS

Business

Active


SUNNY LAUNDROMAT

Business

Active


SKILLMAN LAUNDRY CENTER INC

Business

Active


ALPHAX TECHNOLOGY INC

Business

Active


JEWLER WATCH MASTER

Business

Inactive


JENNY DRY CLEANERS INC.

Business

Active



M&H WIRELESS II INC.

Business

Active


J. ORTEGA CORP.

Business

Inactive


42ND FRUIT INC.

Business

Inactive


THE DOG & DUCK

Business

Inactive


(default) 2 queries took 324 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 200, 505050115
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)11209