VALHALLA [Permits for VALHALLA]

1 - 22 of 22


CAVALRY SPV I, LLC

Business

Active


MR. G. PAINTING CORP.

Business

Active


TEXEIRA, RENE

Individual

Active


SCHACHTER PORTNOY, LLC

Business

Active


ANDERS MANAGEMENT

Business

Active


CAVALRY SPV IV, LLC

Business

Active


DIMARIA, ANTHONY

Individual

Active


MCLAUGHLIN, SHAUN

Individual

Inactive


CHOICE FENCE LLC

Business

Active


CHARLES SEGAL, INC.

Business

Active


CAVALRY PORTFOLIO SERVICES

Business

Active


PAPA, ROBERT

Individual

Active


CAVALRY INVESTMENTS, LLC

Business

Active


SIRICO, FRANK

Individual

Active


SEGAL, CHARLES

Individual

Active


GIBBONS, RAYMOND T

Individual

Active


CASSIDY, CIARAN

Individual

Inactive


CAVALRY SPV II, LLC

Business

Active


SCHACHTER PORTNOY, L.L.C.

Business

Inactive



CASSIDY DECORATING CORP.

Business

Inactive


(default) 1 query took 236 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 ( '(+VALHALLA)' IN BOOLEAN MODE) LIMIT 502222236