Secondhand Dealer - Auto [Permits for Secondhand Dealer - Auto]

251 - 300 of 2271

JD AUTO GLASS

Business

Active


NASCAR AUTO BODY, INC.

Business

Active


CASEY TRANSPORT CORPORATION

Business

Inactive


ANTHONY'S AUTO WRECKERS

Business

Active


AMIK AUTO SALE, INC.

Business

Inactive


EZ CHOICE AUTO COLLISION CORP.

Business

Inactive


EZ MOTO INC

Business

Active


BRAVO AUTOMOTIVE CLUB INC.

Business

Active


ANTIA AUTO SALES INC.

Business

Active


BH AUTO GROUP INC

Business

Active


CASTOR AUTO SALES INC.

Business

Inactive


MAK MINT USED CARS

Business

Inactive




DUKES AUTO

Business

Active


KOEPPEL NISSAN, INC.

Business

Active


MBJ MOTORS INC.

Business

Active


RAJA AUTO SALES INC.

Business

Active


ULTRA AUTO ENTERPRISE INC.

Business

Active


FIRST CLASS COLLISION CENTER

Business

Inactive


J.C.'S AUTO SALES, INC.

Business

Inactive


R&D AUTO REPAIR INC.

Business

Inactive


S&S AUTO REPAIR INC

Business

Active



LAST CHANCE AUTO SALES, CORP.

Business

Inactive


BEST DEAL AUTO MALL CORP.

Business

Inactive


SALERNO SERVICE STATION INC

Business

Active


F & H AUTO REPAIR

Business

Active


LUXURY OF QUEENS, INC.

Business

Active


AMCOR AUTOMOTIVE INC.

Business

Inactive


CERTIFIED CARS DIRECT, LTD.

Business

Inactive



BRONX JUNK CAR DEPOT LLC

Business

Active


MERRICK USED CARS CORP

Business

Active





L&J AUTO SERVICE INC

Business

Active


HI CLASS AUTO SALES INC.

Business

Active


JG & TONY AUTO BODY REPAIR INC

Business

Inactive




ANGEL TECH AUTO REPAIR CORP

Business

Active


ROYAL AUTO GLASS INC

Business

Active


TAXI AUTO MECHANIC CORP

Business

Inactive


VIP AUTO BODY, INC

Business

Active


DJ AUTO SALES

Business

Active


PAWAR BROS CORP.

Business

Inactive


SAM AUTO SERVICES INC

Business

Active


T-JAI MURPHY

Business

Inactive


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