OLD GREENWICH [Permits for OLD GREENWICH]

51 - 70 of 70



NEW RECTOR CLEANERS

Business

Inactive


GREENWICH VILLAGE FARM INC.

Business

Active


GREENWICH AVE CLEANER

Business

Inactive


33 GREENWICH

Business

Active


GREENWICH AVE CLEANERS

Business

Active


THE HARRISON

Business

Inactive



AMERICAN CUT

Business

Inactive


GREENWICH STREET TAVERN

Business

Active


GREENWICH BBQ LLC

Business

Active



GREENWICH STREET GARAGE LLC

Business

Active


WEST BAY ACQUISITIONS, LLC

Business

Inactive


GREENWICH VILLAGE BISTRO

Business

Inactive



GREENWICH NEWS INC

Business

Active



GREENWICH STEAK HOUSE FG

Business

Active


(default) 2 queries took 687 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 ( '(+OLD +GREENWICH)' IN BOOLEAN MODE) LIMIT 50, 502020387
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+OLD +GREENWICH)' IN BOOLEAN MODE)11300