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

201 - 250 of 8313

SPRINT SPECTRUM L.P.

Business

Active



EMERALD PHOENIX ANTIQUES

Business

Inactive


TELIER WIRELESS CORP.

Business

Active


GLITZ

Business

Active


SPRINT SPECTRUM L.P.

Business

Active


CRISTO REY TIRE SHOP INC

Business

Active


I TECH DOC

Business

Active


VINTAGE USA INC

Business

Active


4 TECH MOBILE CORP

Business

Inactive


SPRINT SPECTRUM L.P.

Business

Active


SPRINT SPECTRUM L.P.

Business

Active


S&P WIRELESS INC

Business

Active


SPRINT SPECTRUM L.P.

Business

Active


JD TECH SOLUTIONS INC

Business

Inactive


GLOBAL INNOVATIVE GROUP LLC

Business

Active


4 TECH MOBILE CORP

Business

Inactive


ELITE AUTO BODY INC

Business

Active


LIBERTY AUTO PARTS

Business

Active


4 TECH MOBILE CORP

Business

Active


V2 CELL PHONE STORE INC

Business

Inactive


Sprint

Business

Active


Sprint

Business

Active


G N WIRELESS OF GRAHAM INC

Business

Inactive


SPRINT SPECTRUM L.P.

Business

Active


Sprint

Business

Active


E Z PAWN CORP.

Business

Active


GANSA TIRE SHOP INC

Business

Active


SYLVIA PINES LLC

Business

Active


EXCLUSIVE TIME, INC.

Business

Active


NEW TIRE WORLD CORP

Business

Active


BELLA ANTIQUES INC.

Business

Active


SPRINT SPECTRUM L.P.

Business

Active


SPRINT SPECTRUM L.P.

Business

Inactive


WORLD CLASSIC TIMES INC.

Business

Active



AMERICA RECYCLE, LLC

Business

Active


MORALES TIRE SHOP

Business

Inactive


T-MOBILE

Business

Active



SPRINT SPECTRUM L.P.

Business

Active


ZENYS TIRES & RIMS INC.

Business

Inactive


HOME BOY JEWELRY

Business

Active


LOUIE TOWING INC.

Business

Inactive


TENDA TECH 18 INC

Business

Active



LA PARADA WIRELESS CORP.

Business

Active


ANTIQUES IN UNION INC

Business

Inactive


TECH KARE MOBILE INC

Business

Active


TIKVATRONICS, LTD.

Business

Inactive


(default) 2 queries took 980 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 200, 505050217
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)11763