FRANKLIN SQUARE [Permits for FRANKLIN SQUARE]

1 - 50 of 86

M ILAHI CONSTRUCTION INC

Business

Inactive



VALENTIN, JASON

Individual

Inactive


J.P's Home Decor

Business

Active


EXCLUSIVE CONCEPTS, INC.

Business

Active


GALAXY HOMES INC.

Business

Inactive


KATSIGIORGIS, ANNA

Individual

Active


SJG CONSTRUCTION CORP.

Business

Active


JAWAD, MANZOOR

Individual

Active


RUSSO, PAUL N

Individual

Active


DELUTRI, JOHN

Individual

Active


DREAM GARAGE USA INC.

Business

Active


MILLENNIUM LANDSCAPING INC.

Business

Active


M&M HOME IMPROVEMENTS

Business

Active


PARRINO, ROBERTO

Individual

Inactive


FRATARCANGELI, JOHN

Individual

Active


SELVAGGIO, VINCENT

Individual

Active


JPF POOL SERVICES, INC.

Business

Active


charalambous, nikos

Individual

Inactive


CAPPELLI CONSTRUCTION CORP

Business

Active


CAPPELLI, LOUIS

Individual

Active



HMJ CORP.

Business

Active


D & K CONSTRUCTION GROUP INC.

Business

Inactive


WE SHOW UP CONSTRUCTION LLC

Business

Active




P. O'CONNOR & SONS, INC.

Business

Active


QUALITY CONTRACTOR

Business

Active


CONTI, DAVID

Individual

Active


DCNY HOME IMPROVEMENT INC

Business

Active


POMARA, ELLEN

Business

Inactive


AP SERVICE SOLUTIONS CORP

Business

Active



SAMCOLE INDUSTRIES, LTD.

Business

Active


MURPHY, JAMES

Individual

Active


PALMARI CONTRACTING, INC.

Business

Active


K & N TRIM SPECIALIST INC.

Business

Active


IRLANDUS INC

Business

Active


Gould, Ana

Individual

Inactive



VAGLICA, ANTHONY

Individual

Active


STEIGER, JENNIFER

Individual

Active


R & M CHIMNEY REPAIR INC.

Business

Active



Perez, Albert

Individual

Active


DAMATO, JOHN M

Individual

Active


V.D.M. MASON CORP.

Business

Active


FUSCHETTO LANDSCAPING INC.

Business

Active


CHARALAMBOUS, VASILIS

Individual

Inactive


(default) 2 queries took 312 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 50505079
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)11233