EDGEWATER [Permits for EDGEWATER]

1 - 17 of 17

JAKUPI, VISAR

Individual

Active


COLEMAN BUILDERS, LLC

Business

Active


SHOSHAN, JACOB

Individual

Active


SHANAHAN, SANDRA C

Individual

Inactive


OZUDOVIC, DUSKO

Individual

Inactive




GREENLAW, JEAN

Individual

Active


APPROVED CHIMNEY LLC

Business

Active


COLEMEN, JOHN

Individual

Active


CURRIER, CHAD

Individual

Inactive


RAGER, RICHARD

Individual

Inactive


SCIUTO, GIUSEPPE

Individual

Active


Shelley, Catie

Individual

Active


ADX DESIGN & CONSTRUCTION INC.

Business

Inactive


EDGEWATER CAPITAL, INC.

Business

Inactive



(default) 1 query took 209 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 ( '(+EDGEWATER)' IN BOOLEAN MODE) LIMIT 501717209