SHELTON [Permits for SHELTON]

1 - 9 of 9

COLLECT ASSOCIATES

Business

Active


KATHRAKIS, LOU

Individual

Inactive


LOANWORKS SERVICING LLC

Business

Active


Brzostowski, Marek

Individual

Active


CRAWFORD, SHELTON

Individual

Active


PUSKAS, ALEXANDER

Business

Active


Shelton, Trent

Individual

Active


MTL LLC

Business

Inactive


SMALL OX MASONARY

Business

Active


(default) 1 query took 327 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 ( '(+SHELTON)' IN BOOLEAN MODE) LIMIT 5099327