SUNNYSIDE [Permits for SUNNYSIDE]

351 - 400 of 443

CHOIL WHITE EXPRESS, INC.

Business

Active


TAJ MAHAL GROCERY

Business

Active


KALLIOPE'S SUNNY SUDS, LLC

Business

Active


4125 ELECTRONICS INC

Business

Active


SKILLMAN LAUNDROMAT INC.

Business

Active


ELEGANT NEWS STAND INC

Business

Active


ISMAILOV, MANSURZHON

Business

Inactive



THE DAILY NEEDS CORP.

Business

Inactive


ALL IN ONE EXPRESS GROCERY

Business

Inactive


SUNNYSIDE PAINTING, INC.

Business

Active



ZERVOS, ATHANASIOS

Business

Active


CHOICE FARM INC.

Business

Active


METRO PCS

Business

Active


STR NEWS STAND, INC.

Business

Inactive


DIGITAL TECH CORP.

Business

Active


ECUAMEX TIRES SHOP INC.

Business

Inactive



ASAP EMPLOYMENT INC.

Business

Inactive


SUN DELI GROCERY CORP.

Business

Active



ON POINT MOBILE GREEN POINT

Business

Inactive


JD & R CORP.

Business

Active


JOLLY 100 CORP.

Business

Active


T-Mobile

Business

Inactive


PHOENIX REALTY GROUP, LLC

Business

Active


SUNNY GROCERY YILDIZ CORP.

Business

Active


ABDULLAH KOC

Business

Active


S. DONADIC, INC.

Business

Active


VOINESCU, GEORGETA

Business

Active


RIERA PRODUCTIONS, INC.

Business

Active


VIRAJ MART

Business

Active


KPM GOLD & GEM LLC

Business

Inactive


T-Mobile

Business

Inactive


T-MOBILE NORTHEAST LLC

Business

Active


T-Mobile

Business

Inactive



42ND FRUIT INC.

Business

Inactive


QUICKSILVER INC.

Business

Inactive


CARLE INC

Business

Inactive


NEWPORT AUTO BODY

Business

Inactive


PHANE INC

Business

Inactive


BUSSANI MOBILITY TEAM NYC LLC

Business

Inactive


BUCHAREST RESTAURANT

Business

Inactive


GREENPOINT LAUNDROMAT

Business

Inactive


DESAI CONVENIENCE LLC

Business

Inactive


GOLDEN SWAN LAUNDROMAT INC.

Business

Active


THE LOWERY BAR & KITCHEN

Business

Active


BERMAN, DAVID G

Business

Active


(default) 2 queries took 401 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 350, 505050194
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)11207