Greenville used to be real nice. It probably still is.
If you like nightlife and remarkably interesting restaurants, downtown condo life is exploding.
Southeast in Mauldin area still has 2 to 10 acre hobby farms.
If you still like life on the water, consider Clemson or Keowee lake property.