i've got a small aquaponic system in my basement.. well, medium may be a better term.. i started with a 110gal ft outdoors in 2010 and moved into the basement that fall.. now i've got an 8' kiddie pool with 200 fish (yp and tilapia), and a few dozen crayfish..i've got a "single tote ibc system" raising rosy red minnows, but my breeder blue tilapia will be going in it..
raising a few hundred marmokreb crayfish in smaller tanks, mostly feed for the yp (and a couple bg)
i've got 3 IBC tote halves that i use as growbeds.. i'm only using t8 shop lights for lighting (1 pair of 32watt bulbs in each fixture, 3 fixtures per growbed).. we've had lots of lettuce, basil, radishes, beets..
so yeah, depends on what you want to do.. i'd love a pond but i'd still do ap given the chance