Brickset ForumShopping at LEGO or Amazon?
Please use our links: LEGO.com • Amazon
As an Amazon Associate we earn from qualifying purchases.
Please use our links: LEGO.com • Amazon
As an Amazon Associate we earn from qualifying purchases.
Search
-
FS/FT Minifigs from TMNT #79100
I have the 2 mini figures and Kraang character from set #79100 for sale or trade. Interested in Superheroes or other interesting mini figures. PM with offers. -
For sale (US), some more stuff for sale
After the success of my first marketplace thread, it has become time again for me to part with another chunk of my collection. Everything is mostly Star Wars, but also some other randoms. It all comes from a smoke free home, but I do have a couple pets so you might find a few stray hairs sorry about that. Everything is… -
Re: The "brag" thread: Post your recent great finds!
Grabbed a bulk lot for $50 with everything in perfect condition. After I went through and id'd what I could, I ended up with complete sets of #9496, #79100, and #79102. The part I'm most excited about is that it had most of #76023, including the minifigs and almost all of the pieces with the stickers applied. After going… -
Re: LEGO 2013 and 2014 Set Rumors
79100 includes a Kraang brain inside of a robotic walking pod with clear dome, a smiling Mikey breaking out of a small prison, and a footsoldier being hit with a pizza. 79101 includes Shredder on a black ninjago-esque bike with large tires and big pipes emitting flames (hopefully the final version looks better), Donatello… -
Re: LEGO Teenage Mutant Ninja Turtles
Hi everybody, Stumbled across this on EuroBricks. Just wanted to share it here... 79100 79101 79105 Larger images of the sets we have already seen: 79102 79103 79104 -
Re: Box Art Blunders
I just noticed that in #79100 Kraang Lab Escape Mikey is wearing the wrong legs in the main image. He should be wearing bright green legs but has regular green ones, presumably from a different Turtle. It is more obvious in the [email protected] image with a white background but after seeing it you can tell the box art has the same… -
Re: For Sale / Trade (US): #10256 Taj Mahal
UPDATE! I am now on the hunt for a couple of TMNT sets that (naturally - well have they retire) I must have to "complete" the theme: #79100 - Kraang Lab Escape #79102 - Stealth Shell in Pursuit #79015 - Baxter Robot Rampage Also still looking for a completely random Dino Attack set: #7477 - T-1 Typhoon vs. T-Rex And the… -
Re: Various rare sets, keychain and polybags for sale (UK only)
If anyone wants to trade for any of my polys/keychains, here's a few things I'm interested in (They MUST be new or mint, they can be opened or sealed): Iron Man War Machine minifig from #76006 Kraang Exo-Suit minifig from #79104 Space Police 3 Jawson minifig from #5983 or #5984 Kraang creatures from #79100 (ideally… -
Re: TMNT: Cheapest way to get all four turtles
To get one of each turtle, the cheapest set combination would be: #79100 ($12.99) + #79101 ($24.99) + #79103 ($49.99) Simple enough to do by looking at the Brickset database. -
Re: Is there a way to write custom queries directly in SQL?
To provide a concrete example, I generated the following query from the query builder: SELECT * FROM Sets WHERE (NumericSetNumber >= 79100) AND (NumericSetNumber <= 79105 OR NumericSetNumber >= 79115) AND (NumericSetNumber <= 79122 OR NumericSetNumber >= 70800) AND (NumericSetNumber <= 70819) ORDER BY SortKey ASC However,…
35 results
Shopping at LEGO.com or Amazon?
Please use our links: LEGO.com • Amazon
Recent discussions • Categories • Privacy Policy • Brickset.com
Brickset.com is a participant in the Amazon Services LLC Associates Program, the Amazon.com.ca, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.
As an Amazon Associate we earn from qualifying purchases.
