OCEANSIDE [Permits for OCEANSIDE]

101 - 131 of 131

NOVICK, WILLIAM P

Individual

Inactive




EISENBERG, SAMUEL

Individual

Active


CARCAMO, MONICA

Individual

Active


J & A INTERIORS, INC.

Business

Active


CUTRONE, MICHAEL

Individual

Active


RH CONSTRUCTION

Business

Active



CLARKE, PATRICK

Individual

Active


WALTUCH, IRA

Individual

Inactive


AMICI CONCRETE AND MASONRY INC

Business

Inactive


CERVERIZZO, MICHAEL E

Individual

Active


CRUZ, MICHAEL A

Individual

Active


CORREALE, MARIO

Individual

Active


GERARDI, SHANNON

Individual

Active


DEL ROSARIO, JOSE

Individual

Active


PROCTOR, NORMAN

Individual

Inactive


FRANZO, JOSEPH

Individual

Active


OCEANSIDE PHARMACY INC.

Business

Inactive




BONNEN, RICHARD

Individual

Active


GDF CONTRACTING INC.

Business

Inactive



COMPLIMENTARY COLORS, LLC

Business

Inactive


MONTEREY COLLECTION SERVICES

Business

Inactive


BUIDONE

Business

Inactive



CONCEPTS IN CONSTRUCTION CORP.

Business

Inactive



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