Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 08:49:02
[post_modified_gmt] => 2023-06-23 15:49:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 605 Waller Street, San Francisco, CA, 94117
ffd_mls_id, 423902651
ffd_salesforce_id, a0E8W00000dSExNUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 3
address2__c, 605 Waller Street, San Francisco, CA, 94117
pba__address_pb__c, 605 Waller Street, San Francisco, CA, 94117
agent_only_remarks__c, Please call or text Colleen Cotter (415.706.1781) and/or Zoe Frankel (415.235.9422) for more information. Disclosures will be linked here shortly. For more information visit: https://www.605waller.com/ Disclosures: https://app.disclosures.io/link/605-Waller-Street-puyygacw
appliances__c, Dishwasher;Free Standing Gas Oven;Wine Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1890
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-08T19:46:51.000+0000
days_on_market__c, 18
dom__c, 18
ffd_description_pb, 605 Waller Street is a rare opportunity to own a slice of San Francisco history! This 4 bedroom, 3 bathroom penthouse condominium is the perfect marriage between modern luxury & San Francisco elegance. Spanning two levels, this single family home alternative, has been completely remodeled and leaves nothing to be desired. It features hardwood floors, stunning historic elements, and iconic San Francisco bay windows which bathe the unit in natural light. On the main level you will find plenty of space to entertain, including a triple parlor'' living space & a chef's kitchen with its own breakfast nook. Two spacious bedrooms and two spa-like bathrooms can be found on the main level, while the third bedroom & primary wing are located upstairs. French doors open directly from the primary onto a newly added, sunny roof deck that overlooks picturesque hillsides! This home also comes with a private garage and additional storage.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Exterior
605 Waller Street is a rare opportunity to own a slice of San Francisco history! This 4 bedroom, 3 bathroom penthouse condominium is the perfect marriage between modern luxury & San Francisco elegance. Spanning two levels, this single family home alternative, has been completely remodeled and leaves nothing to be desired. It features hardwood floors, stunning historic elements, and iconic San Francisco bay windows which bathe the unit in natural light. On the main level you will find plenty of space to entertain, including a triple parlor'' living space & a chef's kitchen with its own breakfast nook. Two spacious bedrooms and two spa-like bathrooms can be found on the main level, while the third bedroom & primary wing are located upstairs. French doors open directly from the primary onto a newly added, sunny roof deck that overlooks picturesque hillsides! This home also comes with a private garage and additional storage.
