EAST ELMHURST [Permits for EAST ELMHURST]

301 - 350 of 609

BAZOPOULOU, ANASTASIA

Individual

Active


ZE Contracting Inc.

Business

Active


7 OCEAN GROUP INC.

Business

Inactive



LATIN CENTURY CORP

Business

Active


ANJALI DELI GROCERY CORP

Business

Inactive


Z.M BEST CONSTRUCTION INC.

Business

Active


BEST BUY STORES, L.P.

Business

Active


JOYTI CONSTRUCTION, CORP.

Business

Active


J & M LAUNDROMAT

Business

Active


UNIQUE

Business

Active


S.M. CONSTRUCTION CO., INC.

Business

Active


RICOCHET CONSTRUCTION CORP.

Business

Inactive


93RD DELI CORP

Business

Inactive


GOLD CROWN CONSTRUCTION CORP.

Business

Inactive


75ST SUPER BAZAAR

Business

Active


4 J'S HOME REPAIR CORP.

Business

Active


JACINO CONSTRUCTION INC.

Business

Active



Globe Constructions

Business

Active



DPC CONSTRUCTION CORP.

Business

Inactive


BENJAMIN CLEANER

Business

Active


KLEM CLEANERS

Business

Inactive


SWALLOW CONSTRUCTION INC.

Business

Active


EURO GROUP DESIGN CORP

Business

Active


KRISHNA CONTRACTING INC.

Business

Active



IMPULSE CORPORATION

Business

Active


WOOD FLOORING GROUP

Business

Inactive


AMAZONAS PAINTING CORP.

Business

Active



BARRAGAN, SERGIO

Business

Inactive


RUMIA CONTRACTING CORP

Business

Active


SAFRA CONSTRUCTOR INC

Business

Inactive


EL CASIQUE TIRE SHOP

Business

Active


BILGA CONSTRUCTION COMPANY

Business

Inactive




ESTIA CONSTRUCTION INC.

Business

Active


TASU CONSTRUCTION INC.

Business

Inactive


A&M ACCUSERVICE, INC

Business

Active


WALDBAUM'S STORE #641

Business

Inactive



TRICON RESTORATION INC

Business

Inactive


CFS 2907 LGA LLC

Business

Active


FASTER CONSTRUCTION NY CORP

Business

Active



-ELEVEN STORE (32127B)

Business

Active


GARDEN BAY CLEANER 1 INC

Business

Active


(default) 2 queries took 386 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 ( '(+EAST +ELMHURST)' IN BOOLEAN MODE) LIMIT 300, 505050158
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+EAST +ELMHURST)' IN BOOLEAN MODE)11228