BRONXVILLE [Permits for BRONXVILLE]

51 - 63 of 63

GUTTILLA, MICHAEL T

Individual

Active


WALKER, DERRICK

Individual

Inactive


PANDURI CONSTRUCTION INC

Business

Active


LAJQI, NORA

Individual

Active


AUGUSTYN, JOHN T

Individual

Active


PARERES, LISA M

Individual

Inactive


A C INTERIOR GROUP

Business

Inactive


GUTTILLA CONTRACTING, LTD.

Business

Inactive


MARIO ZINO CONTRACTING, INC.

Business

Inactive


RAMBOECK, WOLFGANG

Individual

Active


BARROS, DOMINGO

Individual

Active


JOHN AUGUSTYN RENOVATIONS

Business

Active


ANTONIO CIAMPA, LLC

Business

Inactive


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