GLEN OAKS [Permits for GLEN OAKS]

101 - 122 of 122



RAMAN CONSTRUCTION, INC.

Business

Inactive



WALDBAUM'S STORE #613

Business

Inactive



R S PREPAID WIRELESS INC.

Business

Active


STAR LIGHT CONSTRUCTION LLC

Business

Active



MAXIS SMOKE SHOP

Business

Inactive



KINGSBORO CONSTRUCTION CORP

Business

Active


AW MOBILE OF GLEN OAKS

Business

Inactive




TRI STATE CONTRACTOR INC

Business

Active


RADHEY GROCERY INC.

Business

Inactive


RITE AID STORE #10557

Business

Active


USA RESTORATION INC.

Business

Active




LYDON QUALITY CONTRACTING

Business

Active


(default) 2 queries took 480 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 ( '(+GLEN +OAKS)' IN BOOLEAN MODE) LIMIT 100, 502222257
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+GLEN +OAKS)' IN BOOLEAN MODE)11223