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, 1725447284
ffd_listing_title, 2567 Union Street, San Francisco, CA, 94123
ffd_mls_id, 424061416
ffd_salesforce_id, a0EUd0000031XwHMAU
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2567 Union Street, San Francisco, CA, 94123
pba__address_pb__c, 2567 Union Street, San Francisco, CA, 94123
agent_only_remarks__c, Showings by confirmed private appointment. Call or email Josh with questions or for showings 415.656.6779 [email protected]
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 6
pba__bedrooms_pb__c, 5
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central,MultiZone
ffd_createddate, 2024-09-04T02:46:53.000+0000
days_on_market__c, 1
dom__c, 1
ffd_description_pb, Located on a prime north side perch, this magnificent, one-of-a kind, completely reconstructed property offers nearly 9000 square feet of conditioned space w/ over 7000 sqft of turn-key living space on 4 levels. Ideal for entertaining, the main level boasts tremendous scale & flow w/ seamless connectivity to the south facing outdoor space. This private, wind protected oasis feels more Malibu or Cabo than San Francisco & boasts an endless pool/hot tub, outdoor shower, kitchen and multiple sitting areas. The bedroom level has 4 en suites, laundry and a private, rear facing primary. From the sky lounge, open the glass wall for iconic GGB, Alcatraz & Telegraph Hill views from the north facing walkout patio. The panoramic view roof deck is accessed through a retractable skylight. The lower level features a luxe guest suite, a state-of-the-art movie theater, wellness center, a wine room, and a spa w/ a steam room & sauna. This home was built using the finest materials available. Other features include an elevator to all lvls, parking for 6-8 cars, water filtration system, lutron lighting system, multiple wet bars, custom light fixtures, Gaggenau & Sub Zero appliances, hidden in-ceiling speakers, air conditioning, advanced audio visual, integrated security systems & much more.
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Balcony;BBQ Built-In;Fire Pit;Wet Bar
2567 Union Street, San Francisco, CA, 94123 - Property Description
Located on a prime north side perch, this magnificent, one-of-a kind, completely reconstructed property offers nearly 9000 square feet of conditioned space w/ over 7000 sqft of turn-key living space on 4 levels. Ideal for entertaining, the main level boasts tremendous scale & flow w/ seamless connectivity to the south facing outdoor space. This private, wind protected oasis feels more Malibu or Cabo than San Francisco & boasts an endless pool/hot tub, outdoor shower, kitchen and multiple sitting areas. The bedroom level has 4 en suites, laundry and a private, rear facing primary. From the sky lounge, open the glass wall for iconic GGB, Alcatraz & Telegraph Hill views from the north facing walkout patio. The panoramic view roof deck is accessed through a retractable skylight. The lower level features a luxe guest suite, a state-of-the-art movie theater, wellness center, a wine room, and a spa w/ a steam room & sauna. This home was built using the finest materials available. Other features include an elevator to all lvls, parking for 6-8 cars, water filtration system, lutron lighting system, multiple wet bars, custom light fixtures, Gaggenau & Sub Zero appliances, hidden in-ceiling speakers, air conditioning, advanced audio visual, integrated security systems & much more.
