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

101 - 150 of 8313

STOP N PAWN INC

Business

Active


PAWNIT NOW CORP.

Business

Active


T-Mobile

Business

Active


J & SONS AUTO REPAIR INC.

Business

Active




PAWNIT 4 NOW, INC.

Business

Active


DIAMOND BUYERS OF NEW YORK

Business

Active


T-Mobile

Business

Active


T-Mobile

Business

Active


STILL A MAC, INC

Business

Inactive


EL CIRUJANO FLAT FIX CORP

Business

Inactive


ROMANOV JEWELERS LLC

Business

Active


T-Mobile

Business

Active


T-Mobile

Business

Active


MOBILE WIRELESS CORP

Business

Active


PHOENIX ASIAN ART INC.

Business

Inactive


ROBLES GOLD CORP.

Business

Active


T-Mobile

Business

Active


BEST BUY STORES, L.P.

Business

Active


AJ PAWNBROKER INC

Business

Active


T-Mobile

Business

Active



AA ACE TRANSMISSION, INC.

Business

Active


CAROUSEL AUTO BODY INC.

Business

Active



New Phone City Inc

Business

Active


NYC JEWELRY BUYERS LLC

Business

Active



TRI-STAR COLLISION CORP

Business

Active


DAMAS GATE JEWELRY INC.

Business

Active



MR. TIRE SHOP

Business

Active


ONETEL STORE INC.

Business

Inactive


JEWELRY BY AKBASH, INC.

Business

Inactive



JUAN MUFFLERS INC

Business

Inactive


T-Mobile

Business

Active



S JEWELRY CORP

Business

Active


WD PLUS INC

Business

Active


ARBOR VITAE VINTAGE

Business

Active


T. & P. AUTO BODY REPAIRS INC

Business

Inactive


WD PLUS INC

Business

Inactive


ONETEL STORE INC.

Business

Inactive


ONETEL STORE INC.

Business

Inactive




NEW HI TECH CORP

Business

Active


DAVAL JEWELRY CORP

Business

Active


(default) 2 queries took 925 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 100, 505050109
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)11816