PORT JERVIS [Permits for PORT JERVIS]

1 - 7 of 7

VARCOE, MELISSA

Individual

Active


TIRADO, EVIDIO JR.

Individual

Active


SHAWNKAT CONSTRUCTION LLC

Business

Inactive


TIRADO PAINTING

Business

Active


MORALES, JULIO A.

Individual

Inactive


FERNALD, SHAWN

Individual

Inactive


VARCOE, WALTER

Individual

Active


(default) 1 query took 386 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 ( '(+PORT +JERVIS)' IN BOOLEAN MODE) LIMIT 5077386