REITHOFFER SHOWS, INC. is a registered Business operating as a Amusement Device Temporary in FLUSHING. DCA License Number 2048943-DCA is currently Inactive (expiry date 04/16/2017). Device Name(s): GENTLE GIANT, SUPER HIMALAYA, WILD CLAW, AIR RACE, SPEED, SURF CITY, ZERO GRAVITY, PHAROAHS FURY, SCOOTER EURO, SKY FLYER, GRAND CAROUSEL, WAVE SWINGER, RAIDERS, JUMPING JUMBOS, FUN SLIDE, WIGGLE WURM, CIRCUS TRAIN, ORIENT EXPRESS, SPEEDW
Telephone: 8137869921.
12301
ROOSEVELT AVENUE
FLUSHING
NY
11368
Dca License Number | 2048943-DCA |
License Type | Business |
License Expiration Date | 04/16/2017 |
License Status | Inactive |
License Creation Date | 03/01/2017 |
Industry | Amusement Device Temporary |
Business Name | REITHOFFER SHOWS, INC. |
Business Name 2 | |
Address Building | 12301 |
Address Street Name | ROOSEVELT AVENUE |
Secondary Address Street Name | |
Address City | FLUSHING |
Address State | NY |
Address Zip | 11368 |
Contact Phone Number | 8137869921 |
Address Borough | Queens |
Borough Code | 4 |
Community Board | |
Council District | |
Bin | |
Bbl | |
Nta | QN99 |
Census Tract | 38302 |
Detail | Device Name(s): GENTLE GIANT, SUPER HIMALAYA, WILD CLAW, AIR RACE, SPEED, SURF CITY, ZERO GRAVITY, PHAROAHS FURY, SCOOTER EURO, SKY FLYER, GRAND CAROUSEL, WAVE SWINGER, RAIDERS, JUMPING JUMBOS, FUN SLIDE, WIGGLE WURM, CIRCUS TRAIN, ORIENT EXPRESS, SPEEDW |
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` = '2048943-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` < 18178 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` >= 18177 AND `Record`.`id` != 18178 ORDER BY `Record`.`id` ASC LIMIT 2 | 2 | 2 | 0 |