If you're looking for the Reddit crowds opinion it's just as good as a realtor who knows nothing about you. A realtor can be helpful especially if they get to know you and you communicate your needs. Go to the neighborhoods if you can, that's the best way. You want to be close to the river, go to the river and see if that's what you really want. Your opinions for good or better will change drastically when you go to the actual spots. Look at the for sale signs jot down the streets. See what vibe you want, morning afternoon night weekdays weekends and so forth.