ELK RIVER [Permits for ELK RIVER]

1 - 50 of 177

SMITH, PATRICK

Individual

Inactive


GIBRALTAR ORTHOTICS, INC.

Business

Active


REBOSIO, CARLO

Individual

Active



ZURLA, MARC

Individual

Active


MIKHLI, EDWARD

Individual

Inactive


EAST RIVER DELI

Business

Inactive


LONG RIVER TRADING INC.

Business

Inactive


WILLIAMS, SCOTT

Individual

Active


Tyer, Vincent

Individual

Active


EAST RIVER AUTO CARE INC.

Business

Active


BLUEHILL CONSTRUCTION INC

Business

Active


FRIED, DAVID SCOTT

Individual

Active


VALVA, ROBERT

Individual

Active


EAST RIVER CLEANERS

Business

Inactive


WEBER, CHRISTOPHER TODD

Individual

Active


Steel River Systems LLC

Business

Active


PELLUMBI, ILIR

Individual

Active


RIVER BANK LAUNDROMAT, INC.

Business

Inactive


EAST RIVER DAVID CLEANERS INC.

Business

Inactive


HARE, JESSE H

Individual

Inactive



GOLD RIVER LAUNDROMAT

Business

Inactive


HVAC PROS LLC

Business

Active


WARNER, JOHN F

Individual

Active


YANGTZE RIVER LAUNDROMAT, INC.

Business

Inactive


B & M Carpet llc

Business

Active


DUGGAN, ANDREW J

Individual

Active


RANKIN, WILLIAM A

Individual

Active


JP RECOVERY SERVICES, INC.

Business

Active


LARKIN, EILEEN M.

Individual

Active


BAKER, JAMES L

Individual

Inactive


HAND, STEPHEN K

Individual

Active




MCDOWELL, GREGORY

Individual

Inactive


Align Renovation, Inc.

Business

Active


OTT, WILLIAM

Individual

Active


HALDER, GARY R

Individual

Inactive


Judson, Paul

Individual

Active



FLANAGAN, GERALD M

Individual

Active


METJAHIC, JASMIN

Individual

Active


TISZOLD, TAMAS

Individual

Active


ANDICOECHEA, JOHN

Individual

Active


KILLEAVY BUILDERS CORP.

Business

Active


CAMPBELL, EUGENE

Individual

Active


HOLLAND, RUSS

Individual

Inactive


DTA CONTRACTING, INC.

Business

Inactive


SHIELDS, PHILIP

Individual

Inactive


(default) 2 queries took 249 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 ( '(+ELK +RIVER)' IN BOOLEAN MODE) LIMIT 50505044
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+ELK +RIVER)' IN BOOLEAN MODE)11205