loading your dream home...

Loading Gif
  • Image number 1 for slideshow of 509 Frederick Street #2
  • Image number 2 for slideshow of 509 Frederick Street #2
  • Image number 3 for slideshow of 509 Frederick Street #2
  • Image number 4 for slideshow of 509 Frederick Street #2

Laura Rogers & John Farnham present:

Exceptional Cole Valley home


About this home's










Welcome home! This bright and airy three bedroom, two bath condo is located in the coveted Cole Valley/Parnassus Heights neighborhood and offers a smart, open floorplan. Newly constructed in 2005, this turn key home is made for modern living. The spacious living/dining room opens up to the kitchen with glass sliders leading out to a large deck, the perfect place for a BBQ or to sit with a morning cup of coffee. A den/office area adjacent to the kitchen features pocket doors that can be closed for privacy and lend flexibility and additional utility to the space. There are three well sized bedrooms, including a primary suite with step out Juliet balcony, huge walk-in closet and attached bath. Additional amenities include in-unit laundry, a sunny shared deck, storage and parking for one car. Near Cole Street shops and restaurants, the Haight Ashbury commercial district and gorgeous Golden Gate Park. Enjoy all that this beloved neighborhood has to offer from this convenient location!

  • Flexible floorplan with open living area
  • Three bedrooms/two baths, including primary bedroom with en suite bath, featuring bathtub with tile surround, dual sink vanity and hex tile floors.
  • Second guest bath with soaking tub and pedestal sink
  • Remodeled kitchen with stainless steel appliances, including dishwasher, gas range and large sliding glass doors that lead to adjacent deck and flood the space with natural light
  • Views of St. Ignatius Church from the front bedroom
  • Multiple outdoor spaces­
  • Radiant heating
  • Recessed lighting throughout
  • In-unit laundry
  • Self managed HOA with low dues of $450/month
  • Independent parking for one car 
  • Additional storage
  • 1297 sq. ft. (per tax records)
  • Incredible central location - Walkscore of 99 - walker’s paradise!

get in touch


Open Houses:
Sunday July 11th from 11am-1pm

Brokers Tour:
Tuesday July 13th from 12-1:30pm

Additional Showings by Appointment:
Contact Laura Rogers
(415) 990-0221
[email protected]

Contact John Farnham
(415) 515-9211
[email protected]

Laura Rogers


Realtor Associate

DRE# 01307471

415.990.0221 mobile


John Farnham


Broker Associate

DRE# 01335382

415.515.9211 office

last step to your dream home

Email Us

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Neighborhood Gallery

509 Frederick Street #2

Despite its relatively small size, Cole Valley is surrounded by some of San Francisco’s most popular landmarks. The homes in the Cole Valley neighborhood epitomize the phrase “modern luxury.” Beautiful ocean views and fully-remodeled interiors make Cole Valley an incredibly popular place to live. With so many great public parks and activities within walking distance, plus the Golden Gate Bridge just a short trip north, Cole Valley does not disappoint! Cole Valley is perfect for executives and researchers of the University of California, San Francisco who want an easy commute. Located less than half a mile from the neighborhood, the Parnassus Heights campus is within walking distance of Cole Valley. Notable research/medical facilities at UCSF include Regeneration Medicine and Stem Cell Research, the Diabetes Center, and the Helen Diller Medical Center. The Cole Valley neighborhood is also a mile away from the 1000+ acre Golden Gate Park. Residents can easily spend hours here and never run out of things to explore! Some of the more notable landmarks in Golden Gate Park include: Japanese Tea Garden: Built in 1894, the Garden is a great place to meditate and enjoy nature any time of day. Koret Playground and Carousel: Located in the southeast corner of the park, closest to Cole Valley, both kids and adults can enjoy all the fun and games at this beautiful public playground. Archery Fields: Whether you want to keep your skills sharp or learn a new skill altogether, this facility provides bales of hay; all you need are your own targets and equipment. This is just a small sampling of the many activities you can find at Golden Gate Park. Of course, there is always the option of finding a grassy spot and just enjoying the beautiful California sunshine. If you love enjoying great food, beer, and wine, Cole Valley is the place for you. Start your day with a short (or long) visit to La Boulangerie and enjoy their French-American pastries and entrees along with some fantastic coffee or espresso. Other notable restaurants in Cole Valley include the Italian wine nook InoVino, the quaint corner tavern Kezar Bar & Restaurant, the casual-yet-popular BurgerMeister, and last but not least, the eclectic offerings of Padrecito. Cole Valley is also within walking distance (and home to) several popular and interesting landmarks. Cole Hardware’s flagship store is located in Cole Valley and has been serving the community for almost 100 years. You can walk to the infamous Haight-Ashbury district or take a hike up Mt Sutro for great views and see one of the old NIKE missile silos. Interested in geography? Walk up Clayton towards 17th to see the blank monument for the reported perfect geographic center of SF One of the best parts about living in Cole Valley is its convenient access to the N Judah municipal light rail (“Muni”) route. Residents of Cole Valley can hop on this frequently-running light rail and commute to the Google headquarters in less than 30 minutes. The N Judah route is also ideal for traveling to landmarks such as the San Francisco Museum of Modern Art and Embarcadero Plaza.