LYNDHURST [Permits for LYNDHURST]

1 - 19 of 19

TOUMAZOU, VASOS

Individual

Active


CEPEDA HARVEY, ERASMO

Individual

Active


PENA, RAMIRO

Business

Active


PENA, LUIS F

Individual

Active


TAKMAZ, TAYFUN

Individual

Inactive


KACZMAR, MATTHEW

Individual

Active


PIRYOL, MEHMET

Individual

Inactive


ACARCICEK, BURAK

Individual

Inactive


CRCAN, HUSEYIN

Individual

Active


KURUM, SEHAT

Individual

Inactive


KARATAS, ABDULLAH

Individual

Active


ERKUT, SERKAN

Individual

Inactive


ADEL RENOVATION INC.

Business

Active


VT HOME IMPROVEMENT AND PAINT

Business

Inactive


NOWAK, ADAM

Individual

Active


EKSIOGLU, YASIN

Individual

Inactive


HALLIDAY,WILLIAM

Business

Inactive


YILMAZ, DENIZ

Individual

Active


BALTIC WOOD FLOORS INC

Business

Inactive


(default) 1 query took 212 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 ( '(+LYNDHURST)' IN BOOLEAN MODE) LIMIT 501919212