HASTINGS ON HUD [Permits for HASTINGS ON HUD]

1 - 32 of 32

BURKE, DERMONT

Individual

Active


WARNER, JEFFREY

Individual

Active


KAUFMAN SIMON, LAURA A

Individual

Inactive


Wright-Tubbs, Jennifer

Individual

Active


JIMENEZ, ALBERTO R

Individual

Active


ABIRIZK, RICHARD

Individual

Active


NIAYZOU, SIOMA

Individual

Active


CIVITANO, VINCENT T

Individual

Inactive


LEYDEN, JAMES

Individual

Active


STOJANOVIC, ALEJANDRO

Individual

Active


JOVEN, OSCAR

Individual

Inactive


BROMELL, GAVIN

Individual

Inactive


Marcus, Silvian

Individual

Active


Rio Contracting Inc

Business

Active


MEWMAR, LLC

Business

Active


COMERFORD, JOHN

Individual

Active


McKelvey, Wendy

Individual

Active


GENERAL IMPROVEMENTS INC.

Business

Inactive


Pereira, Filipe

Individual

Active


PAERELS, CELIA

Individual

Active


MALARCZYK, RYSZARD M

Individual

Inactive


WHOLE HOME IMPROVEMENT LLC

Business

Active



THOMAS, CHRISTOPHER M

Individual

Active


garcia, roman

Individual

Inactive


SPIEGEL, ROBERT M

Individual

Inactive


ENGLER, ALAN

Individual

Active


PINECREST GROUP CORP

Business

Active


TESTOURI, MOEZ

Individual

Inactive


AWAK MAINTENANCE LLC

Business

Active


DUNLEAVY CONSTRUCTION CORP.

Business

Inactive


GRYF MARBLE & TILE CORP

Business

Inactive


(default) 1 query took 331 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 ( '(+HASTINGS +ON +HUD)' IN BOOLEAN MODE) LIMIT 503232331