Array
(
[ID] => 15726
[post_author] => 4
[post_date] => 2018-11-02 19:54:49
[post_date_gmt] => 2018-11-02 19:54:49
[post_content] => Once a dairy farm. Now it's where global day-traders and future financiers in training come to rest their spreadsheet-weary eyes at night. Home to Union Street shops and restaurants, as well as classic north end style, served in slightly smaller sizes than the estates of Pacific Heights.
[post_title] => Cow Hollow
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cow-hollow
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-15 13:36:25
[post_modified_gmt] => 2024-11-15 21:36:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15726
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1701778346
ffd_listing_title, 2557 Filbert 2571 Street, San Francisco, CA, 94123
ffd_mls_id, 423907253
ffd_salesforce_id, a0E8W00000dSM54UAG
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2557 Filbert 2571 Street, San Francisco, CA, 94123
pba__address_pb__c, 2557 Filbert 2571 Street, San Francisco, CA, 94123
agent_only_remarks__c, Entire property is vacant. 2557-71Filbert.com - Call/text/email David Werboff for showing or questions: (415) 317-0802 [email protected]. Pre-escrow is open with Kelley Kish at First American Title. Neither the listing agent or seller has independently verified square footage amounts, buyer to investigate to their satisfaction.
pba__fullbathrooms_pb__c, 10
pba__bedrooms_pb__c, 9
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-11-07
ffd_createddate, 2023-09-11T17:46:43.000+0000
days_on_market__c, 85
dom__c, 67
ffd_description_pb, A truly rare opportunity in a highly coveted Cow Hollow location, this one-of-a-kind estate consists of three separate residences on a double-sized lot with gardens, sun-washed terraces, sitting areas, and lush groves woven among them. It provides sweeping top-of-the world water and city views of the bay, city skyline, and iconic San Francisco landmarks. Each home's classic details such as hardwood floors, bay and diamond-pane windows, stone fireplaces, decorative millwork serve as reminders of their aesthetic provenance, while various contemporary upgrades and expansions ground them in the 21st century. At the apex of the property, 2567 is the largest of the homes, comprising three levels, 4 bedrooms, formal living and dining rooms, a sunroom, and a media room/den/office flex use level. 2557 features five bedrooms, formal living and dining rooms, a remodeled kitchen, and a private fenced terrace. 2571 is a charming one-bedroom cottage that houses two side by side garages for the property. This versatile estate is perfect for using as a compound, grand entertaining, income/investment opportunities and more.
2557 Filbert 2571 Street, San Francisco, CA, 94123 - Property Description
A truly rare opportunity in a highly coveted Cow Hollow location, this one-of-a-kind estate consists of three separate residences on a double-sized lot with gardens, sun-washed terraces, sitting areas, and lush groves woven among them. It provides sweeping top-of-the world water and city views of the bay, city skyline, and iconic San Francisco landmarks. Each home's classic details such as hardwood floors, bay and diamond-pane windows, stone fireplaces, decorative millwork serve as reminders of their aesthetic provenance, while various contemporary upgrades and expansions ground them in the 21st century. At the apex of the property, 2567 is the largest of the homes, comprising three levels, 4 bedrooms, formal living and dining rooms, a sunroom, and a media room/den/office flex use level. 2557 features five bedrooms, formal living and dining rooms, a remodeled kitchen, and a private fenced terrace. 2571 is a charming one-bedroom cottage that houses two side by side garages for the property. This versatile estate is perfect for using as a compound, grand entertaining, income/investment opportunities and more.
