SEAFORD [Permits for SEAFORD]

1 - 50 of 56

AMERICANO CONTRACTING CORP

Business

Inactive


ARISTOCRAFT REMODELING, INC

Business

Active


COLONIAL HOME IMPROVEMENTS

Business

Active


SCOTTO, STEVEN

Individual

Active



WEINBERGER, ELI S

Individual

Active


SCHEIDLE, ROBERT

Individual

Active


MASI CONSTRUCTION INC.

Business

Active


O'BRIEN III, THOMAS F

Individual

Active


SCHEIDLE, ROBERT

Individual

Inactive


MEMBRENO, CARLOS R

Individual

Active


MIRSKY, SCOTT

Individual

Active


CAMPBELL CONTRACTING INC.

Business

Active


THE FIREPLACE STORE, INC.

Business

Active


COMPETELLI JR, JAMES

Individual

Inactive


NIGRO, JASON

Individual

Inactive


TILLIS, ALLEN

Individual

Active


COMPETELLI JR, JAMES

Individual

Active


HUMPHREYS, MARK J

Individual

Active


A Charmed Life at Home

Business

Active


CAPPELLO, ANTHONY F

Individual

Inactive


LOMBARDO, DANIEL

Individual

Inactive



GALTIERI, LUCILLE

Individual

Inactive


POPE, JOEL

Individual

Inactive


CESTRO, MICHAEL

Individual

Active


CAMPBELL, GLENN P.

Individual

Active


ROMANO, JUSTIN

Individual

Active


GURINO, THERESA

Individual

Active


DRASBY, NICHOLAS

Individual

Active


LLERAS, MARK A

Individual

Active


GLATZERMAN, GARY

Individual

Inactive


KAUR, BALWINDER

Individual

Inactive


COGLIETTA, PHILIP J

Individual

Active


ANGUITA, HECTOR M

Individual

Inactive


KARAVAS, EMMANUEL

Individual

Active


SINGH, MANDEEP

Individual

Active


MCNULTY, MICHAEL

Individual

Active


SMITH, RYAN

Individual

Inactive


HONG, TIMOTHY

Individual

Active


YOUNG, MICHAEL S

Individual

Active



valenti, frankie

Individual

Inactive


PISCITELLI, MICHAEL

Individual

Active


Rosner, Jessica

Individual

Active


SINGH, LAKHWINDER

Individual

Active


Barr, Charles

Individual

Inactive


HANLY, JOHN C

Individual

Active


LAPELOSA, NATALE

Individual

Inactive


MASI, GERALD

Individual

Active


(default) 2 queries took 396 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 ( '(+SEAFORD)' IN BOOLEAN MODE) LIMIT 505050153
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SEAFORD)' IN BOOLEAN MODE)11243