You are about to buy a bass, but the only reason not to get it is a piezo pickup that has an inbuilt preamp? If you think a piezo creates only hiss, you should test the bass.
I have had an Affirma 4 (fretted), and now own a fretless 5. Both are from the first batch, 90's.