You mentioned the Xterra. It is definitely a very affordable and solid ride. So, go for it.
What is "affordable" to you? Less than $10,000? Less than $15,000? Less $20,000?
Do you have a mileage or year requirement? I would think most people want to afford as new as possible. So, the most new...