San Franicsco is a densely populated city where many properties aside from hi-rises offer views. Most hi-rises in the city are east of Van Ness Avenue and south of Market. As neighborhood is of concern to you, it all depends on what exactly you are seeking in a neighborhood and the kind of lifestyle that appeals to you. In order to best answer your question - rather than just spit out names of buildings and neighborhoods, please provide more detail about these items. Feel free to call me at 415-200-7202.
You can also find spectular views in buildings that are on one of San Francisco's many hills, so the building doesn't have to be a high rise. If the neighborhood has "heights" or "hill" in the name you can be assured of finding places with great views. For instance one of my listings is in Corona Heights at http://www.417Roosevelt.com and has expansive views including downtown in the distance. The views are truly stunning from its two large decks and from the Living Room and Master bedroom.
Telegraph Hill, Ashbury Heights, Corona Heights, Parnassus Heights, Diamond Heights, Potreto Hill, etc. Twin Peaks, Noe Valley and some other neighborhoods also have condos and houses with phenomonal views.
What is your price range, and minimum size requirements?
Just south of AT&T Park, the new condominiums (The Madrone) has unobstructed views of the city and it's an up and coming neighborhood with UCSF Hospital (future); Bayer; Life Sciences; Bio Tech; UCSF Mission Bay; etc.
Many agents, including myself, will be showing these residences.
Do you want to live in Pacific Heights, Russian Hill or South Beach? I think those areas have the best high rise apartments with great views. If you are unsure, drive around the areas and get a feel for the neighborhoods for they are very different. If you go to my website, you will find descriptions of the areas.
Do you have a realtor? You should ask her or him. There are many nice highrise buildings and the prices vary per area. If you do not have your own realtor, ask one of us. We would all be happy to point you in the right direction.
Depending on your definition of 'sketchy', this could take you in many directions. Instantly, I think of One Rincon Hill, The Metropolitan, The Infinity, and One Hawthorne as four great options for you. All are in areas that I would define as safe and offer some of the best views in San Francisco. Ground breaking for Phase 2 of One Rincon Hill is planned for next month so if you decide to move into a home there on the NE side be aware that there will be some construction for about 24 to 26 months.
I hope this is helpful and feel free to contact me directly if you'd like to discuss this further.
Oggi Kashi - 415.690.3792 direct
Broker Associate, Paragon Real Estate Group CA DRE 01844627
All data from sources deemed reliable but subject to errors and omissions, and not warranted.