MOUNT SINAI [Permits for MOUNT SINAI]

1 - 31 of 31

C. TECH COLLECTIONS, INC.

Business

Active


BUILDING BELIEVERS, LLC

Business

Active


MICHAELIDES, COSTAS

Individual

Active


Lawrence, Cody

Individual

Inactive


SOFIA CONSTRUCTION CORP.

Business

Inactive


FLOBECK, CHRISTOPHER

Individual

Active


GROLZ, GEORGE

Individual

Active


SOFIA, JOSEPH F

Individual

Inactive


BUSTAMANTE, NANO

Individual

Inactive


SIGMA CONSTRUCTION

Business

Active



mccarthy, charles

Individual

Active




Zaveri, Nirupama

Individual

Active


SCOTT, CAROLYN D

Business

Active


HK RECOVERY GROUP, INC.

Business

Active


H & K INVESTIGATION, INC.

Business

Active



BROCK, DEITRA ANN M.

Individual

Inactive


MALIZIA, JOHN

Individual

Active


YEAMANS, JOHN

Individual

Inactive


BERTINI, JAMES

Individual

Inactive



JOHN'S RENOVATIONS

Business

Active



TTC SERVICE CORP

Business

Inactive


MOUNT SINAI CONTRACTOR CORP

Business

Active



BROWN, LATONYA

Individual

Active


SAM SURGICAL SUPPLY

Business

Active


(default) 1 query took 222 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 ( '(+MOUNT +SINAI)' IN BOOLEAN MODE) LIMIT 503131222