QUEENS VLG [Permits for QUEENS VLG]

401 - 450 of 938

ELIM CLEANERS OF QUEENS, INC.

Business

Inactive


WIGGINS, WAYNE

Business

Active


JUST-OZ

Business

Active




Ramirez, Freddy

Individual

Active


ELECTRONICA IN QUEENS, INC.

Business

Inactive


ACE TELEVISION CO., INC.

Business

Inactive


CHOUDHRY MOTORS INC

Business

Active



H.Y.L. LAUNDROMAT, INC.

Business

Inactive


HASAN, MD

Business

Active


T-Mobile Limites

Business

Active


RELIABLE SEAMLESS GUTTERS

Business

Active


DONNELLY MECHANICAL CORP.

Business

Active


HOLLIS 18 LAUNDROMATS LLC

Business

Inactive


CAMELOT CONTRACTORS

Business

Active


DOREN CAR STEREO AND ALARMS

Business

Active


NORTHSTAR KIA

Business

Active


DIDI AUTO REPAIRS, INC.

Business

Inactive


QUEENS VILLAGE SUPERETTE CORP.

Business

Inactive



QUEENS ROCK CORP

Business

Active


RIVOIRA HOME IMPROVEMENT

Business

Inactive



ROBIN, SHISH

Business

Inactive



206 HOLLIS LAUNDROMAT, LLC

Business

Inactive


RICHMOND HILL HALL CORP

Business

Active


SCAROLA CONSTRUCTION SERVICES

Business

Inactive


ELITE WIRELESS GROUP NY LLC

Business

Active



SUPER SPRING GROCERY CORP

Business

Active


DE CONTRACTING OF QUEENS, INC.

Business

Inactive


SAMAR NYC CONSTRUCTION INC

Business

Inactive




AUDOTRONIC OF QUEENS, INC.

Business

Active


NEW GIANT FARM INC.

Business

Active





DEVINE AUDIO COMPANY

Business

Inactive


C & R CONSTRUCTION NY INC.

Business

Active



QUEENS CELLULAR CORP

Business

Active



LUXURY OF QUEENS, INC.

Business

Active


JMADRID DELI CORP

Business

Active



(default) 2 queries took 444 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 ( '(+QUEENS +VLG)' IN BOOLEAN MODE) LIMIT 400, 505050170
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+QUEENS +VLG)' IN BOOLEAN MODE)11274