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

401 - 450 of 2271

ALLIANCE AUTO PARTS, INC.

Business

Active


FAZIO BROTHERS AUTO INC.

Business

Active



UNIVERSAL USED AUTO PARTS INC.

Business

Inactive


ISLAND KIA

Business

Inactive


J & L AUTO CENTER, INC.

Business

Active



RALPHS AUTO CENTER

Business

Active


JOHNNY'S NEW AUTO REPAIR INC.

Business

Inactive


JIMMY'S AUTO SERVICE, CORP.

Business

Active


B & A AUTO SALES, INC.

Business

Active



LAST STOP GARAGE

Business

Active


CROWN AUTO SPOT INC.

Business

Inactive



4 STAR AUTO GLASS

Business

Inactive


PELHAM GARAGE, INC.

Business

Active


D. G. AUTO WRECKERS, INC.

Business

Inactive


MR D'S AUTOMOBILES INC.

Business

Active


CARLOS AUTO SALES, CORP.

Business

Inactive



A & S AUTO DEALER CORP.

Business

Active



RIDGEWOOD AUTO SPRING

Business

Inactive


QUISQUEYA AUTO SONIDO

Business

Active


BLONDI AUTO GLASS

Business

Active


JERUSALEM AUTO SALES INC.

Business

Active


HIGHLINE CARS SHOW CORP

Business

Inactive


NISSAN OF MANHATTAN, INC.

Business

Inactive


ALBERT & M AUTO BODY INC

Business

Active




RIVERDALE MOTORS CORP

Business

Active


OCHUN AUTO REPAIR, CORP.

Business

Active


PITASO AUTO REPAIR, CORP

Business

Inactive


QUEENS FINEST AUTO BODY INC.

Business

Inactive


ROCKAWAY AUTO SALES INC

Business

Active



KING OF QUEENS AUTOMOTIVE, LLC

Business

Inactive


APT. RENOVATIONS INC.

Business

Active


SILVER STAR MOTORS

Business

Active



BOOTS AUTO REPAIR, INC.

Business

Active


S & K FAMILY AUTO CORP.

Business

Inactive


GATEWAY CAR DEALER, INC

Business

Active





CONCORD AUTO COLLISION INC

Business

Inactive



(default) 2 queries took 370 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 400, 505050130
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)11240