RONKONKOMA [Permits for RONKONKOMA]

51 - 91 of 91

M DADDIO INC

Business

Active


CERONE, FRANK

Business

Inactive



Olmsted, Kristin

Individual

Active


WIRTH, CHRISTOPHER

Individual

Inactive



LIENAU, EDWARD

Individual

Inactive


Valenti, Phil

Individual

Active


PLANTE, GREGORY R

Individual

Active


MAXIMUM ENERGY SAVERS, INC.

Business

Active


JOHN, DONALD

Individual

Inactive


ELLENBERGER, JAMES D

Individual

Inactive


ISLAND BUILDERS CORP.

Business

Active


BREITFELLER JR., GERALD

Individual

Active



ABSOLUTE RENOVATIONS, INC.

Business

Inactive


R S S SCALES

Business

Active


STEENECK, MICHAEL C

Individual

Active


JONES, CHRIS

Individual

Inactive


MIGLIO, MATTHEW

Individual

Active


QUILES, ERIC

Individual

Active


P.C.I. SERVICES INC.

Business

Active


Zafiropoulos, Evangelia

Individual

Active


GOVEA, JENNIFER

Individual

Active


CERONE, FRANK

Individual

Inactive


MORRISSEY, DOUGLAS

Individual

Inactive



Maskin, Scott

Individual

Active


QUARANTA, ARNOLD

Individual

Active



CHU, ARTHUR

Individual

Inactive


PRAST, MICHAEL

Individual

Active


MDP CONSTRUCTION COMPANY

Business

Active


LIV CONSTRUCTION SERVICES INC

Business

Inactive


POOL CARE, INC.

Business

Inactive


SAFEWAY INSTALLATION CORP.

Business

Active


RENEWAL BATH SYSTEMS CORP.

Business

Active


RENCO CONSTRUCTION CORP.

Business

Inactive


ROCKMORE CONTRACTING CORP.

Business

Inactive



RESTORATION EXPERTS 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 ( '(+RONKONKOMA)' IN BOOLEAN MODE) LIMIT 50, 504141248
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+RONKONKOMA)' IN BOOLEAN MODE)11208