SUNNYSIDE [Permits for SUNNYSIDE]

301 - 350 of 443

QUEENS MINIMARKET

Business

Inactive


HIPOINT WIRELESS

Business

Active


SUNNYSIDE CONVENIENCE A INC

Business

Inactive


SUNNYSIDE ESSO SERVICE STATION

Business

Inactive


ATRANI NYC CONTRACTING LLC

Business

Active


SKILLMAN BARBER SHOP 2, INC

Business

Inactive


IZLER, YASIN

Business

Inactive


YOGI CONVENIENCE

Business

Active


ALPHAURAX INCORPORATED

Business

Inactive



GMJS PHARMACY, INC.

Business

Inactive


NUBE DE JESUS GROCERY #2

Business

Inactive


CLARET'S WINE BAR

Business

Active


KENNY CAPITAL IMPROVEMENT INC.

Business

Inactive


THE ALCOVE RESTAURANT

Business

Active


7-ELEVEN STORE #38309

Business

Inactive


ALAM & BROTHERS INC.

Business

Active



MC NALLY, JOHN

Individual

Active


S.M. CONSTRUCTION COMPANY

Business

Active


.KANGSUH INTERIOR DESIGN

Business

Active


GREEN ELEVATIONS INC

Business

Inactive


NUBE DE JESUS GROCERY

Business

Active


TOP N' Q CLEANERS INC

Business

Active


7 Eleven Store #35495A

Business

Inactive



KANE CONTRACTING

Business

Active


ESPERANZA LAUNDROMAT, INC.

Business

Active


WASH CYCLE

Business

Inactive


KENWOOD COMMERCE, INC.

Business

Inactive



AQUACLEAR, INC.

Business

Inactive


THE VEER NY ENTERPRISE, INC

Business

Active



BELLE D'EPOQUE VINTAGE INC.

Business

Inactive



L & Z LAUNDRY

Business

Active


THAT'S INCREDIBLE

Business

Inactive


OLD CASTLE FRESH FARM CORP

Business

Active


THE DAILY NEEDS CORP.

Business

Active


SKILLMAN MINI MARKET INC

Business

Active


QUEENS MINI MARKET

Business

Inactive


ZIBBER CONSTRUCTION CORP.

Business

Active


RADIOSHACK STORE #2616

Business

Inactive


BLISS DELI & GROCERY CORP

Business

Active


SUNNYSIDE TIRES CORP

Business

Inactive


ADAM'S THRIFT SHOP, INC.

Business

Active


T-MOBILE

Business

Active


GAMESTOP STORE #6443

Business

Active


DENNEHY, MARTIN

Individual

Active


(default) 2 queries took 631 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 300, 505050280
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)11351