REITHOFFER SHOWS, INC. is a registered Business operating as a Amusement Device Temporary in FLUSHING. DCA License Number 2054535-DCA is currently Inactive (expiry date 07/09/2017). Device Name(s): TIDAL WAVE, STARSHIP 3000, SPEEDWAY, BEAR, TRUCK STOP, HIMALAYLA, TORNADO, ARCTIC BLAST, PHAROHS FURY, SKY FLYER, MULLIGAN WHEEL, WACKY MOUSE, MERRY GO ROUND, FUN SLIDE, JUSTICE LEAGUE, MINI WAVE SWINGER, MINI LNDY
Telephone: 8137869921.
123-01
ROOSEVELT AVENUE
CITIFIELD
FLUSHING
NY
11368
Dca License Number | 2054535-DCA |
License Type | Business |
License Expiration Date | 07/09/2017 |
License Status | Inactive |
License Creation Date | 06/15/2017 |
Industry | Amusement Device Temporary |
Business Name | REITHOFFER SHOWS, INC. |
Business Name 2 | |
Address Building | 123-01 |
Address Street Name | ROOSEVELT AVENUE |
Secondary Address Street Name | CITIFIELD |
Address City | FLUSHING |
Address State | NY |
Address Zip | 11368 |
Contact Phone Number | 8137869921 |
Address Borough | Queens |
Borough Code | 4 |
Community Board | 101 |
Council District | 01 |
Bin | 1000812 |
Bbl | 1000220020 |
Nta | QN99 |
Census Tract | 38302 |
Detail | Device Name(s): TIDAL WAVE, STARSHIP 3000, SPEEDWAY, BEAR, TRUCK STOP, HIMALAYLA, TORNADO, ARCTIC BLAST, PHAROHS FURY, SKY FLYER, MULLIGAN WHEEL, WACKY MOUSE, MERRY GO ROUND, FUN SLIDE, JUSTICE LEAGUE, MINI WAVE SWINGER, MINI LNDY |
Longitude | -74.01290870587448 |
Latitude | 40.70627017391471 |
Location | (40.70627017391471, -74.01290870587448) |
Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `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 `Record`.`DCA_License_Number` = '2054535-DCA' LIMIT 1 | 1 | 1 | 1 | |
2 | SELECT `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 `Record`.`id` < 17575 ORDER BY `Record`.`id` DESC LIMIT 1 | 1 | 1 | 1 | |
3 | SELECT `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 `Record`.`id` >= 17574 AND `Record`.`id` != 17575 ORDER BY `Record`.`id` ASC LIMIT 2 | 2 | 2 | 0 |