KENSINGTON [Permits for KENSINGTON]

1 - 6 of 6

KENSINGTON CONSTRUCTION INC

Business

Inactive


TOP RECREATION INC

Business

Active


RICHMOND HILL HALL CORP

Business

Active


KENSINGTON ENTERPRISES LLC

Business

Active


WRIT LEGAL, LLC

Business

Inactive


KENSINGTON DELI CORP

Business

Active


(default) 1 query took 221 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 ( '(+KENSINGTON)' IN BOOLEAN MODE) LIMIT 5066221