Secondhand Dealer - General [Permits for Secondhand Dealer - General]

251 - 300 of 8313

SPRINT SPECTRUM L.P.

Business

Active


TOUCH CELL, LLC

Business

Active


LINDEN PAWN BROKERS INC

Business

Inactive



Star Thrift Shop Inc

Business

Inactive


CHRISTIE'S INC

Business

Active


T-Mobile Limited

Business

Active


THRIFTOLOGY LLC

Business

Active


MOBILE CENTER USA LLC

Business

Inactive


RENAISSANCE WATCH CO

Business

Inactive


ecoATM, Inc.

Business

Inactive


T-Mobile

Business

Active



T-MOBILE NORTHEAST LLC

Business

Active


LEE CALICCHIO, LTD.

Business

Active


Auction House 43, Inc.

Business

Inactive



PERMANENT RECORDS INC.

Business

Inactive




Macy's Backstage

Business

Inactive



Antique Raiders Cafe inc

Business

Inactive


ecoATM, Inc.

Business

Inactive


REPAIR DOCTOR INC

Business

Inactive


T-MOBILE NORTHEAST LLC

Business

Active


WikiWoo LLC

Business

Inactive



G.B. SERVICE CENTER CO.

Business

Active


yimena cardoze

Business

Active


MERIK JEWELRY CORP.

Business

Active


Alex Wireless Connection LLC

Business

Inactive


THRIFT FIT INC

Business

Inactive


PAWN RITE BROADWAY, LLC

Business

Active


TRIBRO ELECTRONICS INC

Business

Inactive


Phillips

Business

Active


T-Mobile Limited

Business

Active


SYSTEM LIQUIDATORS, INC.

Business

Active


NY Deal Brokers, Inc.

Business

Inactive


Samantha Cham

Business

Inactive


WIRELESS HOME INC.

Business

Active


tatiana designer resale

Business

Inactive


GENIK, ZEEV

Business

Inactive


ecoATM, Inc.

Business

Inactive


TIPHANYS ELECTRONICS CORP

Business

Active


MALIDANI JEWELRY CORP.

Business

Active


JACKIE MULTISERVICES, INC

Business

Inactive


SASHKA & COMPANY

Business

Active



Dragon Enterprises, Inc

Business

Inactive


(default) 2 queries took 1507 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 ( '(+Secondhand +Dealer +- +General)' IN BOOLEAN MODE) LIMIT 250, 505050435
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Secondhand +Dealer +- +General)' IN BOOLEAN MODE)111072