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, 1710471306
ffd_listing_title, 1515 Union Street #PH4, San Francisco, CA, 94123
ffd_mls_id, 423924683
ffd_salesforce_id, a0EUd000000KNlIMAW
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 41
address2__c, 1515 Union Street #PH4, San Francisco, CA, 94123
pba__address_pb__c, 1515 Union Street #PH4, San Francisco, CA, 94123
agent_only_remarks__c, By appointment only. Please contact listing agents.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Wine Refrigerator;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Freezer
ffd_description_pb, Welcome to grand Penthouse 4 at Union House - part of an ultra-luxury 41 unit condo complex hat was newly constructed in 2020. Located on the prestigious PH floor of the building, Union House is perfectly situated at the intersections of San Francisco's most coveted neighborhoods: Pacific Heights, Cow Hollow, The Marina as well as Russian Hill. Designed by renowned Handel Architects,PH4 offers an open island kitchen/family room floor plan, and includes 2 spacious bedrooms with 2 oversized bathrooms. The principal bedroom suite includes a generous walk-in closet. The master bath is beautifully accented by floor to ceiling Italian Carrera Marble, custom white lacquer vanities w/double sinks and Waterworks polished nickel fixtures, and a free standing Victoria+ Albert soaking tub. From the moment you arrive, you are greeted by a soaring, double-height lobby with exquisite finishes, complemented by an intimate, seated parlor w/a custom marble fireplace. Union House is a fully secure building, w/a 7-day a week doorman. The high speed elevator can only be access by each unit owner's customized key fob. Building amenities include a rooftop Sky Lounge providing direct views of the Golden Gate Bridge, Palace of Fine Arts & SF Bay. A storage locker and 1 car parking are included.
district__c, SF District 7
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Marble;Wood
hoa_fee_includes__c, Common Areas,Elevator,Insurance on Structure,Security,Sewer,Trash
1515 Union Street #PH4, San Francisco, CA, 94123 - Property Description
Welcome to grand Penthouse 4 at Union House - part of an ultra-luxury 41 unit condo complex hat was newly constructed in 2020. Located on the prestigious PH floor of the building, Union House is perfectly situated at the intersections of San Francisco's most coveted neighborhoods: Pacific Heights, Cow Hollow, The Marina as well as Russian Hill. Designed by renowned Handel Architects,PH4 offers an open island kitchen/family room floor plan, and includes 2 spacious bedrooms with 2 oversized bathrooms. The principal bedroom suite includes a generous walk-in closet. The master bath is beautifully accented by floor to ceiling Italian Carrera Marble, custom white lacquer vanities w/double sinks and Waterworks polished nickel fixtures, and a free standing Victoria+ Albert soaking tub. From the moment you arrive, you are greeted by a soaring, double-height lobby with exquisite finishes, complemented by an intimate, seated parlor w/a custom marble fireplace. Union House is a fully secure building, w/a 7-day a week doorman. The high speed elevator can only be access by each unit owner's customized key fob. Building amenities include a rooftop Sky Lounge providing direct views of the Golden Gate Bridge, Palace of Fine Arts & SF Bay. A storage locker and 1 car parking are included.
Appliances: Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Wine Refrigerator;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Freezer
