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] => 2023-06-22 13:37:47
[post_modified_gmt] => 2023-06-22 20:37:47
[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
(
)
)
ffd_listing_title, 2770 Green Street, San Francisco, CA, 94123
ffd_mls_id, 423761211
ffd_salesforce_id, a0E8W00000cpes5UAA
num_of_fireplaces__c, 0
num_of_rooms__c, 12
of_units__c, 0
address2__c, 2770 Green Street, San Francisco, CA, 94123
pba__address_pb__c, 2770 Green Street, San Francisco, CA, 94123
agent_only_remarks__c, Property is livable as-is, but most buyers will want to make significant improvements. No Showing Time Appointments please. Please call, email or text Nina directly. Property Website: https://www.2770green.com/mls/108109801
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1910
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Natalie Kitchen
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-08-26T02:50:49.000+0000
days_on_market__c, 23
dom__c, 23
ffd_description_pb, An elegant, stately residence in one of San Francisco's most coveted enclaves, graced with magnificent craftsmanship. Inside, a grand living room with a fireplace and bay window flows naturally into a paneled dining room with French doors opening to a sprawling deck, showcasing sweeping views of the Bay. Adjacent is a half bath and a pristine chef's kitchen, equipped with a center island, stainless appliances, a pantry, and laundry. A sunny breakfast area offers French doors out to the deck, with stairs down to the garden. On the second level are 4 bedrooms and 2 bathrooms, including a primary suite with an ensuite bath, and 2 bedrooms with wonderful outlooks of the Bay and Palace of Fine Arts. On the third level is an expansive family room with windows presenting even more fabulous water views. From an entrance at the front of the home (or from the garden), one can access the hidden lower level, which contains a generous family room, a wine cellar, a powder room, a full kitchen, and a 2-car garage (tandem). There is also a covered outdoor sports court, and a magical garden featuring an actual stream running through it! It is truly an oasis in the city. This stunning home is just blocks from the Lyon Street steps and the Presidio, and a short distance from shops on Union St.
An elegant, stately residence in one of San Francisco's most coveted enclaves, graced with magnificent craftsmanship. Inside, a grand living room with a fireplace and bay window flows naturally into a paneled dining room with French doors opening to a sprawling deck, showcasing sweeping views of the Bay. Adjacent is a half bath and a pristine chef's kitchen, equipped with a center island, stainless appliances, a pantry, and laundry. A sunny breakfast area offers French doors out to the deck, with stairs down to the garden. On the second level are 4 bedrooms and 2 bathrooms, including a primary suite with an ensuite bath, and 2 bedrooms with wonderful outlooks of the Bay and Palace of Fine Arts. On the third level is an expansive family room with windows presenting even more fabulous water views. From an entrance at the front of the home (or from the garden), one can access the hidden lower level, which contains a generous family room, a wine cellar, a powder room, a full kitchen, and a 2-car garage (tandem). There is also a covered outdoor sports court, and a magical garden featuring an actual stream running through it! It is truly an oasis in the city. This stunning home is just blocks from the Lyon Street steps and the Presidio, and a short distance from shops on Union St.
