COLLEGE POINT [Permits for COLLEGE POINT]

201 - 250 of 404

J.A SUDS LAUNDROMAT

Business

Active


I P C S CORP

Business

Inactive


NEW CITY LAUNDROMAT INC.

Business

Inactive


UNIQUE WALL SOLUTIONS INC

Business

Active


ZITAN BILT INC.

Business

Active


MODAZ CONSTRUCTION CORP

Business

Inactive




RONALD CO. LLC

Business

Active


HD HVAC OF NY, INC.

Business

Active


ADAM'S FRENCH CLEANER, INC.

Business

Inactive



JRS CONSTRUCTION MANAGEMENT

Business

Active


DOLLAR EXPRESS

Business

Inactive


MR.GRILL CORP.

Business

Inactive


REKONSTRUCT ESZ CORP.

Business

Inactive



GAMESTOP, INC.

Business

Inactive



EZ CLEAN LAUNDROMAT

Business

Inactive


BEST ONE CLEANERS INC.

Business

Inactive


INSTYLE HOME RENOVATIONS LLC

Business

Inactive


GOLDEN AUTO BODY, INC.

Business

Active


SWEET HOME RENOVATION INC.

Business

Inactive



4-SUDS LAUNDRY LLC

Business

Active



GANCO CONSTRUCTION CORP.

Business

Inactive


PACIFIC SOLAR LLC

Business

Inactive




EXPRESS MOBILE REPAIRS

Business

Active


FERRA ASSOCIATES, INC.

Business

Active





J & N HOME IMPROVEMENT CORP

Business

Active


BYZAN CONSTRUCTION INC.

Business

Active


CITY STORE GATES MFG. CORP.

Business

Inactive



HAN'S LAUNDROMAT

Business

Inactive




LATIN WIRELESS II

Business

Active


THE FORGER OF N.Y. CORP.

Business

Active


15TH DELI PLUS CORP

Business

Inactive


7-ELEVEN STORE 27760C

Business

Active


UNIGROW, INC

Business

Active


Lunna Designs

Business

Active


Dollar Express

Business

Active


(default) 2 queries took 1319 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 ( '(+COLLEGE +POINT)' IN BOOLEAN MODE) LIMIT 200, 505050440
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+COLLEGE +POINT)' IN BOOLEAN MODE)11879