CORNWALL ON HUD [Permits for CORNWALL ON HUD]

1 - 11 of 11

AYALA, WILLIAM

Individual

Active


FDL CONTRACTING GROUP, INC.

Business

Active


LEE, MI SUN

Individual

Inactive


MAY SUN CONSTRUCTION LLC

Business

Active


DJURASEVIC, FRAN

Individual

Active


O'CONNOR, MICHAEL

Individual

Active


NICAJ, GJOKA

Individual

Active



GRANT, JOANNE C

Individual

Active


SAINZ-XATZIS, NICHOLAS

Individual

Active


Pureform Design/Build, LLC

Business

Active


(default) 1 query took 343 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 ( '(+CORNWALL +ON +HUD)' IN BOOLEAN MODE) LIMIT 501111343