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] => 2024-11-25 11:19:58
[post_modified_gmt] => 2024-11-25 19:19:58
[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, 474 Linden Street, San Francisco, CA, 94102
ffd_mls_id, 509686
ffd_salesforce_id, a0E1I00000TVFY0UAP
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 2
address2__c, 474 Linden Street, San Francisco, CA, 94102
pba__address_pb__c, 474 Linden Street, San Francisco, CA, 94102
agent_only_remarks__c, If your client wants something comparable to 555 Fulton but EVEN BETTER check out this very unique and customized property. Upper unit 476 Linden sold in 2018 for 2.150M. Please email or text Julie at 415-823-0824 with questions or for showings. After Sunday it will be on Supra. Must email PEAD for CBS code. Disclosures available next week. No sign on building.
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2017
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Roger Perez
pba__contingentdate__c, 2020-12-20
ffd_createddate, 2020-11-11T19:45:39.000+0000
days_on_market__c, 1511
dom__c, 71
ffd_description_pb, This is a rare opportunity to own a custom designed and built home in one of San Francisco's most desirable neighborhoods. Nestled behind the wildly popular and vibrant Hayes Street, the unique facade and style of 476 Linden commands attention. Stephen Phillips Architects designed the duplex to embrace the surrounding eclectic group of Victorian and Edwardian homes yet stand out as a contemporary masterpiece. The building is clad with black zinc panels designed to weather from black to soft gray. A curved roof visually mitigates the building's height while also creating a dynamic interior space. 474 Linden is the lower unit, with 2bd/2ba on two levels, and includes a large private yard with access from the primary bedroom and garage. No expense spared in the customized interior which includes custom teak cabinetry, concrete and marble counters, and bleached white oak floors. Parking for one car plus storage in garage. Must see!
474 Linden Street, San Francisco, CA, 94102 - Property Description
This is a rare opportunity to own a custom designed and built home in one of San Francisco's most desirable neighborhoods. Nestled behind the wildly popular and vibrant Hayes Street, the unique facade and style of 476 Linden commands attention. Stephen Phillips Architects designed the duplex to embrace the surrounding eclectic group of Victorian and Edwardian homes yet stand out as a contemporary masterpiece. The building is clad with black zinc panels designed to weather from black to soft gray. A curved roof visually mitigates the building's height while also creating a dynamic interior space. 474 Linden is the lower unit, with 2bd/2ba on two levels, and includes a large private yard with access from the primary bedroom and garage. No expense spared in the customized interior which includes custom teak cabinetry, concrete and marble counters, and bleached white oak floors. Parking for one car plus storage in garage. Must see!
