WILLIAMSBURG [Permits for WILLIAMSBURG]

1 - 25 of 25

WILLIAMSBURG BOUQUETS

Business

Inactive


MUSIC HALL OF WILLIAMSBURG LLC

Business

Inactive





JAMESON, LEIGH

Individual

Active


WILLIAMSBURG WIRELESS, INC.

Business

Active


Donnelly, Edward

Individual

Active



WILLIAMSBURG WIRELESS, INC.

Business

Active


WILLIAMSBURG FINEST

Business

Inactive



WILLIAMSBURG SMOKE SHOP CORP

Business

Inactive









WILLIAMSBURG WIRELESS, INC.

Business

Active


OLD WILLIAMSBURG FOOD, INC.

Business

Inactive


MP Taverna

Business

Inactive




(default) 1 query took 278 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 ( '(+WILLIAMSBURG)' IN BOOLEAN MODE) LIMIT 502525278