ELK RIVER [Permits for ELK RIVER]

151 - 177 of 177

Moon River Chattel,Inc.

Business

Inactive


RIVER GAS & WASH CORP.

Business

Inactive


RIVER BARREL INC.

Business

Inactive


TIMMY'S BY THE RIVER

Business

Active



MP RIVER LLC

Business

Active


NOR-BRONX RIVER INC

Business

Active


EAST RIVER 72nd GARAGE LLC

Business

Active


RIVER YORK STRATFORD LLC

Business

Active


CALVIN RIVER DELI

Business

Inactive


NOR-BRONX RIVER INC

Business

Active


NEW RIVERDALE GOURMET DELI

Business

Inactive


LONG RIVER TRADING INC.

Business

Inactive


WINDHAM PROFESSIONALS, INC.

Business

Inactive


HUDSON RIVER PARKING CORP.

Business

Active


BRONX RIVER CW CORP

Business

Active


SMITH, MICHAEL

Individual

Active



FLANAGAN, GERALD

Individual

Active


RIVER YORK BARCLAY LLC

Business

Active


EAST RIVER CLEANERS

Business

Active



GOLD RIVER LAUNDROMAT

Business

Active


RIVER PARK GOURMET CORP

Business

Active


KRM LTD

Business

Inactive


SCHWEIKER, JAMES

Individual

Active


LONG RIVER TRADING INC.

Business

Active


(default) 2 queries took 529 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 150, 502727318
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)11211