WANTAGH [Permits for WANTAGH]

51 - 78 of 78

SIMOES, ANTONIO

Individual

Active


Giberti, Nicholas

Individual

Active


TRITTHART, THOMAS F

Individual

Inactive


DELUCA, JOSEPH M

Individual

Active



ZAMPINI, MICHAEL

Individual

Active


SPISTO, ROSEMARIE

Individual

Active


KERINS, JR. ROBERT

Individual

Inactive


TRAINA, EDWARD D

Individual

Inactive


BEHAR, LARRY

Individual

Inactive


Michalewicz, Maria

Individual

Active


STAHLEY CONSTRUCTION INC.

Business

Active


CASCONE, VICENT

Individual

Inactive


DUFFY, PETER

Individual

Active


KERINS, ROBERT

Individual

Active


LOSITO, ANTHONY

Individual

Active



CELLFONZ R US OF WANTAGH INC.

Business

Inactive


CELLFONZ R US OF WANTAGH INC.

Business

Inactive


METRO CEMENT, INC.

Business

Inactive


EAST COAST CONSTRUCTION

Business

Inactive


TRU-TEK CONSTRUCTION INC.

Business

Inactive


TRITIUM CARD SERVICES, INC.

Business

Inactive


CELLFONZ R US OF WANTAGH INC.

Business

Inactive


KARABINOS, RASTISLAV

Business

Inactive



CELLFONZ R US OF WANTAGH INC.

Business

Inactive


CLASSIC HOME REMODELING, INC.

Business

Inactive


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