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-04-09 10:58:51
[post_modified_gmt] => 2024-04-09 17:58:51
[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, 1707959061
ffd_listing_title, 2900 Scott Street, San Francisco, CA, 94123
ffd_mls_id, 423721163
ffd_salesforce_id, a0EUd000000GlRCMA0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 2900 Scott Street, San Francisco, CA, 94123
pba__address_pb__c, 2900 Scott Street, San Francisco, CA, 94123
agent_only_remarks__c, This is legally a 2 unit building with a housekeeping unit. Call Carrie for showings. 3 car garage plus 2 in driveway. Tons of storage or development potential. Private appointments only. No open homes or broker tour. Some photos virtually staged. Can be lived in as a SFH or multi units. Coming back in the Spring.
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 6
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-11-27T17:47:55.000+0000
days_on_market__c, 366
dom__c, 136
ffd_description_pb, Extraordinary corner residence with Golden Gate Bridge views. This stately home is reminiscent of a London townhouse. 3 floors connected by an interior staircase with wood panel detailing. Amazing opportunity for multigenerational living as 2 units or enjoy combined plus a bonus guest apartment or office. The top two floors enjoy sweeping bay views and sophisticated entertaining in the formal living room and dining room. The pent room features a cozy bar and large office / sitting room with magnificent bay views. Enjoy outdoor entertaining on the wind protected roof deck w/ GG bridge views. There are 3 bedrooms including the spacious primary suite with dressing room and en-suite bath. The 2nd floor is a full floor apartment with fabulous volume. The striking living room features surprisingly tall ceilings and abundant natural light with bay views. This floor has a formal dining room, kitchen, 3 beds, 2 full baths and one half bath. Formal foyer, 3 car parking, elevator, abundant storage. Lg yard. The best of Cow Hollow living!
2900 Scott Street, San Francisco, CA, 94123 - Property Description
Extraordinary corner residence with Golden Gate Bridge views. This stately home is reminiscent of a London townhouse. 3 floors connected by an interior staircase with wood panel detailing. Amazing opportunity for multigenerational living as 2 units or enjoy combined plus a bonus guest apartment or office. The top two floors enjoy sweeping bay views and sophisticated entertaining in the formal living room and dining room. The pent room features a cozy bar and large office / sitting room with magnificent bay views. Enjoy outdoor entertaining on the wind protected roof deck w/ GG bridge views. There are 3 bedrooms including the spacious primary suite with dressing room and en-suite bath. The 2nd floor is a full floor apartment with fabulous volume. The striking living room features surprisingly tall ceilings and abundant natural light with bay views. This floor has a formal dining room, kitchen, 3 beds, 2 full baths and one half bath. Formal foyer, 3 car parking, elevator, abundant storage. Lg yard. The best of Cow Hollow living!
