YORKTOWN HTS [Permits for YORKTOWN HTS]

51 - 66 of 66

DODAJ, ALVARO

Individual

Active


BIEBEL, GEORGE

Individual

Active


Blair, Juliet

Individual

Active


HANLON, MICHAEL H.

Individual

Active


CORBETT, MARTIN

Individual

Active



GJERGJI, PAULIN

Individual

Active


KCSA Properties LLC

Business

Active


NAGANI, MUHAMMAD H

Individual

Active


EDARD CONSTRUCTION CORP.

Business

Active



ANTHONY DEVITO LLC

Business

Inactive


FUNTIME AMUSEMENTS, INC.

Business

Inactive


FUNTIME AMUSEMENTS, INC.

Business

Inactive


FUNTIME AMUSEMENTS, INC.

Business

Inactive



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