SOMERSET [Permits for SOMERSET]

1 - 15 of 15

MAGGIECOMO, IAN

Individual

Inactive


WAGNER, ROBERT C

Individual

Active


WYNJAM BUILDING SERVICES

Business

Inactive


JONES, JOHN

Individual

Active


EOS CCA

Business

Active


MOK, SAI

Individual

Active


MAHMOOD, ARFAN

Individual

Active


SCHWARTZ, DANIEL

Individual

Inactive


OKNIN, NAOR

Individual

Active


MILES, CHARLES

Individual

Active


WRIGHT, MELVIN R

Individual

Inactive


JONES, LLOYD W

Individual

Inactive


DAVIDSON, PATRICIA K

Individual

Active



ALPS TECHNOLOGIES INC.

Business

Active


(default) 1 query took 239 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 ( '(+SOMERSET)' IN BOOLEAN MODE) LIMIT 501515239