FRANKLIN SQUARE [Permits for FRANKLIN SQUARE]

51 - 86 of 86

D&K CONSULTING GROUP INC.

Business

Active


NCC Prime Construction Inc.

Business

Inactive


KHADAROO, STEPHEN P

Individual

Inactive





MATT DWYER, INC.

Business

Active


AUNORAG CONSTRUCTION, INC.

Business

Active


VAR HOME IMPROVEMENTS, INC.

Business

Active


CHAMPION CONTRACTING CORP.

Business

Active


SINGH, SURINDERPAL

Individual

Active


SANTIAGO, TABATHA E

Individual

Active



THERMOSIDING CORP.

Business

Active


DREAM TEAM RENOVATIONS INC

Business

Inactive


KENNEDY, KEVIN R

Individual

Active



SHRI CONSTRUCTION, CORP.

Business

Inactive


ALEX, BINU

Individual

Inactive


CORONA, NICHOLAS

Individual

Active


AJT WINDOW SYSTEMS, INC.

Business

Inactive


BOUTELLE, RICHARD

Individual

Active


DELUTRI LANDSCAPING INC

Business

Active


PARISI, JOHN

Individual

Active


Fasano, Daniel

Individual

Active


GALAXY HOMES INC.

Business

Inactive


SAMCOLE INDUSTRIES, LTD.

Business

Inactive



NTS CONTRACTING LLC

Business

Active


NTS CONTRACTING LLC

Business

Inactive


CATC, INC

Business

Inactive



RUNG, DEBORAH

Individual

Active


PML RENOVATIONS INC.

Business

Active



KR LEGAL SERVICES

Business

Inactive


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