1. schools tab (another ticket)

29 Delmar St

San Francisco, CA 94117


  • 2 Units
  • Sold
  • 4 Beds
  • 2 Baths
  • 3,300 SqFt
  • MLS# 413947

Viewing of 54 photos

2-Unit Edwardian Building built in 1915. Prime Cole Valley Location! Close to Parks, Schools, Restaurants, Shops and Public Transportation. Walk-Score 92
2 Vacant, Full-Floor Flats with identical floor plans. Each Flat with 2-Bedrooms, Split Bath, Living Room with Bay Windows + Fireplace, Formal Dining Room, Large Eat-In Kitchen and finished Porch, Bay Windows, High Ceilings, Wood Floors and Period Details
Large Garage for up to 4 Cars, with interior access, Large Basement + Storage and Landscaped Garden
Both Flats Delivered Vacant! No Evictions/No OMIs or Ellis Act Fast-Track'' Condo Conversion Opportunity!
Also offered as 2 TICs /No Condo Lottery!! -Upper Flat #29 TIC Price $775,000 -Lower Flat #31, TIC Price $725,000


Cross Street:

Waller & Frederick


San Francisco


San Francisco

Housing Units & Financial Information

Interior Features

Exterior Features

Additional Details

About Haight Ashbury

Photo of Haight Ashbury - Photo 1

A street in Haight Ashbury [photo by: spinnn, Flickr]

Photo of Haight Ashbury - Photo 2

Brightly Colored Victorians in Haight Ashbury [photo by: jondoeforty1, Flickr]

Photo of Haight Ashbury - Photo 3

[photo by: Kevin Hutchinson, Flickr]

Average Sale Price


3 Months6 Months1 Year

Average Days On Market


3 Months6 Months1 Year

Sale Price as (%) of Asking Price


3 Months6 Months1 Year

Average Listings


3 Months6 Months1 Year

The Haight-Ashbury is often remembered as the hippy Mecca – a place where The Grateful Dead live on forever. But the Haight is so much more than that: it is the central destination for all things “alternative” in San Francisco. And for a city that prides itself in being different, that’s saying quite a lot.

The primary retail destination for the Haight-Ashbury is along Haight Street, primarily between Divisadero and Stanyan. If you’re lucky enough to find a parking spot on the weekend, wander up and down these blocks and see things you certainly won’t find in Kansas.

The 60s are alive and well at shops like Pipe Dreams and The Love of Ganesha, but the artistic skater and DJ crowd also gather at unique shops like Giant Robot, Robotspeak and the Milk Bar. You’ll find killer clothing at Villains, funky shoes at Shoe Biz, or the simply outrageous at Piedmont Boutique. And the second hand vintage clothing stores are legendary – stop into Wasteland or Aaardvark’s Odd Ark. And feel free to spend your day checking out world-famous Amoeba Records.

There is no lack of intriguing restaurants like Cha! Cha! Cha!, Magnolia Pub and Brewery, Citrus Club and Alembic. Take a casual approach at Squat & Gobble or Ben & Jerry’s, located right at the intersection of Haight and Ashbury. And stop in for a quality drink at Persian Aub Zam Zam.

Haight Ashbury real estate consists of classic San Francisco homes and condominium flats, many with Victorian and Edwardian detailing. Look for original molding, charismatic wood floors and high ceilings. And you’re just a quick walk to Golden Gate Park.

While you might find a few tourists wandering Haight, you probably won’t find them in Cole Valley. Cole Valley is just a few blocks south, but couldn’t be more different from its hippy neighbor. Here you’ll find a quaint neighborhood, just two blocks long, that is a wonderful place to raise kids or just live the San Francisco life. There are many great restaurants packed in here, like Eos, Grandeho's Kamekyo Sushi Bar, Zazie (great for brunch) and the Reverie, a relaxing coffee house. Cole Valley real estate includes condominium flats and comfortable single family houses that line quiet and narrow streets.

Wander east on Haight and you’ll find yourself in “Lower Haight,” considered part of Hayes Valley. Head up the hill and you’ll discover Buena Vista Park. Buena Vista Park is a quiet respite, dense with foliage which unveils a great dog park at the top of the hill. Around Buena Vista Park you’ll find wonderfully maintained and grand Victorian homes.

Ashbury Heights, located on one of the Twin Peaks, is just south of Haight. Ashbury Heights real estate includes grand single family homes – some might call them mansions – both old and new.


More About Haight Ashbury

Presented By

Chris Panou's Photo

Chris Panou

McGuire Partner and Top Producer

CalBRE# 01332182


View My Other Listings Contact Me
McGuire Laptop
Property Alerts

Sign up and receive email alerts when new listings come on the market.

Listing Agent:

Chris Panou

Listing Brokerage:

McGuire Real Estate

© 2015 San Francisco Association of Realtors. All rights reserved. Listings on this page identified as belonging to another listing firm are based upon data obtained from the SFAR MLS, which is copyrighted by the San Francisco Association of REALTORS®, but is not warranted. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective consumers interested in purchasing. Listing Broker has attempted to offer accurate data, but buyers are advised to confirm all data provided. This information, including square footage, while not guaranteed, has been acquired from sources believed to be reliable.

This data is up-to-date as of 11/30/15. For the most current information, contact
McGuire Client Care at 800-473-7858 or clientcare@mcguire.com.

Property Explorer