Nuice, you won't find them in your LFS in most cases, you'l have to buy them online. I'm not sure where you're located but if you live in the US and in a legal state you can have them shipped from
Shark Aquarium and
Aquascape Online
I buy all mine from and there and can vouch for both of those places being of good quality and back their fish up with good guarantees.
I second the sanchezi idea. I have a purple one and I am really happy with it. Behavior wise it doesn't really do too much but it is really starting to come out of its shell. Its coloration is amazing too. However, generally the purple ones are more expensive. I don't really mind paying a decent amount for a fish, but if you don't really want to spend much you could get a regular variant for usually around $40 or so.
Yeah I agree a Sanchezi is your best bet. As Mr._Fishy has said the purple ones are more expensive but the red form are awesome looking fish, however It can be difficult to get hold of one as I have been finding out lol
Do you live in the US?
Aquascape Online has both red and purple varients in stock right now.
I accually live in Canada, right now im visiting the Us tho. But it wouldn't survive the 4 hour drive back home. I am really considering the Sanchezi, but what about oscars?
Depends on what you are looking for in a fish. Oscars aren't my thing right now but I can see why people have them. They have better personality than any other fish I've ever had. They aren't predators and I was assuming that's what you were looking for so if you mean as far as a predator fish, then no, Oscars won't give you that. If you're looking for something that isn't a predator then sure but again you'd have to have a minimum of a 75g tank, imo.
The 2 online places I gave may ship to canada. look it up on there or email them, they'll get back to you.
Definitely don't get a piranha unless you are 100% sure that's what you want. I'm not trying to cut you down or insinuate but also don't get one if you just want to show your friends how badass they are when eating because trust me, you'll be sorely disappointed. The people that get them for that reason WILL become bored with them. Yes, if you throw a fish into their tank they will kill it but I don't recommend that and it seems it would get boring after a while.
I'm not saying you want one for that reason but I'm just trying to look out for both you and the fish's best interest just in case.
You actually have to honestly want a piranha for the same reasons others want other type of fish for you to be happy in the long run.
If you do then a sanchezi would definitely be a great fish for your tank for life.
What are you looking for in a fish? Maybe then we can suggest ideas of fish you might not know. (I mean if your mind isn't set on piranhas)