DREAMLAND AMUSEMENTS, INC. is a registered Business operating as a Amusement Device Temporary in STATELINE. DCA License Number 2038306-DCA is currently Inactive (expiry date 06/26/2016). Device Name(s): DREAM WHEEL, DELUSION, DREAM CATCHER, ZIPPER, BUMPER CARS, HIMALAYA, ROCK STAR, SCRAMBLER, TORNADO, JALOPY JUNCTION, DIZZY DRAGON, ELEPHANT, ORIENT EXPRESS, FREE FALL, HAPPY SWING, PONY CART, FUN HOUSE, FIRE ENGINE, STAR SHIP, SLIDE, GLAS
Telephone: 8666663247.
297
KINGSBURY GRADE
MB 4470
STATELINE
NV
89449
Dca License Number | 2038306-DCA |
License Type | Business |
License Expiration Date | 06/26/2016 |
License Status | Inactive |
License Creation Date | 05/26/2016 |
Industry | Amusement Device Temporary |
Business Name | DREAMLAND AMUSEMENTS, INC. |
Business Name 2 | |
Address Building | 297 |
Address Street Name | KINGSBURY GRADE |
Secondary Address Street Name | MB 4470 |
Address City | STATELINE |
Address State | NV |
Address Zip | 89449 |
Contact Phone Number | 8666663247 |
Address Borough | Outside NYC |
Borough Code | |
Community Board | |
Council District | |
Bin | |
Bbl | |
Nta | |
Census Tract | |
Detail | Device Name(s): DREAM WHEEL, DELUSION, DREAM CATCHER, ZIPPER, BUMPER CARS, HIMALAYA, ROCK STAR, SCRAMBLER, TORNADO, JALOPY JUNCTION, DIZZY DRAGON, ELEPHANT, ORIENT EXPRESS, FREE FALL, HAPPY SWING, PONY CART, FUN HOUSE, FIRE ENGINE, STAR SHIP, SLIDE, GLAS |
Longitude | |
Latitude | |
Location |
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` = '2038306-DCA' LIMIT 1 | 1 | 1 | 3 | |
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` < 57271 ORDER BY `Record`.`id` DESC LIMIT 1 | 1 | 1 | 7 | |
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` >= 57270 AND `Record`.`id` != 57271 ORDER BY `Record`.`id` ASC LIMIT 2 | 2 | 2 | 0 |