FOREST HILLS [Permits for FOREST HILLS]

501 - 550 of 728

ALL BEST TRADING, INC.

Business

Active


SMILE AUSTIN CLEANERS

Business

Active



AT&T MOBILITY

Business

Active


CATHY'S CLEANERS OF NY INC.

Business

Inactive


ROYAL REHAB INC

Business

Active




AMBRO OPERATING CORPORATION

Business

Active


STONE DELI INC

Business

Active


7-ELEVEN STORE 21950E

Business

Active


NEW Q'S LAUNDROMAT

Business

Active


Sprint

Business

Inactive




NELLIES JEWELRY CORP.

Business

Inactive


FOREST HILLS CLEANER

Business

Active


JJF COMMUNICATION INC

Business

Inactive



DIA VERONICA CORP.

Business

Inactive


JAY NEWSSTAND

Business

Active



PATEL, JAYENDRA

Business

Active



CELL NATION OF SHAOLIN LLC

Business

Active


SPEED CLEANERS

Business

Active


AMERICAN CONGLOMERATE

Business

Active


MAXCO CONTRACTING INC.

Business

Active





LULU LAUNDRY

Business

Active


kobax corp

Business

Active


PATEL, JAYENDRA

Business

Active


CONTINENTAL LUNCHEONETTE

Business

Active


7-ELEVEN STORE #33975A

Business

Active



BENJAMIN CLEANERS LLC

Business

Active


T-MOBILE #8154

Business

Inactive


AXONAL DESIGN INC.

Business

Active


kwick stop

Business

Inactive


WE FIX PHONES NY INC

Business

Active


FOREST HILLS CLEANER

Business

Active


LEITE, JOANA

Individual

Active




Q & L FAITH LAUNDROMAT INC.

Business

Active


RODRIGUEZ, MARCOS A

Business

Inactive


DIXON GROUP LLC

Business

Inactive



(default) 2 queries took 403 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 ( '(+FOREST +HILLS)' IN BOOLEAN MODE) LIMIT 500, 505050173
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+FOREST +HILLS)' IN BOOLEAN MODE)11230