FREEPORT [Permits for FREEPORT]

151 - 177 of 177

BOYD BUILDERS INC.

Business

Active


LEIVA ARITA, BRENCY C

Individual

Inactive


THOMPSON, IRA

Individual

Active


ZAVALA, POLO

Individual

Inactive


TINGLIN, OSMOND

Individual

Inactive


Vides, William

Individual

Active


FELICETTI, GRACE

Individual

Active



A & I CONSTRUCTION

Business

Inactive



ELBI SERVICE AND REPAIR INC

Business

Inactive


JGC INTERIOR, LTD.

Business

Inactive


ROSE FENCE, INC.

Business

Active


EXPRESS RESTORATION INC.

Business

Inactive


RAMCO WINDOWS & SCREENS, INC.

Business

Inactive


NEOSCAPE GARDENS INC.

Business

Inactive


D. PAUL CONSTRUCTION INC.

Business

Active


SINGH, JOGINDER

Individual

Active


ALLIED INTERSTATE LLC

Business

Inactive


ROMY GEN. CONSTRUCTION CORP.

Business

Inactive


DBD SERVICES, INC.

Business

Inactive


SOMY CONSTRUCTION CORP.

Business

Active


SNEDIKER, DONALD

Business

Inactive


W & B CONSTRUCTION INC.

Business

Inactive


LYONS HOME IMPROVEMENT

Business

Inactive


TCF INDUSTRIES INC.

Business

Inactive


ARMENIAN CONSTRUCTION INC.

Business

Inactive


(default) 2 queries took 542 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 ( '(+FREEPORT)' IN BOOLEAN MODE) LIMIT 150, 502727323
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+FREEPORT)' IN BOOLEAN MODE)11219